Click here to Skip to main content
12,824,299 members (40,379 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB VB.NET
In my application used a crystal report. Two Table are used for datasource.
Table1 and Table2. In this

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


Id Name Category
1 BAb SA12
2 Nag SA13
3 NAE SA14
4 HIP SA15
5 DRT SA16

Head Cato
1 4
2 4


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 20:53pm

1 solution

Rate this: bad
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 to table2.head and table2.cato to
and now, place table1.category and table3.category in crystal report

That's it. It should do the trick for you. :thumbsup:

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170308.1 | Last Updated 4 Feb 2013
Copyright © CodeProject, 1999-2017
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