Viewing 15 posts - 31 through 45 (of 93 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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
October 5, 2007 at 11:41 am
Viewing 15 posts - 31 through 45 (of 93 total)