Reports Giving Different Results

owiccrossett

Hi,

I am a new user to Navision and have been trying to teach myself as much as possible but I am stuck on a report.

I have two different companies that are using the same report. It is a packing List that essentially just shows what is on a sales order. My problem is that when I view the report in one company it looks great, on the other company it gives me different results such as the field "Unit of measure" puts and entry on each line even the ones that are blank.

it looks like this:

Item No. Unit of Measure
Item 1 Each
Item 2 Each
Item 3 Each
Each
Item 4 Each
Item 5 Each


Now I do want that line that is blank to be blank because for our customers it shows a different group of items we are selling. In the other company the same report gives this as the results:

Item No. Unit of Measure
Item 1 Each
Item 2 Each
Item 3 Each

Item 4 Each
Item 5 Each

Which is exactly what I want.

Is there some global features that have not been "turned on" in the one company that causes this error?

Anything would be a help. Thanks in advance.

:?

Alex_Chow

Hi, this is most likely something that your programmer will need to address.

The unit of measure variable is probably not cleared when it's printing the blank line.

David_Cox

Also they can conditionally skip blank records.

owiccrossett

Thanks. I figured it out.

I used the formula:


IF TempSalesLine.Quantity = 0 THEN
CLEAR(RestockText);

And it worked...

David_Cox

Try this to skip the line

IF TempSalesLine.Quantity = 0 THEN
CurrReport.SKIP;

themave

I know you say it is solved, but the complete answer most also be that each company has a different report, because if it is truely the same report, either the report would print the line in both companies, or it would skip the line in both companies. So, if you want to solve the problem without figuring the programing change needed. you could copy the correct report to the second company and not worry about it.