I decided I'd go with crystal reports for an app I'm developing in .NET. I'm using the built-in Crystal Reports control. I have *several* reports that need to be made, some are parameter and some aren't. Ultimately my goal is develop a lot of different and not spend a huge amount of time on it and not distribute a lot of unnecessary files with my application.
My thinking was to do this. Create a TTX file, then create the report based off that TTX file, and at runtime fill it with a dataset that was filled by a DataAdapter (OleDB in this case) and make that the datasource.
So, ok I created the TTX and made the report design, I accepted all defaults really after setting the Grouping that I wanted. Then I set that data source of the report to my dataset (which I created through code, not with the "generate dataset" and all that ). So what happens is that when the report viewer opens it shows the formatting I made and all that but no data is there and I created a DataGrid on the same form which uses the same dataset and it has all the data there.
What I'm looking for is an answer to how can I achieve my goal the best, I want it to be versatile and not spend a huge amount of time on it. What do you guys suggest and how can I fix this problem? I have tried setting the data source of the report to a datatable but that results in "Query Engine Error" from the Report Viewer. I have even tried to set the report's data source to "da.Tables(0)" and that yields nothing. This particular query is very simple.
Thanks for your help. (This is urgent and may be involved, hence all the points).