how to combine two or more data table into single data table in Crystal Report

Question

0.00/5 (No votes)

See more:

Hi i have two data tables have to combine two data table into one data table and need to use the combined data table into report source for crystal report.

i merged two data table but in the crystal report it displaying more no pages not showing combined data table values into single page.

Posted 13-Nov-13 8:06am

vivekpazhani

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)

ridoy · Answer 1 · 2013-11-13T08:11:00

Then need to see your code. Do you use datatable.merge to combine to 2 datatables? Basically it would like:

C#

DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataTable dt3 = dt1.Copy();
dt3.Merge(dt2);

Some good alternatives may be:
DataTable.LoadDataRow Method [^]
DataTable.ImportRow Method [^]

vinay.Singh · Answer 2 · 2013-11-13T16:33:00

Hi you can use DataTable.Merge Method to combine the two data table values. have look of the link

http://msdn.microsoft.com/en-us/library/fk68ew7b%28v=vs.110%29.aspx[^]

http://forums.asp.net/t/1416974.aspx[^]

OR

you may go for sql view. just make sql view and then use that view to populate the data on report. This improve performance and you will be able to get the record in a single datatable.

Muthu Karunarathna · Answer 3 · 2013-11-13T18:54:00

Rather than adding two tables you can simply do it by creating a view in database.then crystal report will be much more easier.

example:

table 1:student(sid,sname,scid)
table 2:course(cid,cname)

student scid is referenced from course cid.you can create view,

create view studentcourse
as select s.sid,s.sname,s.scid,c.cname
from student s,course c

now you can access view as a single data set but there are all the columns you need.
this is really easiest way.i do it all time.

how to combine two or more data table into single data table in Crystal Report

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0