[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 640
  • Last Modified:

SSRS Report Crashes

Hi,

I have created an SSRS report that requires a lot of parameters (basically it is a report that allows its users to search by everything... nearly)

The report has about 50 parameters.

When I open the report in IE it looks like:
Report
I enter the mandatory parameters and then click on "View". Once the report has rendered I then click on the >> pointing up to hide the parameters so that the report is visible. If I then click the >> to show the parameters again and then Internet Explorer hangs and becomes unresponsive.

Please could someone help with this as I really need to deploy the report.

I have checked the Show\Hide parameter feature using other reports (with far less parameters) and it works OK.

Thanks, Greg
0
spen_lang
Asked:
spen_lang
  • 5
  • 2
1 Solution
 
Nico BontenbalCommented:
I'm afraid you'll have to experiment a bit with reducing the number of parameters and see if the report start working with a certain number of parameters. Could also be that some of the drop down parameters have a lot of values and dropping one or two of those might also solve  your problem.

Then the next challenge is to find a way to get the report working with less parameters. Maybe you can all the 'like' and 'not like' parameters into a few parameters. In the first parameter you select the field (Account, Col Add1, Col From etc.) In the second parameter you select the type of search (Like/Not like) and the third parameter is the value. Might even be possible to do the same for the in parameters. Maybe you can reduce the number of parameters this way.

Another option might be to split the parameters over two reports. The first report could have only the parameters that are enabled in your screenshot. When the user runs this report only a line is shown in the report that says how many records are found. The user can click this line to go to a second report that has the other parameters. But you pass the 'original' parameters as hidden parameters to this second report.

Also you could check if the report works in other browsers. That way you can find out if it is a browser or a server problem.
0
 
planoczCommented:
It would be better to have a set of reports to fit the catagory that you want to stay in.
You will have fewer parameters and a lot happier users who will be using the reports.
0
 
spen_langAuthor Commented:
I have tried the report in Chrome and Firefox but these browsers do not give the ability to hide/unhide the parameter lists. The problem only exists when I run the report and then hide the parameters and then unhide the parameters again.

The point of this report is to allow the users to search by everything so that they can find what they need, so I am unable to reduce the amount of parameters by creating several reports.
0
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

 
spen_langAuthor Commented:
I have removed the "available" values for the multi-value parameters and this has not made a difference.
0
 
spen_langAuthor Commented:
The problem seems to occur if the list of parameters go out of view and a vertical scroll bar is required to view the parameters. If I reduce the amount of parameters down to 48 then all the parameters fit on my screen (1920x1080) without vertical scroll bars. The problem does not occur.

But, if I run the report on a different PC using a resolution of 1661x942 then the parameter list requires a vertical scroll bar to see all parameters. If I hide\unhide the list then IE crashes.
0
 
spen_langAuthor Commented:
OK, it does not seem to be a parameter issue.

The problem was within the tablix header, I had set the column headers to "keep header visible while scrolling" by setting the "FixedData" property of the Row Groups to "True". Although this method works for some reason when I hide/unhide the parameter list in IE (tried different versions) it caused IE to crash. I have now set the "FixedData" property to "false" and the report is now functioning correctly allowing me to hide and unhide the parameter list (although I have lost the functionality of scrolling headers).
0
 
Nico BontenbalCommented:
Good to hear you (kind of) solved your problem. Sorry I couldn't be of any assistance.
0
 
spen_langAuthor Commented:
Worked it out myself
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now