VB.NET and Crystal Reports - datasets and more

Question

I'm not sure if this is even possible but here goes:

Currently I have a crystal report with a few header fields and detail lines ( of course) I pass a dataset containing a header datatable and a detail datatable. Everything works as expected... as long as I have only 1 record in the header table. What I would like to be able to do is somehow make the report "repeat" if there are multiple records in the header datatable. Is this possible? Any ideas?

Answer 1

I believe the report header will only appear once. You could insert a group, and bind the group to the data in the header datatable, then remove the default header and footer rows that are added when you add a table to a report. This might mean adding the data in your detail table as a sub-report, and putting the sub-report in detail area.

Answer 2

you can create a crystal reports from dataset at runtime

http://vb.net-informations.com/crystal-report/vb.net_crystal_report_without_database.htm

or try this dynamic crystal reports

http://vb.net-informations.com/crystal-report/dynamic_crystal_report_from_sql_query_string.htm

bolton.