We help IT Professionals succeed at work.

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

apitech
apitech asked
on
Medium Priority
1,584 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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
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.

Author

Commented:
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
CERTIFIED EXPERT

Commented:
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) :-)

Author

Commented:
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
CERTIFIED EXPERT

Commented:
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 :-)

Author

Commented:
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!!!
CERTIFIED EXPERT

Commented:
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.

Author

Commented:
Ah!  OK.  I apologize, for misunderstanding.

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

John
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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
CERTIFIED EXPERT

Commented:

Author

Commented:
Thanks, Nicobo!  You're awesome!!!!!!

Apitech
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.