General information
Category:
Reports & Report designer
Title:
How to: Previewing a report with two cursors at the same
Dear Friends,
I try to explain the problem simply, Senario is as the following:
Please think we have a table in a database container with the name of "products", the fields are
- prd_id int
- prd_name C(30)
There is a report with the name of "rptPrdName.frx" which contains the "prd_name" field without any data environment because of using cursor which will be prepared before calling the report.
on a form we have two command button cmdRpt01, cmdRpt02
Code in cmdRpt01.click is here:
select * from MyWareHouse!products where prd_id < 11 into cursor curRpt1
report form rptPrdName nowait preview
Code in cmdRpt02.click is here:
select * from MyWareHouse!products where prd_id > 10 into cursor curRpt2
report form rptPrdName nowait preview
When I use them, it's not possible to see both at the same time, is there anyway to see multiple instance of report preview with different cursors?
Thank you in advance,
Farhad
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only