I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

(0) Share

Report

Posted on by Brian Girard

440

*This post is locked for comments

All responses (18)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

RE: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

Brian,

Did this work for you???

Kind regards,

Leslie
Hiroki 5 on at

Like (0)

Report

RE: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?
Brian Girard 440 on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

Hi Leslie,

I tried emailing you but not sure your spam blocker let me through. You can email the report package to bgirard@divbio.com. Thank you.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

Brian,

Give me your e-mail address and I can send you a .package file containing my modified report.

Kind regards,

Leslie
Brian Girard 440 on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

yes Leslie thats exactly what I am looking for. now how did you do it? i have it sorting but it is still printing one page per item. i must be missing a setting somewhere
Community Member Microsoft Employee on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

The way Leslie described worked perfectly for me as well.
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

Richard, please take a look at my screen shots. As far as I can tell, It works as I described it.
Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

You must first sort by the document number (and page when it changes) then as a second sort, sort by the short name. I tried this several years ago and found the best solution was Accountable Forms Printer and do the sorting/paging in Crystal or SSRS.
L Vail 65,271 on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

Interesting,

I need to go look at my test way more carefully to see how it fooled me. I wonder if you could modify the Picking Ticket to look like at invoice/Packing Slip. Then you could put the Item Short Description information in the Bin Number field and print the Picking Ticket sorted by bin number form as your invoice/packing slip.

Ok, I'm not going crazy. I repeated my test. I printed the packing slip and you can see I have a single sheet with each of the items in Item Short Name order. I put the Line Item Sequence on the report so you can see the items did not print in sequence order. Isn't this what you are looking for? This is 3 pages because it is a long invoice.

Kind regards,

Leslie
Community Member Microsoft Employee on at

Like (0)

Report

Re: I am trying to sort items on the SOP Packing Slip form by Item Short Name. I enter the parameters and it sorts but puts each line item on a separate page. How can I get it to sort on a single page?

I just tested again adding table Item master and sorting data with item short description. This did not affect the paging of the report. You may want to look into other modifications, if any, to find the problem.

If you want you can email me the report package file at ruby AT saci.com . I will try to find problem.