General information
Category:
Reports & Report designer
>I've written a report using the Visual Foxpro (3.0b) report generator and I'm having a problem doing the following.
>
>My report is a summary showing the number of customer contact sources (paper, word of mouth, broker etc.) for a given date range. I've used a series of report variables which I've flagged tobe summed and attached these in the summary band of the report since I only wanted the totals for each source showing once when the report is run. My problem is when I've tried to calc a percentage for each group as a part of the grand total, the book states that you must declare variables in the order their used to properly work but unfortunately I'm continually getting zero for each percentage..... looks like the calculation is happening too early and the grand total of all sources hasn't been calced when the percentage happens.
>
>Any ideas where I've gone wrong ?
This is a classic problem, with a classic solution: you just can´t do it with variables. You need to calculate, *before* you list anything, the grand total, so it will be available for calculating percentages.
HTH!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only