In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.
Solved
SSRS Report Runtime Error
Posted on 2016-09-08
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
10-
8
2
20 Comments
Active today
Seems like the user running the report does not have access.
Please provide access to the user running the report.
Please provide access to the user running the report.
Yes i am. I tested it locally and those parameters are being used by other reports too. It works fine
Active today
If thats the shared dataset then try embed the dataset within your report instead and pls let me know
Active today
See the SSRS logs under :
%Program Files%\Microsoft SQL Server\MSRS11.MSSQLSERVER\
Take the latest file (by date/time)
You should see the error and it tells you which parameter is missing value.
%Program Files%\Microsoft SQL Server\MSRS11.MSSQLSERVER\
Take the latest file (by date/time)
You should see the error and it tells you which parameter is missing value.
Active today
Also note that if you pass parameter value as empty string like parameter = "" it will give you that error
Active today
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.
open Parameter Properties (right click your parameter on Report Data panel);
mark the Allow blank value ("") checkbox.
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
Active today
ok.. Delete the dataset and Redeploy Dataset Again and then try.
Also can you try to deploy the same on local server and check ?
Also can you try to deploy the same on local server and check ?
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.)
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.)
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:-)
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:-)
Active today
Great Raj ! Could you please mark one of the answer as accepted solution and close the question.
Thank you !
Thank you !
Featured Post
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi All,
I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month11 days, 11 hours left to enroll
730 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.