Tuesday, March 27, 2012

Filter based on a parameter

Hi all,
How would you go about creatig a filter that is used based on the value of a
parameter? Can this be done?
Lets say we have a report parameter called 'Show cases missing <attribute>
data?'
If the user sets this to true, then the filter would kick in, which is a
filter that would check for this.field Is Nothing AND that.Field Is Nothing
OR thisother.field Is Nothing Or thatother.field Is Nothing --and show only
the rows that meet the criteria above.
I can create the filter, but I am not sure how to get it to toggle based on
the selection of the parameter by the user...is this possible?
Thanks,Do you want to filter out the data, or to hide it?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Myles" <Myles@.discussions.microsoft.com> wrote in message
news:44D54311-BA0E-40E2-A927-C875577E3CAF@.microsoft.com...
> Hi all,
> How would you go about creatig a filter that is used based on the value of
> a
> parameter? Can this be done?
> Lets say we have a report parameter called 'Show cases missing <attribute>
> data?'
> If the user sets this to true, then the filter would kick in, which is a
> filter that would check for this.field Is Nothing AND that.Field Is
> Nothing
> OR thisother.field Is Nothing Or thatother.field Is Nothing --and show
> only
> the rows that meet the criteria above.
> I can create the filter, but I am not sure how to get it to toggle based
> on
> the selection of the parameter by the user...is this possible?
> Thanks,|||Filter it out.
And yes, it should probably be done in the SP. But, can you use filters
like that? We would like to mimc all the existing crytal reports which
entails changing as little as possible (in the SP) for now. I am not worried
about the overhead data associated with this.
"Lev Semenets [MSFT]" wrote:
> Do you want to filter out the data, or to hide it?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Myles" <Myles@.discussions.microsoft.com> wrote in message
> news:44D54311-BA0E-40E2-A927-C875577E3CAF@.microsoft.com...
> > Hi all,
> >
> > How would you go about creatig a filter that is used based on the value of
> > a
> > parameter? Can this be done?
> >
> > Lets say we have a report parameter called 'Show cases missing <attribute>
> > data?'
> >
> > If the user sets this to true, then the filter would kick in, which is a
> > filter that would check for this.field Is Nothing AND that.Field Is
> > Nothing
> > OR thisother.field Is Nothing Or thatother.field Is Nothing --and show
> > only
> > the rows that meet the criteria above.
> >
> > I can create the filter, but I am not sure how to get it to toggle based
> > on
> > the selection of the parameter by the user...is this possible?
> >
> > Thanks,
>
>|||Assuming there is an Attribute parameter which represents the actual field
name you want to filter on, the filter would look similar to this:
Filter expression: =Fields(Parameters!Attribute.Value).Value is Nothing
Filter operator: =Filter value: =True
Note: I'm using the collection syntax to dynamically determine the field
name and access the fields collection based on the selected parameter value.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Myles" <Myles@.discussions.microsoft.com> wrote in message
news:24251135-8BE2-4607-B923-6F0C5749AB4A@.microsoft.com...
> Filter it out.
> And yes, it should probably be done in the SP. But, can you use filters
> like that? We would like to mimc all the existing crytal reports which
> entails changing as little as possible (in the SP) for now. I am not
> worried
> about the overhead data associated with this.
> "Lev Semenets [MSFT]" wrote:
>> Do you want to filter out the data, or to hide it?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Myles" <Myles@.discussions.microsoft.com> wrote in message
>> news:44D54311-BA0E-40E2-A927-C875577E3CAF@.microsoft.com...
>> > Hi all,
>> >
>> > How would you go about creatig a filter that is used based on the value
>> > of
>> > a
>> > parameter? Can this be done?
>> >
>> > Lets say we have a report parameter called 'Show cases missing
>> > <attribute>
>> > data?'
>> >
>> > If the user sets this to true, then the filter would kick in, which is
>> > a
>> > filter that would check for this.field Is Nothing AND that.Field Is
>> > Nothing
>> > OR thisother.field Is Nothing Or thatother.field Is Nothing --and show
>> > only
>> > the rows that meet the criteria above.
>> >
>> > I can create the filter, but I am not sure how to get it to toggle
>> > based
>> > on
>> > the selection of the parameter by the user...is this possible?
>> >
>> > Thanks,
>>|||Thanks Robert -
no, the parameter is just a simple yes/no question and is does not directly
correlate to any single attribute or field in the report - it does indirectly
take in to consideration the Null values of three fields in the report.
"Robert Bruckner [MSFT]" wrote:
> Assuming there is an Attribute parameter which represents the actual field
> name you want to filter on, the filter would look similar to this:
> Filter expression: =Fields(Parameters!Attribute.Value).Value is Nothing
> Filter operator: => Filter value: =True
> Note: I'm using the collection syntax to dynamically determine the field
> name and access the fields collection based on the selected parameter value.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Myles" <Myles@.discussions.microsoft.com> wrote in message
> news:24251135-8BE2-4607-B923-6F0C5749AB4A@.microsoft.com...
> > Filter it out.
> >
> > And yes, it should probably be done in the SP. But, can you use filters
> > like that? We would like to mimc all the existing crytal reports which
> > entails changing as little as possible (in the SP) for now. I am not
> > worried
> > about the overhead data associated with this.
> >
> > "Lev Semenets [MSFT]" wrote:
> >
> >> Do you want to filter out the data, or to hide it?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Myles" <Myles@.discussions.microsoft.com> wrote in message
> >> news:44D54311-BA0E-40E2-A927-C875577E3CAF@.microsoft.com...
> >> > Hi all,
> >> >
> >> > How would you go about creatig a filter that is used based on the value
> >> > of
> >> > a
> >> > parameter? Can this be done?
> >> >
> >> > Lets say we have a report parameter called 'Show cases missing
> >> > <attribute>
> >> > data?'
> >> >
> >> > If the user sets this to true, then the filter would kick in, which is
> >> > a
> >> > filter that would check for this.field Is Nothing AND that.Field Is
> >> > Nothing
> >> > OR thisother.field Is Nothing Or thatother.field Is Nothing --and show
> >> > only
> >> > the rows that meet the criteria above.
> >> >
> >> > I can create the filter, but I am not sure how to get it to toggle
> >> > based
> >> > on
> >> > the selection of the parameter by the user...is this possible?
> >> >
> >> > Thanks,
> >>
> >>
> >>
>
>

No comments:

Post a Comment