April 23, 2015 at 12:37 pm
Guys, I have a stock report which can run for multiple stores.
I have a tablix which sorts by STORE - I am using this like an old style List control and logical page break on change of STORE
Within the details cell I have a text field with a formula to concatenate the store name and description
I then have a nested tablix which groups by PART and BIN
In the details of the nested tablix are the bin ID, qty, extended value in columns (multiple column in nested details, but only one column in outer tablix)
When I select multiple stores and view the report in web rendering, each store with its location details is correctly displayed on a new 'page' (i.e. navigate left and right to change stores)
The problem comes when I want to render the report for print; If the stock listing for a store runs over more than one page, then the part groups re-display their headers correctly, but the store header is not rendered. This is a problem as if the page becomes separated from the report, you have no way of identifying which store it belongs to.
In Crystal Reports, you would put this information in the Page Header, but as SSRS does not have the concept of Page, how do you get a field to re-render on each printed page.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply