Can Crystal automatically format ad-hoc data?
I'm using Crystal Reports XI with the RDC component embedded in a custom VB6 application. The VB6 app does parameter selection and SQL data retrieval before passing the ADO datasets to the report object (oCRXReport.Database.SetDataSource).
Increasingly I'm getting requests from users to see special data excerpts. I can either write a quick SQL statement and paste the Query Analyzer results into Excel, or I can go through the labor-intensive process of creating a new Crystal report to format the columns etc.
Is there any way to combine the two? Can I throw a random ADO dataset at a CRX report object, and have it return a super-basic report showing the rows and columns (with column headers = field names)? If so, how would I do that?
Note that I am NOT asking about giving the users direct access to Crystal Designer, because they do not have direct access to the database (and they wouldn't know how to deal with its multi-tiered structure if they did).