fields in crystal reports

[IainK]

I need to create a template in crystal reports that will access information identified in a dhtml form. There are several tables in the database, and the relevant table will be identified in the dhtml form.

How do I create a field in crystal reports (version 7) that will upload different information depending on the user input?

Cheers,

- Iain K

 

[balves]

I'm not sure what you mean by a template. If you have different queries that return different fields from different tables, then you're going to have to build more than one report.

If it's possible that each separate query will return the same number of fields, with the same data types, in the same order, then you could build one report and pass an ADO recordset to the report at run-time. However, this is usually not the case.

If you build multiple reports, then on the ASP page, you'll have to decide which report to execute. Either by the user picking a particular report from a list, or by entering certain parameters that will tell you which report to run. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer