April 20, 2017 at 2:35 pm
About 2 years ago at my previous company I developed SSRS reports regularly. My current company uses Crystal reports and we are looking into the feasibility of migrating to SSRS.
We're having significant issues with not being able to insert a subreport/table/matrix in an SSRS report header, so I'm looking into alternatives such as report parts.
I'm feeling a little crazy here - I keep seeing online that people use report parts in a report header, but using Report Builder I've tried to drag a newly created report part into a header and it is not allowed. I've created the report part, published it, and deployed it. I can see it in the Gallery in Report Builder. Am I doing something wrong here?
Thanks,
Jessica
What would you attempt to do if you knew you could not fail? -Robert H. Schuller
April 21, 2017 at 12:49 pm
Odds are you're just making it more difficult that it needs to be. First thing about SSRS is that there is no "report header" like there is with CR...
Before you start pulling your hair out, take a breath... It's actually easier in SSRS than it is in CR. 🙂
Just place the object(s) that you want to be in "the header" at the top of the body section in SSRS... Yup it's just that easy!
As a side note... You can think of individual tablix objects like entire CR report and/or subreports... and... you can place as many tablix objects as you want in the body of a single SSRS report. The net result is that (aside from easy code re-usability), with SSRS there is no need to keep using the same nested sub-report paradigm that CR forced you into.
HTH,
Jason
May 1, 2017 at 2:32 pm
Jason A. Long - Friday, April 21, 2017 12:49 PMJust place the object(s) that you want to be in "the header" at the top of the body section in SSRS... Yup it's just that easy!
Hi Jason,
Thank you for your reply! What I really need is parameter-driven data in the header, sometimes in the form of table/tablix/subreport with groupings, repeating on the top of each page.
I've tried report parts, column/row headers, building a complex one tabled report with subreport rows using the first few rows as a makeshift header... I can't seem to get the configuration that we need. Do you have any suggestions on how to accomplish this?
Thanks,
Jessica
Thanks,
Jessica
What would you attempt to do if you knew you could not fail? -Robert H. Schuller
May 1, 2017 at 4:55 pm
Working with the page headers & footers is, as you've noticed is significantly trickier... and... what you're attempting is a bit unorthodox.
Assuming that you're dealing with a relatively small amount of display data (most people don't want a page header eating up the top 5" of every page) you should be able to use hidden cascading parameters.
Use the visible parameters to call a stored proc that returns a single with all of the values (columns) you want to display in the header.
Then create a set of hidden parameters, each tied to their column in the dataset... From there you should have little trouble using those parameters in either the page header or page footer.
Just a thought... I'm not in a position to test at the moment.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply