Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations
Course Of The Month
2 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
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.
Active 4 days ago
Yes i am. I tested it locally and those parameters are being used by other reports too. It works fine
If thats the shared dataset then try embed the dataset within your report instead and pls let me know
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.
Also note that if you pass parameter value as empty string like parameter = "" it will give you that error
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.
Active 4 days ago
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 4 days ago
And i dont have nay blank or empty paramter value, i have all the named paremeter value only
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 ?
Active today
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.)
Active 4 days ago
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:-)
Great Raj ! Could you please mark one of the answer as accepted solution and close the question.
Thank you !
Thank you !
Featured Post
Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| SSRS Graph - Stacked Bar | 2 | 69 | |
| Need return values from a stored procedure | 8 | 64 | |
| Reformat SQL - so SSRS can read the columns | 25 | 47 | |
| Visual Studio 2015 Report Viewer has blank data source? | 1 | 19 |
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…
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column.
…
Simple Linear Regression
Suggested Courses
Course of the Month2 days, 20 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.