Random SSRS nuggets from all over
[This will be a list of resources I point people to all the time....just putting 'em all in one place]
Tudor says "don't rely on obsfucation" when trying to hide sensitive parameter values:
https://blogs.msdn.com/tudortr/archive/2004/07/20/189398.aspx
Bryan demonstrates how to URL Post an SSRS request
Chris walks you through dynamic grouping in a data region:
https://blogs.msdn.com/chrishays/archive/2004/07/15/184646.aspx
Setting up 2000 to use non default web sites
https://www.awprofessional.com/articles/article.asp?p=357694&seqNum=3&rl=1
Page Breaks
In some reports, you may want to place a page break at the end of a specified number of rows instead of, or in addition to, on groups or report items. To do this, create a group in a data region (typically a group immediately outside the detail), add a page break to the group, and then add a group expression to group by a specified number of rows.
· The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this results in a page break every 25 rows.
=Int((RowNumber(Nothing)-1)/25)
Comments
- Anonymous
February 18, 2009
Heya, what is the deal with being able to pass 2 arguments to the ReportServer web report? I can pass it the first parameter, but it continues to ask for the 2nd required parameter even when I have it on the querystring!