Solved

SSRS Report Crashes

Posted on 2014-01-24
8
573 Views
Last Modified: 2014-02-01
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
Comment
Question by:spen_lang
  • 5
  • 2
8 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 39808499
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
 
LVL 27

Expert Comment

by:planocz
ID: 39809370
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
 

Author Comment

by:spen_lang
ID: 39811323
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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:spen_lang
ID: 39811324
I have removed the "available" values for the multi-value parameters and this has not made a difference.
0
 

Author Comment

by:spen_lang
ID: 39811419
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
 

Accepted Solution

by:
spen_lang earned 0 total points
ID: 39811845
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
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 39811911
Good to hear you (kind of) solved your problem. Sorry I couldn't be of any assistance.
0
 

Author Closing Comment

by:spen_lang
ID: 39826050
Worked it out myself
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read this checklist to learn more about the 15 things you should never include in an email signature.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question