Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir Ibrahim
  Where is Samir Ibrahim?
 Chekka
 Lebanon
 Samir Ibrahim
 To: Syed Imran Ulhaq
  Where is Syed Imran Ulhaq?
 Jeddah
 Saudi Arabia
 Syed Imran Ulhaq
 Tags
Subject: RE: Columns in Report
Thread ID: 209395 Message ID: 209758 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Wednesday, December 31, 2008 12:16:37 AM         
   


> Dear members
> hi
> Can we expand report columns based on table values.
> Like I have a table with fields, opening_date,Amount,Customer
> based on opening date's month amount should reflect in month column.
> like
>
> cutomer opening_date amount Jan Feb .. Dec
>
> if user selects july-dec period jan-jun columns should not appear, adding print when removes the value but empty space appears in report.
>
> can we have columns in report based on from-to dates or is there any way to adjust columns.
> thanks
> regards,
> Imran

Yes, That can be done.

See my download file, it contain an example of how you will be to create report on the fly (rotf) in addition the ability to expand field width on the report.

things you should make.

#1 in your report, double click on the the first field in detail line, in the print when expression you put xfield1 and in the comment section you put "something1"
do the above for every field in the detail line in your report just for second field put xfield2 different name in the comment

#2 selecting fields in the cursor should be >= from the fields on the report
suppose you have table with 5 fields, and there is 7 fields on the report in the detail line, your query should be select * from mytable,"","" I add 2 "" "" just to make the fields number = 7

#3 double click on each object in the report in my download and check the print when and the comment for each one to understand how this class work

https://www.foxite.com/uploads/b00c3a4b-cdf6-417e-b15c-67f09b825c05.zip

Samir R. Ibrahim
Good things Take time, Great things happend all at once. My WebLog My Website: www.cdcity.org

ENTIRE THREAD

Columns in Report Posted by Syed Imran Ulhaq @ 12/28/2008 10:23:44 AM
RE: Columns in Report Posted by tushar @ 12/28/2008 10:25:48 AM
RE: Columns in Report Posted by Srdjan Djordjevic @ 12/30/2008 3:31:56 PM
RE: Columns in Report Posted by Samir Ibrahim @ 12/31/2008 12:16:37 AM
RE: Columns in Report Posted by Syed Imran Ulhaq @ 12/31/2008 2:38:50 PM
RE: Columns in Report Posted by Yousfi Benameur @ 12/31/2008 7:55:21 PM
RE: Columns in Report Posted by Syed Imran Ulhaq @ 1/1/2009 6:45:49 AM
RE: Columns in Report Posted by Yousfi Benameur @ 1/1/2009 2:45:49 PM
RE: Columns in Report Posted by Yousfi Benameur @ 12/31/2008 10:47:02 AM