Click here to Skip to main content
11,639,765 members (59,610 online)
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)

  Print Answers RSS
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558


Advertise | Privacy | Mobile
Web04 | 2.8.150731.1 | Last Updated 4 Feb 2013
Copyright © CodeProject, 1999-2015
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