Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center > SQL Server Forums > SQL Server Reporting Services > SSRS Action Report through Proclarity Report

Answered SSRS Action Report through Proclarity Report

    •  
      Thursday, May 08, 2008 6:20 AM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hello Friends,

                          I am using an action report(SSRS Report) in a Proclarity report in which the user generate action report on some particular filters. The problem is : In this report (SSRS report) I am using two row groups and three data fields and intially i am displaying the report in collapsed manner. The report is working fine in BIDS and as well as on the report server. But when i am generating the report through prolarity , the report is getting generate but when i tried to expand the collapsed field its throwing an error

       "An internal error occured on the report server. See the error log for more details. Specified argument was out of the range of valid values"

       

      Can anyone help me out to solve this issue.

       

      Thanks & Regard's

       

       

    Answers

    • Wednesday, June 04, 2008 5:37 AM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote

       

      To overcome this problem we can pass URL command with the URL of that deployed SSRS report. In the above mention scenario we have used “&rcStick out tonguearameters=true “URL command. After appending the URL with this command the report started working.

       

      Eg :

       

       ReportServer/Pages/ReportViewer.aspx?%2fAction+Reports%2fATL&rs:Command=Render&rcStick out tonguearameters=true

       

      common ssrs URL commands:

      "&rcStick out tonguearameters=collapsed "
      •  This collapses the parameter bar but sends the parameters in the URL in the browser

      "&rcStick out tonguearameters=true "
      •  This shows the parameter bar and is the default

      "&rcStick out tonguearameters=false "
      •  This prevents the parameters from being passed in the browser and expanded

      "&rc:toolbar=false "
      •  This hides the toolbar

      "&rc:format=pdf "
      •  This will open up the report as a PDF

      "&rs:format=excel&rcSurprisemitformulas=true "
      •  This will open the report in Excel

      "rs:clearSession=true "
      •  This clears the session state for the user. Used where the caching of the report prevents the designer from seeing their updated report and/or data. * This is a very important parameter to know as more often than not, the report data doesn't update immediately unless parameters are changed, and your report may show cached data if this is not set.

      "&rcTongue Tiedtylesheet=mycustomstyle "
      •  Note don’t add the .css extension. And this style sheet must be in the folder Program FilesMicrosoft SQL ServerMSSQLReporting ServicesReportServerStyles folder.
      •  Use the HTMLViewer.css as your base template