crystal report with multiple table

Question

1.00/5 (1 vote)

See more:

VB

i hav create a crystal report using one table but unable to create by two table,can u tell me how could i do this

Posted 2-May-11 19:21pm

anand4886

Add a Solution

Comments

[no name] 3-May-11 2:48am

what are the table structure for two tables you have to show code for connection and also table structure

anand4886 3-May-11 4:45am

i have two table named purchase,payment

purchase's fields are party amount

payments fields are party payment

how can i create report using both table's data in vb.net
i m using access2007

[no name] 5-May-11 12:06pm

You say "purchase's fields are party amount" and "payments fields are party payment." Are you saying that each table has only one field? To connect the tables, you'll need a field that is common to both -- a field you can use to join the two tables. Like a customer ID field, for example. Then you would join the tables together on that field.

4 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)

**theanil** · Answer 1 · 2011-10-16T08:31:00

Solution 1

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

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/c1df952d-31cb-41df-bfcb-895729e2f764/[^]

Posted 16-Oct-11 8:31am

theanil

RaviRanjanKr · Answer 2 · 2011-10-16T09:57:00

Solution 2

Try
Crystal Reports from multiple tables[^]

Posted 16-Oct-11 9:57am

RaviRanjanKr

Member 10507654 · Answer 3 · 2014-03-10T02:01:00

Solution 3

How To Create Multiple Table CrystalReport

Posted 10-Mar-14 2:01am

Member 10507654

Comments

CHill60 10-Mar-14 8:36am

Is this a question?

Member 10657750 · Answer 4 · 2014-03-10T02:05:00

Solution 4

crytal report problems rises due to the compatibility in the versions so please check with the versions you are using and conversion

Posted 10-Mar-14 2:05am

Member 10657750

Comments

CHill60 10-Mar-14 8:35am

Completely off-topic response to a question that is nearly 2 years old!