Report Generation

sridhar · 2006-01-30

I have an exercise where in I have to view all the customers placed an sales order.

I have used two tables, Customer and Sales Header(Intended).
I have set the DataItemLink ("Sell-to Customer No." of Sales Header and "No." of Customer Table).

But I m getting the list of all the customer. I want to see only the Customers who were placed the sales orders.

what I have to do?

admoretutsie · 2006-01-30

In your second Dataitem, set the property PrintOnlyIfDetail to true.

sridhar · 2006-01-30

Thanks,

I tried it, even then I am not getting the exact result.

N.Sridhar

admoretutsie · 2006-01-30

In that case, l think we have to do some bit of coding...l cannot think of another solution at the moment. So it goes like so.
Get rid og the second dataitem and declare a record VAR of subtype SAles Header(SHeader), and onaftergetrecord of the first item, setfilter(No.,Sell-to-Cust). Now check, if Sheader.COUNT = 0, then currreport.skip.

That must give you Customers that hav placed orders.

I hope l am getting your requirement clearly.

FPulsfort · 2006-01-30

Hi Sridhar,

you can do it with setting PrintOnlyIfDetail to true, but you have to set it in the first dataitem. This should do the work.

Regards,
Frank

themave · 2006-01-30

Just switch the order of your tables, so that Sales Invoice header is the first table and Customer is the second, This way it goes through all Sales invoice headers and pulls the appropriate customer info.

your method is going through all customers and seeing if there is a sales invoice header.

AndreasBucher · 2006-02-01

Thanks, was exactly what i was looking for :-)!!!!

sgg · 2006-02-01

what if u do something like this:

Have 1 DataItem (Customer)
Create a Variable SHeader (Sales Header)

OnAfterGetRecord of Customer DataItem add the following:

SHeader.Reset;
SHeader.Setrange("Sell-To-Customer No.",Customer."No.");
if not SHeader.find('-') Then CurrReport.Skip

Report Generation

Comments

Categories