crystal report with multiple table

Question

0.00/5 (No votes)

See more:

I have two tables named purchase, and stock

Purchase contains 4 fields-:
                            partname-text
                           invoiceno-number
                           purchasedate-date&time
                           amount-currency
Stock contains stock fields-:stockcode-text
                            stockname-text
                            invoiceno.-number

Can you tell me how can I add these two tables in a crystal report dynamically
when i will give the invoiceno. the report should show content of both table
thank you

Posted 9-May-11 22:08pm

anand4886

Updated 10-May-11 8:57am

thatraja

v3

Add a Solution

3 solutions

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)

cuteband · Answer 1 · 2011-05-09T22:15:00

Solution 1

the easiest way to do this is to create a sub report of each of the table you need.

Posted 9-May-11 22:15pm

cuteband

Comments

[no name] 10-May-11 6:21am

why Subreport?

MaulikDusara · Answer 2 · 2011-05-09T23:25:00

Solution 2

follow this link
http://vb.net-informations.com/crystal-report/vb.net_crystal_report_from_multiple_tables.htm[^]

Posted 9-May-11 23:25pm

MaulikDusara

Sandeep Mewara · Answer 3 · 2011-05-09T23:52:00

Solution 3

Either merge the two tables into one or use sub-reports.

For Sub-reports in Crystal report, look here:
Adding a Subreport to the Original Report[^]
Creating Sub-Reports Using Crystal Reports[^]
Create a Subreport in Crystal Reports [^]

Posted 9-May-11 23:52pm

Sandeep Mewara

Comments

[no name] 10-May-11 6:21am

why Subreport?

Sandeep Mewara 10-May-11 6:27am

Because you need to display data of two tables in one report.

[no name] 10-May-11 9:46am

we can display in one report also

Sandeep Mewara 10-May-11 11:09am

Yes we can using subreports.

[no name] 11-May-11 1:05am

if we can using single report so why to use subreport?

Sandeep Mewara 11-May-11 1:25am

For maintanece and ease of implementation. Further, if there is no relation in your tables, it would be difficult.

[no name] 11-May-11 9:45am

if there is no relation between my two tables, how it would be linked to subreport.

Sandeep Mewara 11-May-11 10:18am

Dude, did you went through the article links above that I have shared across:?