November 9, 2016 at 12:34 pm
In the existing ssrs 2008 report, currently reports have the header on the first page only. Now there is a requirement to have the page header
appear on all reports except one report where milestone_code =999. The report that has only has one page header can have lots of pages generated.
I am thinking of having using the existing tablix and allow only records where milestone_code =999.
I am also thinking of setting up a new tablix where the header would appear on all pages. Basically that would be where milestone_code <> 999.
What would you recommend and would you show me how to follow your recommendation?
November 9, 2016 at 5:02 pm
Your solution is the way I'd do it, Wendy. I'm not aware of an expression for repeating headers (just a true/false), but I'd be interested if someone knows otherwise.
November 10, 2016 at 8:35 am
Since I plan on having 2 different tablixes, the 'headers' would be contained within each tablix. Wouldn't each tablix be able to control if a 'header' is on each page or not? If so, how would I make each tablix show up?
November 10, 2016 at 10:32 am
Yes, you should be able to control headers for each tablix. Then in the Visibility properties for each tablix you could have an expression like "=milestone_code =999" or "=milestone_code <>999," and then if they chose 999 they'd just see the one tablix, and if they choose another value the "999 tablix" would be hidden.
November 14, 2016 at 11:05 am
For this to work correctly, should I do the following:
1. For the report where the page logo is only on the first page, set the report header to only allow milestone code =999? In other words, the tablix will not be used for a header.
2. For the report where the page header appears on every page, this would be in the tablix where the milestone code <> 999, correct?
Would you let me know what the best solution is and why you chose that option?
November 15, 2016 at 5:26 pm
To spell it fully out, here is what I would do (based largely what you have suggested):
1. Have two tablixes, which we'll call 999 and Not999
2. Set the header to repeat on Not999
3. In tablix properties -> Filters, for 999 set =milestone_code =999, and for Not999 set it =milestone_code <>999.
4. In tablix properties -> Visibility, click the "Show or hide based on an expression" button and in the expression for hidden for 999 put =milestone_code <>999, and for Not999 put =milestone_code =999 (this is pseudo-code).
If the users pick 999, the Not999 tablix will be hidden, and they'll get the tablix with headers only on the first page. If they pick a value other than 999, the 999 tablix will be hidden, and they'll get the tablix with repeating headers. I noted the above examples as pseudo-code because the actual entries might need to be something more like =Parameters!milestone_code.Value = 999. Does that clarify the scenario?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply