SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Creating a SSRS report that emulates an order Pick Ticket


Creating a SSRS report that emulates an order Pick Ticket

Author
Message
rodneyvbass 31734
rodneyvbass 31734
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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.
Attachments
SSRS_Help_Needed.jpg (12 views, 264.00 KB)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search