Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
In my application used a crystal report. Two Table are used for datasource.
Table1 and Table2. In this
Table1.Id=Table2.head
 
I inner join two table using this fields.
some cases Table1.Id=Table2.cato is equal
Now I need to print Table1.category in the place of Table2.cato
 
Table1
 
Id Name Category
1 BAb SA12
2 Nag SA13
3 NAE SA14
4 HIP SA15
5 DRT SA16
 
Table2
Head Cato
1 4
2 4
 
OUTPUT REQUIRED Is below
 
HName Catogory
SA12 SA15
SA13 SA15
 
But I got
 
HName Catogory
SA12 4
SA13 4
 

Then how to display SA15 in the place of 4.
may Formula fields can use for this or any ..
Posted 22-Sep-10 19:53pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

In crystal report, have to have three tables
table1, table2, table3(table1 with alias as table3)
 
yes, you can add single table multiple times with different aliases.
 
link table1.id to table2.head and table2.cato to table3.id
and now, place table1.category and table3.category in crystal report
 
That's it. It should do the trick for you. Thumbs Up | :thumbsup:
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web01 | 2.8.141022.1 | Last Updated 4 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100