Showing posts with label filtering. Show all posts
Showing posts with label filtering. Show all posts

Wednesday, March 28, 2012

Report parameter and filtering

My report has a parameter that is used for a filter in one of my data set.
What I â'd like to do is to say if that parameter is not blank then use it
To filter data otherwise show everything. Is that possible?If you want to perform filtering in a query:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=uOX2NreOEHA.2780%40TK2MSFTNGP09.phx.gbl
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark" <Mark@.discussions.microsoft.com> wrote in message
news:D1B71526-C984-4DE2-883F-040105BAB845@.microsoft.com...
> My report has a parameter that is used for a filter in one of my data set.
> What I 'd like to do is to say if that parameter is not blank then use it
> To filter data otherwise show everything. Is that possible?
>

Wednesday, March 21, 2012

Report Model Filtering

When creating a filter with Report Model against my cube (or perhaps any
source) - it seems to force me to free form type how the filter will work.
For example -
Attribute: Does_Client_Smoke
Values: Yes, No, N/A, Won't Answer, Cannot Answer
When I create the filter it makes me type in one of the above values instead
of letting me select it from a pull-down such as how BIDS works - what am I
doing wrong here?Can someone help me on this question below. When using the report viewer,
there is a BACK button but when using browser, it won't page back correctly.
I'm using latest IE beta - maybe that's my issue?
"Joe" <hortoristic@.gmail dot com> wrote in message
news:%23ZxRAzSzGHA.772@.TK2MSFTNGP05.phx.gbl...
> When creating a filter with Report Model against my cube (or perhaps any
> source) - it seems to force me to free form type how the filter will work.
> For example -
> Attribute: Does_Client_Smoke
> Values: Yes, No, N/A, Won't Answer, Cannot Answer
> When I create the filter it makes me type in one of the above values
> instead of letting me select it from a pull-down such as how BIDS works -
> what am I doing wrong here?
>