Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to: Previewing a report with two cursors at the same
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
How to: Previewing a report with two cursors at the same
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01109563
Message ID:
01109563
Views:
56
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
Map
View

Click here to load this message in the networking platform