Reporting dynamicaly off an ADO recordset

[LV]

I need to create a report from the scratch through ASP code.
There is a sample at Seagate Web site showing how to do that reporting off an Access database. It works pretty well.

What if I need to report off an ADO recordset, which will bring different records every time(but I'll know what's in there)? In other words, can I dynamicaly, through my ASP code, report off an ADO?
Has somebody tried that?

Thanks in advance.

 

[Ruairi]

i dont see how you would be able to do it off differently structured ADO recordsets. Using VB with the RDC you can easily report off ADO recordsets, but you still need to define the structure ahead of time and design the report based on that structure. Only the number of records can change. I do use a general report to show error messages, but it is still defined as coming from data with 2 fields 'Severity' and 'ErrorText'. I can put any amount of data into ErrorText so in that sense it's dynamic, but i still knew at design time what fields to expect. Maybe that would be an option for you, concatenate the fields into a text string and send that to the report. I know it's not exactly what you asked about but i think thats as dynamic as it gets. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com