Crystal report from dao recordset, need to make new page in report for each new record in set

[michelle URGENT!!]

I have a Crystal Report that I want to pull info from my VB program,
specifically from a recordset, data control or list box - not
directly from a database table. The data returned to the recordset,
datcontrol or list box is based on an sql query dependent on
variables user inputs. I never know how many variables (records)
might be returned, it could be 5 or it could be 20. The Crystal
Report can access the first record but does not create new pages for
subsequent records. I also want to stay away from creating a temp
database table. I am using Crystal Reports version 5. Thx!

[Arthur Wood]

Michelle,
Can you place an instance of the Crystal Reports Report Viewer in you
application, pass the report the selection parameters and use the RecordSelectionFormula
property of the report to generate the same query to retrieve the data for
the report.

You might want to look at the Sample VB Apps which Seagate provides with
Crystal Reports (if you have access to the samples). I have CR on my machine,
nad they have a sample Hotel applicatin which generates a "Customer Bill"
as a CR Report, with the query based on Customer and Date-drange, which are
user selecteable.

Arthur Wood



"michelle URGENT!!" <mwhalen@hotmail.com> wrote:
>
>I have a Crystal Report that I want to pull info from my VB program,
>specifically from a recordset, data control or list box - not
>directly from a database table. The data returned to the recordset,
>datcontrol or list box is based on an sql query dependent on
>variables user inputs. I never know how many variables (records)
>might be returned, it could be 5 or it could be 20. The Crystal
>Report can access the first record but does not create new pages for
>subsequent records. I also want to stay away from creating a temp
>database table. I am using Crystal Reports version 5. Thx!
>