[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

The report parameter ‘StartDate’ has a DefaultValue or a ValidValue that depends on the report parameter “StartDate”. Forward dependencies are not valid.

Posted on 2011-04-27
12
Medium Priority
?
1,372 Views
Last Modified: 2012-08-13
Hello:

I'm getting the message mentioned in the title of this case in SQL 2008 Reporting Services.  I can't believe how much harder Microsoft has made this as compared to SQL 2005 Reporting Servivces.

OK.  What do you need to know so we can start troueblshooting this?

Apitech
0
Comment
Question by:apitech
  • 6
  • 6
12 Comments
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35478065
You could rename your .rdl file to .xml and then upload it here. Maybe along with the create statements for any SQL objects the report uses.
0
 
LVL 1

Author Comment

by:apitech
ID: 35478074
Hi There:

I would be glad to do that.  But, if I rename the .rdl file to .xml, isn't that going to destroy it?  

How can I safely get you the information that you need?

John
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35478129
Sorry, I should have explained this a bit better. Make a copy first, then rename that copy to .xml. Upload the xml and then delete the xml (which is a copy anyway). After I download it I'll rename it to .rdl again.
The reason you need to do this is EE won't let you upload a .rdl file.

I't about time to go to bed on this part of the globe. I'll look into it while you are sleeping (probably) :-)
0
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

 
LVL 1

Author Comment

by:apitech
ID: 35478197
Attached are the files.  One is that xml and the other is a document with screenshots
There-are-two-datasets.docx
Summary-Sales-By-Product.xml
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35481177
Thanks for the screenshots but since I have the .rdl file also I can check all the properties myself.
Open the properties of the DocDate Dataset. Go to the Parameters section. Delete the Start Date and End Data parameters there. This should solve your problem.
I suppose those parameters ended up there while you were creating and changing the datasets.

I suppose this could have happened in 2005 also :-)
0
 
LVL 1

Author Comment

by:apitech
ID: 35482665
Well, but I need those parameters!  The end user needs fields in order to tell the report what dates to put in.  I can't delete them, for goodness sakes!!!
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35482706
I'm not asking you to delete the parameters altogether. Just the linking of those parameters to the DocDate Dataset.  That's what is wrong with you report definition. The DocData dataset depends on the startdate parameter and the startdate parameter depends on the DocData dataset. This causes a circular reference and that causes the error.
0
 
LVL 1

Author Comment

by:apitech
ID: 35487563
Ah!  OK.  I apologize, for misunderstanding.

How do I remove the linking of the parameters to the DocDate dataset?

John
0
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 35489311
0
 
LVL 1

Author Comment

by:apitech
ID: 35490419
Thanks, Nicobo!  That solved the problem!  I appreciate your supplying a video for me, too!  That was awesome!

I have one question, just for my future reference.  Is there a way to have the parameters allow for the end user to choose a date by clicking on a "calendar icon"?  Somehow, I must have managed to create my parameters without that icon.  

If it's not possible, that's OK.  I can just have the end users click the drop-down and check the "start date" and "end date" from the list of dates in those two parameter fields.

Apitech
0
 
LVL 22

Expert Comment

by:Nico Bontenbal
ID: 35490495
0
 
LVL 1

Author Comment

by:apitech
ID: 35494990
Thanks, Nicobo!  You're awesome!!!!!!

Apitech
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

834 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