Creating a Crystal Report based on dataset

[pachjo]

Hi, I think I have found out on this forum how to dynamically link a dataset created at runtime to a reports datasource. But I am confused about how do I create the report in the first place?

How do I place the fields on the report that will link to the dataset which is not available at design time?

Thanks in advance

 

[lingsn]

1 way is to create an XML file. In the crystal report's database connection, connect to this XML file by right-click on the Database Fields, chose database expert, expand the "Create New Connection", and double click the ADO.NET, select the XML file you created before.

 

[pachjo]

Hi, thanks but I do not know XML, but I have sort of solved my problem.

Create blank report
Add dataset to solution
Add table(s) to dataset designer
Select database expert in report designer and select required tables
At runtime asign dynamic dataset to report datasource....job done

I am now working on trying to get the report header text to change accordeing to which report is required, I prsume I need to do this with a function field?

I can query which tab page is active which will tell me the required report heading but at present have not sussed out how to access the tab page index from within the function field?