>Dear all,
>is it impossible to make report with summary data groupping,
>for example i have report with invoice_no,price,product
>then i want to show total sales for product in summary page
>(data product has grouping from detail report).
>
>Please help me ?? I want to display in my report
>
> -----------------------------------
> invoice | qty | product |
> ----------------------------------
> 001 | 1 | A |
> 002 | 5 | B |
> 003 | 5 | E |
> 004 | 6 | A |
> .........
> ---------------------------------
> SUM | 17 | |
> ----------------------------------
> Summary of Report
> PRODUCT A = 7
> PRODUCT B = 5
> PRODUCT E = 5
>
>****** End of Report **************
>
>
>Best Regard,
>
>
>Leosan
I usually prepare a cursor with all the information (including the summary lines) in advance. Or there could be two cursors. Which VFP version do you use? I believe, it could be achieved in VFP9.
If it's not broken, fix it until it is.
My Blog