reports at run time

Dear sirs
I'm trying to create reprts at run time, i'm using the following command
CREATE REPORT myReport FROM table1
but actually i want to change the labels of the fields which appear in the
report
i don't know how can i do that???

thanks
Mohammed

Eric
Wed Dec 01 08:20:25 CST 2004

Hello, Mohammed!
You wrote on Wed, 1 Dec 2004 04:21:04 -0800:

MAR> Dear sirs
MAR> I'm trying to create reprts at run time, i'm using the following
MAR> command CREATE REPORT myReport FROM table1
MAR> but actually i want to change the labels of the fields which appear in
MAR> the report
MAR> i don't know how can i do that???

You can issue the CREATE REPORT and MODIFY REPORT commands at runtime to
open the report designer. Or, if you prefer to use the FROM table1 argument,
then try to rename the field names:

SELECT field1 AS firstname, field2 AS lastname, field3 AS address, etc ;
FROM table1 ;
INTO CURSOR cursor1

CREATE REPORT yourreport FROM cursor1

--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Esparta
Tue Dec 07 00:10:53 CST 2004


You can also manipulated in a OOP basis, try this:

--- Report Objects ---
http://downloads.stonefield.com/pub/repobj.html
"This article describes how a set of classes can expose the VFP report
(FRX) file as objects. This allows you to manipulate reports
programmatically simply by setting properties and calling methods."

HTH


Mohammed Abdel-Razzak wrote:
> Dear sirs
> I'm trying to create reprts at run time, i'm using the following command
> CREATE REPORT myReport FROM table1
> but actually i want to change the labels of the fields which appear in the
> report
> i don't know how can i do that???
>
> thanks
> Mohammed