Reports Giving Different Results

owiccrossett · 2006-08-07

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 · 2006-08-07

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 · 2006-08-07

Also they can conditionally skip blank records.

owiccrossett · 2006-08-07

Thanks. I figured it out.

I used the formula:

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

And it worked...

David_Cox · 2006-08-07

Try this to skip the line

IF TempSalesLine.Quantity = 0 THEN
CurrReport.SKIP;

themave · 2006-08-07

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.

Reports Giving Different Results

Comments

Categories