Link to home
Start Free TrialLog in
Avatar of apitech
apitech

asked on

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

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
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

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.
Avatar of apitech
apitech

ASKER

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
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) :-)
Avatar of apitech

ASKER

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
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 :-)
Avatar of apitech

ASKER

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!!!
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.
Avatar of apitech

ASKER

Ah!  OK.  I apologize, for misunderstanding.

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

John
ASKER CERTIFIED SOLUTION
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of apitech

ASKER

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
Avatar of apitech

ASKER

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

Apitech