Report freezes while having 7 parameters

Question

User1630393281 posted

Hello,

I have a report with 6 parameters that works very well. When I add another parameters it freezes  in the SSRS  portal and doesn't display anything when I want to run the report .

I'm using IE 11.

How can I resolve this issue ?

This last parameter is mandatory.

I don't have a distant folder where I can put a screenshop for you to see this behaviour. I see that I cannot put it here directly

Can you give me an email address where I can send you the screenshot ?

Thanks in advance.

Best regards.

Answer 1

User753101303 posted

Hi,

See https://www.mssqltips.com/sqlservertip/3348/sql-server-reporting-services-ssrs-log-files-for-troubleshooting/

Could it be that you have an error and then nothing more happens in the browser.

Answer 2

User1630393281 posted

I don't have an error because the report is working in the visual studio but not in the SSRS PORTAL

Answer 3

User753101303 posted

You have tons of reason for which it could work on the VS side and fail on the SSRS portal. Could you still take 3 minutes to check SSRS log files to make 100% sure there is not just an error message telling you what happens?

In my experience unless you see something really obvious right away it is always quicker to take few extra minutes to find an error message (and I don't remember a case where I really coudn't find one) rather than spending time in guessing and trying things unitl the unknown problem is fixed by chance.

Edit: https://docs.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver15 summarize a number of log files some of which being usefull as well for other cases...

Edit 2 : the next option could be long running query because maybe of a badly written SQL statements (it can get unoticed in VS if you work with much less data).

Answer 4

User1630393281 posted

I agree but the log files are not in my computer because the SQL server used by the SSRS PORTAL is installed in a distant machine. 

If I don't have any issue in MY visual studio then I will not find any error in my  machine log files but I cannot access the files of the distant machine.

Answer 5

User475983607 posted

szejli

I agree but the log files are not in my computer because the SQL server used by the SSRS PORTAL is installed in a distant machine. 

If I don't have any issue in MY visual studio then I will not find any error in my  machine log files but I cannot access the files of the distant machine.

Someone must have access to the remote machine.  Reach out and ask for assistance.

Also, is your dev machine accessing the same DB and the remote machine?  Perhaps the remote machine has a different schema than then your dev machine.  Or maybe the data is different?  Can you explain your troubleshooting steps up to this point?