ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
Become 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
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 ?
Active 3 days ago
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
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
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…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots.
The installation is straightforward, you just pop the SQL server 2008 installati…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 9 hours left to enroll
632 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.