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!
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!