Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding detail under the detail to existing report
Message
From
29/03/2012 10:54:40
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01539674
Message ID:
01539675
Views:
45
You'll have to pull the Item info into a group header and make the Discount the detail

>Hello there,
>
>I need to modify a report, it's an invoice report. This report has a cursor1 for the header (customer info), cursor2 for the detail (items bought), now I have some data that needs to be added to the report, basically every item bought needs to have discount data displayed. So the invoice should look like this, right now the first 2 levels are there, I have to add the third level (Discounts)
>
>--- Customer
>---------- * Item 1
>---------------- - Discount 1
>---------------- - Discount 2
>---------------- - Discount 3
>---------- * Item 2
>---------- * Item 3
>---------------- - Discount 1
>---------------- - Discount 2
>
>I usually do a big query to get all the data in a cursor then do my groupings in the report but if I can avoid that then I'll save myself some redesigning issues since it's a messy report. Any ideas on how to implement this?
>
>Thanks!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform