Report resume data

I have a report based on Purch. Inv. Header and Purch. Inv. lene. I can see in a period, in detail all invoices for a vendor.

Now I Want to resume al this information on a simple line for each vendor. Instead having multiple lines for a vendor with a Total Footer in the report, I pretend a simple line for each vendor with the total invoices for each vendor.

I Mantain de same report, changing the DataItemTableView property to SORTING(Buy-from Vendor No.) for both DataItem.

I create a new data Item = Vendor

But I don’t get the result ok.

Any help?

Can you show the screenshot what you try ? So we can provide you the solution

Hello Amol

Thanks for your attention. Here is my situation

1212.Documentation.docx (46.6 KB)

And the GroupTotalFields property of both dataitems are?

3146.Doc_1.docx (53.4 KB)

Use Document No.,Buy-from Vendor No. in Purch. Inv. Line dataitem…

2804.Doc_1.docx (53.4 KB)

What do you mean?

Mohana

With your idear, Use Document No.,Buy-from Vendor No. in Purch. Inv. Line dataitem. In the report I Get for Vendor 0001, 5 records , but the last one (5º) is the one I Want, because sum all the Others. For vendor 0002 I get 3 records, but the last one (3º)is the one I want becase sum the other 2.

How can I say to report to Print only the last record for each vendor.

I tried with FIND(’+’) but no result.

3782.Doc_2.docx (17.7 KB)

Hello Mohana

Any Idear?

I suggest you to go through the report logic and check how grouping works…

I tried a lot but no results.

Thanks

anyway

Use Vendor as Dataitem

Define

Pur.In Header as PurInvHdr Variable

InvoiceCount as Integer

Then onaftergetrecord of Vendor dataitem write

PurInvHdr.Setfilter(PurInvHdr.Buy From vendor No,’=%1’,Vendor.No);

IF PurInvHdr.FindSET THEN BEGIN

REPEAT

Invoicecount+=InvoiceCount

UNTIL PurInvHdr.Next=0

END

This will give Invoicecount for every vendor

3312.R50932_v2.txt (35.5 KB)Amol

Thanks for your attention :slight_smile:

I tryed your solution, as you can see in the attach.

But If I put in myFilter Report more than one Vendor, only one appears in the report :frowning:

7824.Doc_3.docx (45.3 KB)

4035.R50932_v2.txt (35.5 KB)

Thanks

Thanks for your attention :slight_smile:

I tryed your solution, as you can see in the attach.

But If I put in myFilter Report more than one Vendor, only one appears in the report :frowning:

7824.Doc_3.docx (45.3 KB)

4035.R50932_v2.txt (35.5 KB)

Thanks

Do you need any data from Vendor or Purchase Inv. Header tables?

All I need is calculated base on Ourchase Invoice Header and Purchase Invoice lines. Most information in my report are variables.

My problem is that I need the sum record for each Vendor. If my filter has one vendor nº, OK. If my filter has 3 vendor, the resulta is only one record, the first one :frowning:

In the attached doc…You put filter on Purc. Inv line…

did you try by putting vendor filter on Vendor dataitem?

Hi,

Attaching the Report for your reference. Hope this will help you.
VendorData_50006.txt (2.63 KB)

Hy Amol, thanks for your help. I tried to implement in my report, but I am not getting the same result. all my variables becames 0.

Can we mantain this structure and make some change on section only?

Is it possible to add vendor DataItem on this structure, like you suggest? Itried but no good results!

After all, this is the records I want to get. The problem is sum all of them group by vendor. It seem to be so simple but I confess that I not getting a easily solution :frowning:

Thanks
R50919_06082012.txt (34.6 KB)