Forum Replies Created

Viewing 15 posts - 31 through 45 (of 93 total)

  • RE: Hide the sub reports in ssrs

    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...

  • RE: Report Object Model

    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...

  • RE: Adding Size in Reporting Services Parameter

    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...

  • RE: How To COPY SSRS Folder ??

    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...

  • RE: Report rendering time too long

    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...

  • RE: Report rendering time too long

    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...

  • RE: SSRS Deployment

    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...

  • RE: Matrix expansion/collaps results in scrolling

    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...

  • RE: Iif statement help

    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...

  • RE: Reporting Services Configuration settings

    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...

  • RE: Using Identity fields For the First time

    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...

  • RE: Developer Permissions on Production Database - Specific Custom DB Role Possible?

    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...

  • RE: Sum returns error with IIF of field values.

    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...

  • RE: Reporting Services Login dialog box

    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...

  • RE: Dynamically setting ReportName property of sub report

    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...

Viewing 15 posts - 31 through 45 (of 93 total)