Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Executing code in Report.DE BeforeOpenTables
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Executing code in Report.DE BeforeOpenTables
Miscellaneous
Thread ID:
00555192
Message ID:
00555192
Views:
59
Hi everyone,

These news got me absolutely shocked, I can not concentrate on finding a solution here, so I'm asking for help.

I added this code into DE.BeforeOpenTables of report:
set talk on
select db.county, db.towncode, db.FY,  Towns.FullName as city, count(*) as GrpCnt ;
       from dbf() db, Lookups!Towns ;
       where db.county=Towns.CABBREV and db.TownCode=Towns.TownOld ;
       group by 1, 2 ;
       order by 1, 4 ;
       into cursor curPrntReport
select curPrntReport
set talk off
And I added this code into DE.Destroy:

use in select('curPrntReport')

Report uses default DS. I want to close Towns table, if it was not opened before. I don't want to use public variables (though it seems to be necessary here). Do you have other suggestions?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform