August 31, 2009 at 11:35 am
maxedout420 (8/21/2009)
@startdate and @enddate are setup as date/time with defualt values of defaultstartdate and defaultenddate respectively....
use Non-Queried default values with following values for Start and End dates respectively.
=DateAdd("d", -90, Today)
=DateAdd("d", -60, Today)
August 31, 2009 at 11:47 am
Sorry... Forgot to update the forum..
Thats exactly what I did and it worked!!
Max
September 16, 2010 at 1:38 am
I was stuck with the very same issue and I thought I had to throw it all away when I read this topic, and it worked for me as well!!! THANK YOU!
March 18, 2011 at 7:02 am
I am having the same problem I think but I only have one parameters.
The dataset is populated with the following sql:
SELECT *
FROM Course_Lesson
WHERE Course_System_ID= @Course_System_ID
The @Course_System_ID parameters is pointing to =Parameters!course_system_ID.Value
Parameters!course_system_ID.Value is a reportParameter with its available values property set to a dataset being populated by this sql:
SELECT * FROM COURSE
When I run the query my values don't show up. When I try to deploy the query I get an error:
c:\documents and settings\petteysk\my documents\visual studio projects\report project6\report project6\On-Demand Attendance Report (by User) TestReport.rdl The report parameter ‘LessonTitle’ has a DefaultValue or a ValidValue that depends on the report parameter “course_system_ID”. Forward dependencies are not valid.
Any Ideas?
June 17, 2011 at 6:44 am
I am so glad I found your post. That solved my problem. Thank you so much!
August 24, 2011 at 5:07 am
Thank you. That solved my problem. So easy.
February 2, 2012 at 3:04 am
i just had this in SSRS 2008
and the parameter order change fixed it
but the parameters are different in 2008, on the report data...so i had to manually delete one and reinstate it at the end...
which seems daft, but it worked
(edit)
http://msdn.microsoft.com/en-us/library/cc281392(v=sql.100).aspx
no, was being thick, you can manually drag them, holding control and up/down works
February 20, 2012 at 11:26 pm
what if i have only one parameter.
February 21, 2012 at 6:43 am
Whats are the details for that parameter? Default value, available values, etc...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgFebruary 21, 2012 at 8:53 pm
look I want to generate report based on the selection of the drop down list(having district names)
in the data set I have written the query
Select districtname,districtcode from district WHERE districtname=@districtname
in the parameters properties I have selected the query option for the Available values and none for the default values and also checked the multiple choice option but I am not able to get selections from the dropdown list.
vandana
February 21, 2012 at 9:09 pm
You've created a circular reference. Your parameter is based on a query that needs the parameter value to run. Using just
Select districtname,districtcode from district
should do the trick.
February 22, 2012 at 12:48 am
That's fine I have a dropdownlist and I can select multiple values but full report is being generated not specific to those values.
February 22, 2012 at 1:43 am
Now you need to add the where clause to the query (or queries) that serve your report, not the query that populates the drop down.
February 22, 2012 at 1:59 am
can you please explain in details
as I have used a shared datasource which I have brought from my project.
vandana
March 19, 2012 at 1:17 pm
Changing the order of the parameters resolves the issue.
Viewing 15 posts - 16 through 30 (of 37 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy