Crystal Reports via ADO.NET
-
I've finally gotten my Crystal Reports to work with a DataSet. However, I am now facing a new problem. I created a packing list in Crystal Reports, but now we need to be able to modify how the interface reacts based on data in the report - hence, the need for using a DataSet. Because of the amount data involved, the same data that is collected in the C# and passed as a parameter field to Crystal, is being used in a WHERE clause to limit the amount of data pulled into the DataSet (if we pulled everything into the dataset every time, we would be pulling 300-500 orders 400-700 times a day - too much load.) The problem with this approach is that the DataSetis limited to the particular order that a box belongs to. Each time they try to process another box, it starts from scratch (theoretically). However, it only seems to work on the first box because something is keeping stale data. I tried disposing the dataset and dataadapters at the beginning of each try, refreshing the report object before and/or after setting the datasource method, and refreshing the reportviewer object before and/or after setting the reportsource method. All to no avail. At this point I'm at a loss as to what to do to refresh the data so that I'm not using stale data each time I run the report. Any ideas would be greatly appreciated. --In a world without fences, who needs Gates?