I take it all back, I am using the sql server connection. I am using sqlserver views and XtraReports to generate reports in a vb.net project. (obviously I am more oriented to VFP than vb.net). The view is used as the basis for a dataset. The user can then enter or choose various parameters to operate against the dataset (view). I may be confused about how views work in sqlserver, but it appears to me that if the view creates a dataset then that dataset will be populated with all possible records. The report then applies a filter to the dataset and prints.
What I would like is the equivalent to vfps nodataonload for the dataset. Is this possible or have I completely misunderstood how things work?
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!