x

Getting Error on Page in Report Manager - SSRS

Just two days back we have migrated the reporting server for that we have taken the backup of the previous reporting server db and restored in the new server. Everything was fine, except few issues..

1. In one report, there is a parameter which is populating hundreds of values and it is multi value parameter. By selecting "Select ALL" and if we run the report it is showing Error on Page and getting blank white page. Not able to idenifying the problem...do we need to change any configuration settings for this......
more ▼

asked Mar 20, 2012 at 10:48 AM in Default

Mohan gravatar image

Mohan
324 39 56 60

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Did(Does) this report work on the previous server?

I'd first suspect that the number of parameters means the string passed to the database is too long.
more ▼

answered Mar 20, 2012 at 12:07 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

yes, expecting because the parameter values are more...
Mar 20, 2012 at 12:36 PM Mohan
(comments are locked)
10|1200 characters needed characters left

You should check the Reporting Services Log file for details. There will be detailed information about the error listed inside.

By default the log Files are located under the SSRS Instance Installation directory in Reporting Services\LogFiles sub directory.
more ▼

answered Mar 20, 2012 at 12:37 PM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x84

asked: Mar 20, 2012 at 10:48 AM

Seen: 1839 times

Last Updated: Mar 20, 2012 at 12:38 PM