Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I would like to add a summary page to my report in vfp50
Message
From
15/10/1997 13:43:22
 
 
To
15/10/1997 12:32:30
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00054665
Message ID:
00054718
Views:
40
>>>>>>>>>I am using the report designer in vfp50 for my report.
>>>>>>>>>I need a summary page. I added a summary page, but it is
>>>>>>>>> not printing out after the report prints.
>>>>>>>>>Any ideals?
>>>>>>>>
>>>>>>>>Did you check "New Page" in Title/Summary dialog?
>>>>>>>
>>>>>>>Hi Edward:
>>>>>>>Yes I did. My Summary page prints fine.
>>>>>>>As part of my summary, I need to post a count
>>>>>>>of one of the fields and evertime it changes.
>>>>>>>I am not sure how to put code in the report designer.
>>>>>>>Where do I look for this? - thanks
>>>>>>
>>>>>>You should create report variable (Report/Variables option) selecting field value to store and 'Count' to calculate. Then you just create report field showing the variable in summary band.
>>>>>
>>>>>I really need something like a DATA GROUPING. I need to keep
>>>>>tract of a field and everying time its value changes, I need to do the following:
>>>>>On the Summary Page
>>>>>1. print the field's value
>>>>>2. print the number of occurrences that field's value changes
>>>>>
>>>>>what can I do - should I write code and if I do, where do I put or call the
>>>>>code?
>>>>
>>>>Rob, summary page prints once for whole report. If you want to trace changes of some field, you must use report grouping and use Group Footer/Header Band to print old/new value. You can still print number of groups on summary band using two possible ways:
>>>>1. Use 'On Exit' or 'On Entry' procedures to increment variable.
>>>>or (it will be more reliable for you)
>>>>2. Just calculate 'number of groups' before running the report and store the result in variable again.
>>>
>>>I am using vfp50 and I don't see a Group Footer/Header Band? Also,
>>>where do I put 'On Exit' or 'On Entry' procedures?
>>
>>You will see them when add a group. To get 'On Entry/On Exit' double-click on any report band bar.
>
>Ed - I am still having problems.
>What are my steps?
>1. put the field's name in the data grouping box. How do I trap when
> the field value changes? Where do I store the field's value so I can
> print it out in the summary page?
>2. Do I put anything in the Grouping Band. I do not want to print anything
> there.
>I just need to get through this first one, then I will get the idea..
>Whould you please e-mail me (rob-at@usa.net) a small sample.
>thanks.. :)

Field change means group change and Group Footer will fire. I urge you to read appropriate chapter from VFP Developer's Guide.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform