How to inner join in crystal report for this requirement

Question

0.00/5 (No votes)

See more:

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

vipinsethumadhavan

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Prerak Patel · Answer 1 · 2010-09-22T23:37:00

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. :thumbsup: