Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to set the Copies count
Message
 
To
04/07/2000 14:39:10
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00388091
Message ID:
00388136
Views:
11
>Hallo Nick
>how can I set the copies in the FRX Expr Memo field?
>Thanks and
>regards
>Winfried

For example:

lnCopies = myCopiesNumberFromSomewhere
lcCopies = "COPIES=" + ALLTRIM(STR(lnCopies))

* Make a copy of the report
COPY FILE myReport.frx myReport1.frx
COPY FILE myReport.frt myReport1.frt

* Or:
USE myReport.frx IN 0
SELECT myReport
COPY TO myReport1.frx && FRT is automatically copied too.
USE

* Replace number of copies in the copy of report
SELECT 0
USE myReport1.frx
REPLACE expr with STRTRAN(expr, "COPIES=1", lcCopies ) && "COPIES=1" is default value.
USE

* Run the report
USE SomeSourceTableForReport
REPORT FORM myReport1 ...


Note, I make a copy of your report before editing it. This way your original report is never edited and has less chance to be corrupted.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform