Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report and Subreports with Datasets

Status
Not open for further replies.

RLVDB

Programmer
Oct 25, 2004
3
GB
Hi gurus
In the Past long ago, in a land far away, I always had to set a report datasource to a Stored Proc in SQL to get the results I wanted. Now we can Generate an ADO.net Dataset which means we don't have to link Servers and Databases to a report. I use an XML file to determine the required fields. Now I am pushing it a step further. I need to create a Report with a number of SubReports. The Stored Proc returns 4 Tables in its Dataset.

Can I create 4 Reports, which serves as subreports, and pass the dataset tables to each subreport:
Mainreport - dsDataset.Tables(0)
Subreport A - dsDataset.Tables(1)
Subreport B - dsDataset.Tables(2)
Subreport C - dsDataset.Tables(3)

How would I do this in code?

I was advised to buy this fabulous book by Brian Bishof (Crystal Reports.Net Programming), but there is no code samples for this exercise.

Blessings
Len

Quite as a bulldozer mate!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top