Data Report environment help needed!!

[Joe L.]

Hi guys, I am working on a data report and I have
a form that uses multiple queries and adodc recordsets.The form allows you
to select a few drop down boxes and basically boundcolumns all the primary
keys needed to find get down to one record in the database which i need to
push into a report. I need the report to either just suck it
off this form, or to run the same queries by grabbing the OrderId,
VendorId, etc off of the form. Ive read through books, online help, etc
and tried playing around with setting up different types of test scenarios,
but I am unable to get all the data accross. Is there any advice
or logically way of going about in doing this? I only want the report to
show one record... not every record in my entire database. Thanks!


Joe Liu

[Paul Clement]

On 18 Dec 2002 16:25:07 -0800, "Joe L." <joe_liu@credence.com> wrote:

¤
¤ Hi guys, I am working on a data report and I have
¤ a form that uses multiple queries and adodc recordsets.The form allows you
¤ to select a few drop down boxes and basically boundcolumns all the primary
¤ keys needed to find get down to one record in the database which i need to
¤ push into a report. I need the report to either just suck it
¤ off this form, or to run the same queries by grabbing the OrderId,
¤ VendorId, etc off of the form. Ive read through books, online help, etc
¤ and tried playing around with setting up different types of test scenarios,
¤ but I am unable to get all the data accross. Is there any advice
¤ or logically way of going about in doing this? I only want the report to
¤ show one record... not every record in my entire database. Thanks!

The DataReport operates in data bound mode so whatever you can pull in via a Recordset you can bind
to a DataReport as runtime:

HOWTO: Bind a DataReport To an ADO Recordset at Run Time
http://support.microsoft.com/default...;en-us;q190411

HOWTO: Refresh a Parameterized DataReport
http://support.microsoft.com/default...;en-us;q244779


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)