Viewing 15 posts - 31 through 45 (of 94 total)
If you have update access to the database behind Reporting Services and know the names of all the objects you want to make hidden (subrereports in this case), open the...
maddog
July 15, 2008 at 10:26 am
I recall reading in a few places quite a while ago that the SSRS Code platform uses the same VB.Net object model in the framework, depending on the version of...
maddog
June 6, 2008 at 10:27 am
I don't know of a way to specify a longer length of parameter strings in the SSRS configuration, but one thing besides size that may cause parameter strings to be...
maddog
March 25, 2008 at 7:21 am
Check out a free tool - Reporting Services Scripter- at http://www.sqldbatips.com.
Yous can set it up to create RS scripts to move\copy SSRS reports, folders, permissions, whatever between severs or on...
maddog
January 17, 2008 at 10:12 am
Another idea, if you have all the DataSets defined in the same single report and are tying them to different tables or data regions in the dashboard, you might try...
maddog
December 20, 2007 at 11:40 am
SQLServer can certainly produce multiple result sets out of SP's, and most SQL client drivers can handle some form of identifying these independently, but neither SSRS2K and SSRS2K5 can currrently...
maddog
December 20, 2007 at 11:23 am
I'm sure you have your reasons why you want to put the data sources into a different target folder on the SSRS server than the reports, but as an alternative...
maddog
December 18, 2007 at 4:17 pm
If you have the SSRS ReportViewer control embedded in an ASP.Net web page, try putting in the smartNavigation="False" directive in the Page declaration at the top of the .aspx page...
maddog
December 13, 2007 at 10:09 am
With the suggested '*3*' pattern match be careful your possible list of values does not extend into the teens and beyond, a value of 13 (23, A3BC, etc .) in...
maddog
November 30, 2007 at 10:23 am
This is a slightly different angle, but is it possible the report you are looking at is cached (hit the report refresh button on the viewer to resolve) and are...
maddog
November 27, 2007 at 4:00 pm
The fact that the column in question happens to be an identity datatype is the easy part to get around and does not really have a bearing on the referential...
maddog
November 20, 2007 at 11:44 am
Thanks for the response Brian.
I believe I've seen samples (possibly yours) and can work out the scripted permissions for the EXECUTE part, but will your suggestion of using...
maddog
November 15, 2007 at 8:26 am
Or just use a case statement in the SP against the InSpec column value to make the BBLs column value what it is or zero using same logic as the...
maddog
November 8, 2007 at 10:27 am
This is kind of a 'is it plugged in' suggestion, but when you are providing the account credentials when prompted are you making sure to specify the domain first and...
maddog
November 7, 2007 at 10:54 am
Sarah, it sounds like you already knew that you can use an expression in the reportname parameter of the subreport, but instead of returning the empty value you can just...
maddog
October 5, 2007 at 11:41 am
Viewing 15 posts - 31 through 45 (of 94 total)