Having more than 1 datasets in Crystal Report.....It is simply killing me

Dear all,

I have absolutely no clue how to do now, I am having a lots of parent and child tables in the database, and I tried to insert the fields into the crystal report, it's fine, but when I code the report,it does not allow me to have more than 1 dataset in 1 report, now I am stuck....can anyone help?

Hey Playkid.

I guess the main question is what are you trying to do with this? Are you looking for one report that will take data from these datasets?

You are right, CR only likes to work with one datasource. But, your query can join multiple table and you can pass that dataset to your CR.

Or you can try a sub report in that report

or you can create a linear query that inner/left/right all the datatables you want in one datatable, and pass the result to the cr. after that you can group them inside the report by adding a new group section to have the master/details like if you want

or you could create a temporary table to print the report.

Regards
Jorge

My GOD.....this is just another kind of knowledge on crystal report, driving me mad...
it's still not working.....
the learning curve for crystal report is away more steeper than VB.Net

Quote:

---

the learning curve for crystal report is away more steeper than VB.Net

---

AGREED

since tomorrow is my project's due date, I am using Office Automation rather den Crystal Report, it is much easier in programming....