Passing an ADO recordset, created at runtime, to crystal reports??

[stuartgmilton]

Hi,

I'm having problems passing recordsets to Crystal. I have managed to do the simple example where you know what fields to expect back.

My problem lies in the following;

Imagine that a SYSTEM can have multiple PARTNERS.

I wish to print a report which displays PARTNER information for a single SYSTEM. This information is broken down into days of the month. So imagine a cross tab layout.

Now for the big question - How do I go about creating a report, which is based on the above schema, when I don't know how many PARTNERS there are going to be?

Any help would be appreciated.

Stuart

 

[kenhamady]

Include 3 fields in each record of the recordset (Date/System/Partner), create the report with these 3 fields, and create a crosstab in the report. Let CR create the cross-tab layout. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[stuartgmilton]

Thanks for the prompt reply,

Thats how I thought of doing it, but what happens if I try and add another variable. ie;

1 system.
1 record for each day (y axis).

The x axis is then split in two, half for daily production and half for cumulative production. Both of these are further split into the PARTNERS.

I apologise if I am not describing this as well as I could.

Stuart

 

[kenhamady]

Yeah, you lost me there. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[stuartgmilton]

Sorry about that,

I think we may have succeeded in working out how to go about doing it.

It's just a case of doing it now.

Thanks for the help, but I'll post again, if this doesn't work.


Stuart