Solved

SSRS Report Runtime Error

Posted on 2016-09-08
20
38 Views
Last Modified: 2016-09-10
Hello Everyone,

I have a strange issue, i have developed a report which  has multiple parameters in it. When i am running it in visual studio its working fine but when i deployed it on web server and running it, its giving me a error regarding the parameter which i have pasted below. I checked all my parameters and they are correctly setup in the visual studio and sql server as well..

I have 3 parameters

1) Period -->  Available values are set and there is no default values for this as it is a drop down selection (Screen shot attached) I read in a blog that if we are not giving the default parameter values as well it would give us a error. Is that true??

2) Start date--> Available values and default values are set

3) End date--> Available values and default values are set

And also i have attached the run time error also in my attachments.

Any suggestion or solution is appreciated and thanks in advance!!
Runtime-Error.png
Period_screenshot.png
0
Comment
Question by:Vira
  • 10
  • 8
  • 2
20 Comments
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Seems like the user running the report does not have access.

Please provide access to the user running the report.
0
 

Author Comment

by:Vira
Comment Utility
Hi Pawan,

User has full access to run the report..
0
 
LVL 16

Accepted Solution

by:
Pawan Kumar Khowal earned 500 total points
Comment Utility
Are we passing proper parameters with Values to the dataSet.
0
 

Author Comment

by:Vira
Comment Utility
Yes i am. I tested it locally and those parameters are being used by other reports too. It works fine
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
If thats the shared dataset then try embed the dataset within your report instead and pls let me know
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
See the SSRS logs under :

%Program Files%\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles
Take the latest file (by date/time)

You should see the error and it tells you which parameter is missing value.
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Also note that if you pass parameter value as empty string like parameter = "" it will give you that error
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Also If you really need to pass a blank string as value, you can do the following:

open Parameter Properties (right click your parameter on Report Data panel);
mark the Allow blank value ("") checkbox.
0
 

Author Comment

by:Vira
Comment Utility
Unfortunately i don't have access to check the logs on prod server.  And for the parameters i already have the embedded data sets form where i am mapping my parameter values
0
 

Author Comment

by:Vira
Comment Utility
And i dont have nay blank or empty paramter value, i have all the named paremeter value only
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
ok.. Delete the dataset and Redeploy Dataset Again and then try.

Also can you try to deploy the same on local server and check ?
0
 

Author Comment

by:Vira
Comment Utility
Pawan, no luck i tried it.. Still the same error
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Bad luck , can you upload your rdl ?
0
 
LVL 13

Expert Comment

by:Megan Brooks
Comment Utility
These are all good suggestions. Can you find someone that does have access to the report server file system to send you a copy of the most recent logfile, allowing a little time between when you run the report and when the copy is made? You don't even need the whole thing; just the tail. It's just an ordinary text file.

The logfile path shown above is for a default installation. If the install location wasn't defaulted to Program Files then the leading portion must be adjusted accordingly.

There's something vaguely familiar about these symptoms. I'll sleep on it and see if anything comes back to me.

Just for the record, what's the SSRS version, service pack, and cumulative update level? (I've known IT to update the database engine instances and leave the report servers on old versions.)
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
@Author - Any Update ?
0
 

Author Comment

by:Vira
Comment Utility
Hello Pawan and Megan,

I was able to resolve the error.. It was a error in parameter values. During the QA we hard coded the date values instead of giving it the dynamic values. So in the run time it couldn't understand the static values and it was throwing out an error. When i changed the values to dynamic it is working fine without any issue.

I appreciate your help and time in this matter.

THANK YOU:-)
0
 
LVL 16

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
Great Raj ! Could you please mark one of the answer as accepted solution and close the question.

Thank you !
0
 

Author Closing Comment

by:Vira
Comment Utility
As it was a error related to parameter values this solution helped in fixing it..
0
 
LVL 13

Expert Comment

by:Megan Brooks
Comment Utility
Ah yes, that does indeed sound vaguely familiar. :-)

Rule of thumb: Report Server exception messages don't necessarily mean exactly what they say. Sometimes they mean something completely different. (And occasionally what they really mean is that there is a bug in Report Server!)
0
 

Author Comment

by:Vira
Comment Utility
Ya i definitely agree with you. Sometimes the error message tells you something and the actual error is something else.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now