Help with Printing Reports

[redshadow]

Hi,

I am new to Visual Basic and I'm previously using Visual Foxpro. I used to do this in VFP:

select * from orders where orderID == thisform.txtOrdID
report form rptOrders preview

How could I do the same in VB with its Crystal Report?
For now I have tried Crystal report but I am asked to specify which fields I have to include and what if I have to execute first a query and create a new cursor that have multiple fields generated based from let's say three tables. In VFP I only need to type the name in the field list so it could act as like a variable, but in Crystal report I don't know how to do it since I am asked with the existing table.

Any help will be greatly appreciated, thanks.

 

[Hackster]

Crystal Reports is a very strange animal sometimes. I have two VB6 apps that use Crystal Reports. One app has 51 reports associated with it, and the other app has 47 reports.

Both apps runs off an Oracle 8.0 backend. In order to print reports, I must create a recordset, and then based on the recordset members, programmatically create a table in a local Access database, and populate it with the recordset results. The associated Crystal Report File is bound to this table. Before the next time the report is run, I DROP the table, and then recreate it with the new recordset.

I inherited these two apps. I use Access Reports with the apps I've developed from scratch.

 

[redshadow]

well, it seems I have to do the same. Thanks for the tip anyway it gives me an insight