How Do I Show Multiple Tables In A Crystal Reports

Question

0.00/5 (No votes)

See more:

I'm working on designing a crystal report. I need to display two tables on one page. (In other words, two details sections on each page).

Both the tables have independent records of each other. e.g.
Table 1 columns are:

|Item No | Item Name | Date | Qtty Sold | Selling Price |
Table 2 columns are:

Item No | Item Details | RemainingQtty |
Table 1 has 30 rows and table 2 has 5 rows

Can someone help me out how to achieve this?

Many thanks,

Posted 15-Jan-15 1:04am

TusharZoo

Updated 16-Jan-15 2:14am

v2

Add a Solution

Comments

DamithSL 15-Jan-15 7:44am

http://scn.sap.com/thread/3183366[^]

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)

.Net Jim · Answer 1 · 2015-01-15T08:12:00

What you can do is to use a view in your database and fool crystal reports. Just be sure to use a prefix to help you tell the two table columns apart. A view is a mapping of one or more tables in a database to LOOK like one table when you use the view in a select statement. The underlying tables are not modified in any way. You can say

select tbl1Col1, tbl2Col1 from myView

instead of saying

Select tbl1.col1, tbl2.col4
from tbl1
inner join tabl2
on tbl1.fkcol=tbl2.pkcol
where tbl1.myCol>15 and tbl2.yourCol=21

this LOOKS like one table from the query and the underlying tables are not modified in any way. Crystal will never know the difference, just make sure that the view is used.

Warning: I am sure that crystal experts won't like this approach, but it will work without doing any damage and minimal confusion. It also helps if you use a prefix in the view name to hint that its a view (e.g. vw_MyTable or vwMyTable). The crystal experts would want you to tell crystal about both tables or do an inner join sql statement in crystal.

Read up on sql server views here.[^]