I am creating a BAQ report (SSRS) - the BAQ returns the results as I’d expect, but I am a bit of a novice with SSRS so I’m a bit stuck on the best way to have each result appear on its own page on the report.
The scenario, for context, is that we plan deliveries based on specific load date and load numbers. For various reasons, this will not always match need by / ship by dates, so we add this information to the OrderRel through a delivery planner dashboard.
My BAQ returns all the relevant OrderRel info, the user then inputs the load information as a parameter to generate the report. This all works fine.
Where I am a bit stuck is on how best to get each result from the (filtered) BAQ to have its own page on an SSRS report. I am a bit of a novice here, so these are probably all daft questions.
I have created a table and grouped by the relevant BAQ results (in this case, order numbers and ship to addresses), hidden the column headers and rotated the text, and added page breaks per group.
Yes it works, but it is rudimentary (and sideways).
Anyone have any suggestions for a more effective way to do this? I mean, my method does work, but it’s not great
Just to make sure I understand, so far, you have a solution that is working, but it’s not ideal, because you had to design the label basically on its side because when it prints, it would print out “sideways”, correct? If so, check your SSRS page size and orientation settings and make sure they are correct. Otherwise, you can also check your printer settings to see if there is anything there that can fix the orientation issue. I hope this helps!
Thanks for the reply! It is almost the opposite of what you’re describing (I’ve had that problem before too haha). It does actually work, but the report itself is literally designed so that the text is rotated by 270 degrees to disguise the fact that it is actually a table, and the groups are separated by page breaks. I’ve just hidden the column headings. I did try doing it by row, but I couldn’t quite get the row groups to behave in the same way as columns groups
Nobody would know otherwise, the orientation doesn’t really matter on printing because they are going to be sticky labels so the user can decide how to apply them. Just wondering what other methods might be available to separate each result onto a different page, if that makes sense!
Without a visual on the report build, it might be a little difficult to help, but I can try. Based on your responses, the first question I would have is are you using a table or a matrix? You mention that you’re using a table, but you mention column groups which I believe are only available when using a matrix. Second, are you wanting one label, per row that is being returned that is being returned in your query? If so, then if you use a table, have no groupings (besides the “details” group) then on details, set the page break to be between each instance of a group, does this give you your desired result? If not, what is the issue with it, what is it missing/doing wrong?
