Create a Report dynamically

[Bamboosch]

How can I create Reports dynamically? <br><br>My Tables and StoredProcedures are changing very often, so i can´t work with static reports...<br><br>It is possible to link a Recordset from my Database with CR(7.0), so that it creates a Report depending on the fields in the Recordset? <br>

 

[Guest_imported]

From my understanding no.&nbsp;&nbsp;You need to identify the tables and fields at design time.&nbsp;&nbsp;You can change the datasource, sorting, record selection criteria, group selection criteria, and even the actual functions (can't add new ones though), but the tables and fields are fixed.&nbsp;&nbsp;How about if you pack the fields into a string field and feed that through via ADO (ugly).<br><br>What about database views?&nbsp;&nbsp;You can use crystal reports on views rather than real tables, and let the database view handle the changing underlying database tables structures and fields. This assumes that the data fields and tables don't change for the information you are reporting on.

 

[AAP]

Perhaps Crystal reports is simply the wrong tool for this job?