all groups > sql server reporting services > november 2005 >
You're in the

sql server reporting services

group:

Cascading Parameters error


Cascading Parameters error midlander
11/15/2005 9:11:11 AM
sql server reporting services:
I am new to SQL Reporting services - (3 weeks in fact)

I have a report that uses cascading parameters down 2 levels

I select from a dropdown which populates the second dropdown.

I then select from the second drop down list.

There are three more parameters to be entered in by the user - (these
are not drop down lists)
type of test
start date
end date

This runs fine in the test environment

I deploy
then select from my first dropdown.

It crashes out because start date and end date are not entered
It appears that the page is refreshing with all the parameters even
though they are not entered.

Any help is greatly appreciated.

Thanks
Re: Cascading Parameters error Ches Weldishofer
11/15/2005 10:06:03 AM
Try changing the order of your parameters. Put the start and end date
at the beginning.

Or put in defaults. Start and end date of yesterday and today for
example.
Re: Cascading Parameters error John Grant
11/16/2005 4:49:05 AM
How are you implementing cascading parameters. I have been needing to do
something like this, but do not see how it would be done.

Thanks

John

[quoted text, click to view]
Re: Cascading Parameters error midlander
11/17/2005 3:45:16 AM
I am not experienced enough to explain it to you correctly - RS books
online explains it quite well
Re: Cascading Parameters error midlander
11/17/2005 3:48:13 AM
Changing the order etc as you say works fine
Thank you very much
Can you recommend a good book for a beginner?
AddThis Social Bookmark Button