Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem with default filter values on SSRS

3 views
Skip to first unread message

Alexandra Ribeiro

unread,
Jun 6, 2008, 4:58:00 AM6/6/08
to
Hello.

A weird problem: I have an SSRS report with 4 filters with user prompt: two
of them have "All" as default.

The first time the user enters the report and chooses the filter values all
runs well, but when the user changes data on the first two filter boxes, a
refresh is made and the "All" as default values on the two last filters is
not filled in and the user have to put them manually.

Is there any way to mantain the default value on the filters, even if the
user changes the other filter values?

I don't know if I explain this clearly...

Thanks in advance.

Cheers,
--
Alexandra

Antoon

unread,
Jun 6, 2008, 6:09:00 AM6/6/08
to
I have several reports that work like that without a problem
So I would check if the last parameters arent dependent on the first ones or
something like that

Alexandra Ribeiro

unread,
Jun 6, 2008, 6:15:01 AM6/6/08
to
Hello, Antoon.

Thanks for yout quick reply.

Yes, they are dependent on the first ones, but isn't there a way to force
the report to put those dependent filter values with "All" as default again,
when the refresh is made?

Thank you.
--
Alexandra

Antoon

unread,
Jun 6, 2008, 6:36:01 AM6/6/08
to
Well, if they are dependent than they are recalculated every time a parameter
they depend on is changed. If you don't want that to happen than make sure
they don't depend on eachother.
0 new messages