Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Creating a SSRS report that emulates an order Pick Ticket Expand / Collapse
Posted Tuesday, May 7, 2013 10:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 1:28 PM
Points: 1, Visits: 9
I need to create a report that will emulate what our warehouse uses as a “Pick Ticket” for pulling orders. The user wants to enter multiple ID’s that represents different orders, and have returned a page that can be printed for each order. Some orders will have multiple pages, i.e. 1 of 4 pages.
In the database, we are reusing columns such as Quantity01, Quantity02, etc. For the 11th product, we are populating the Quantity01 field for the 2nd time. This is done each time we go beyond the 10th product. The problem I have been facing is, when using a table, it tries to grow automatically to accommodate the 11th product and so on. I have found a way, using the Page break option, to force the results to the next page after the 10th product. The problem with this is the change is only effective for the middle section of the report. The top section and bottom sections do not push to the next page.

As far as I can tell, I cannot use headers and footers b/c of how the user wants to run the report. If you pass more than 1 order ID into the report, it will populate the middle section with the appropriate order items, however the header and footer values will continue to populate the values from the first order ID it comes across. I could have the expressions in my fields wrong as well.

I need to be able to create one page that looks like the screenshot [attachment uploaded], and force it to populate the correct order values in the middle section per page, up to 10 products per page then move to the subsequent page until all pages for that one order have been completed, as well as when a new order ID is encountered, start the same process again.

I have been able to trick it to do so if I am processing only 1 order ID at a time.

  Post Attachments 
SSRS_Help_Needed.jpg (8 views, 264.20 KB)
Post #1450227
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse