Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a field in the header of the report
Message
From
05/03/2015 08:06:29
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01615930
Message ID:
01616278
Views:
58
>>>>>Yes, I was thinking about it.
>>>>
>>>>Thinking will not help. It needs coding.
>>>
>>>We don't have access to Report's events from within VFP when we modify the report. My idea also produced an error 'File is in use'.
>>>
>>>But luckily for this report we just placed the information in the Group Footer and therefore all worked.
>>
>>??
>>If you modify the frx , you have access to anything. (I mean via code not via designer)
>>You can open the frx with USE, and alter the fields. I do not know the fieldnames without searching, but you can REPLACE the code as well as the binary fields. Possibly from a template hidden into your program.
>>Duplicate the frx, alter the duplicate, run the duplicate, delete it.
>
>You don't understand. The creating Report Layouts is a feature of our application. From VFP application we allow people to create their layouts using MODIFY REPORT in run-time. Certain things are not available in run-time for that.
>
>We need to be able to achieve the goal using MODIFY REPORT in run-time from the application.
>
>As I said, for this particular report we were lucky of being able to put the info in Group Footer.

If you can run MODIFY REPORT, the report file is available.
You can modify it using DBX / SQL commands the next line of code after MODI REPO. There is nothing more you need. Maybe you have to learn how a frx file is build and used, how it stores code and so on, but it is available. It might not be porcelain code like APPEND PROCEDURES.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform