Order Report Printing

[Borvik]

We print reports all the time. Doesn't everyone right?!

But when printing them we go through quite about 5 reams of paper in less than a week. This is because when printing the reports, it also prints the records for the orders that have all items backordered.

Here is a screen of an invoice template we use.

http://borvik.gotdns.com/screens/Invoice.bmp

If the entire column of the marked field is 0 it should not print that order. How can I do this?

 

[winthropdc]

You can use a conditional calculated field to suppress lines in the report that you don't want printed.

If there is already a suppress being used on that report section, your new conditional field must return 0 for the true case (ie don't print) or the previous supress field if it is false (ie. print as it did before).

If there is no suppress then, just return 0 and 1.

When in Layout mode look at Tools >> Section Options off the menus. The suppress for the body is on this window and you can open additional headers and footers to see their suppress settings.

David Musgrave [MSFT]
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[Borvik]

I'll take a look at the setup we currently use, when I get back into the office on Monday - and try your suggestion.

 

[Borvik]

I'll take a look again at what we're using when I get back to the office on Monday. I'll try your suggestion then too.

 

[Borvik]

Sorry about the semi-double post, my computer didn't respond - and I didn't see my previous post. Anyway....

I took a look at what you suggested, and it doesn't appear to be working.

I've created a calculated conditional field. True case is 0. False case of 1. The condition: (C) Total Backordered = SOP_LINE_WORK.QTY. I've also set the body suppress to my calculated field. Now if my understanding of what you suggested is correct, this would suppress each line of the body where the B/O field is equal to the Ordered field (as shown on the report). I've tried printing (to screen) and the line still shows up.

Also, what we're looking for is actually to stop the entire report from printing, if that particular Order has no items shipped.

 

[Borvik]

Alright, I've figured out what the problem was.

Apparently the user I was using didn't have access to use the modified reports. After I set that, everything just started working. Including the report restrictions.

That was how I fixed the original problem as well. Added a restriction like so: SUMMATION(SOP_LINE_WORK.QTY_TO_INVOICE) > 0.

Solved the problem.

Thanks for your help.