How to set two filters to be 'Or' relation?

I have two or more filters for a metrix, but I found the 'And/Or' column is
disable in filter tab of Matrix properties Dialog.
In addition, the filters element in RDL is defined here:
<Filters>
<Filter Name"...">...</Filter>
</Filters>
If there are two filters, the default relation is 'And', but how to set the
'Or' relation? Does Report Service itself only support 'And' relation for
report filter?
Thanks in advance.All filter expressions within filter are related by "And"
"Or" is used by UI to represent operator "In".
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xie Zheng" <XieZheng@.discussions.microsoft.com> wrote in message
news:B76542ED-207A-4CCF-8D28-BB8665EF8F61@.microsoft.com...
>I have two or more filters for a metrix, but I found the 'And/Or' column is
> disable in filter tab of Matrix properties Dialog.
> In addition, the filters element in RDL is defined here:
> <Filters>
> <Filter Name"...">...</Filter>
> </Filters>
> If there are two filters, the default relation is 'And', but how to set
> the
> 'Or' relation? Does Report Service itself only support 'And' relation for
> report filter?
> Thanks in advance.|||Please check this related newsgroup thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=ba53b4b7-cffc-4851-af9f-5e6eb48b1b1c&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xie Zheng" <XieZheng@.discussions.microsoft.com> wrote in message
news:B76542ED-207A-4CCF-8D28-BB8665EF8F61@.microsoft.com...
> I have two or more filters for a metrix, but I found the 'And/Or' column
is
> disable in filter tab of Matrix properties Dialog.
> In addition, the filters element in RDL is defined here:
> <Filters>
> <Filter Name"...">...</Filter>
> </Filters>
> If there are two filters, the default relation is 'And', but how to set
the
> 'Or' relation? Does Report Service itself only support 'And' relation for
> report filter?
> Thanks in advance.

How to set default date

Hi Guys,

I have a time standard dimension used as a filter to my report.

How can I set the parameter to get the current month and year to be used by the time standard filter.

Select the report, and go to Report->Parameters, select the parameter, in the default values sectoin, set the value there. You can use function too, like get current date, use =Today, and DatePart() to get year, month, date, whatever.

How to set connection, Send Parameter and Filter data

Dear all .Netter,

I'm newbie in Reporting Services. I'm able to creating raw Reporting Services reports.

I have these questions to you all :

1. How to change connection to server and database when running in ASP.Net form. Currently in development PC, the server name is ServerA and the Database name is DatabaseA. After i copy to production server, the server name is ServerB and the database name is DatabaseB.

2. How to send parameter to Reporting Services report. I want to show name of user that print the report.

3. How to filter data that will be showed in the Reporting Services. I want to print Invoice with no : INV-2007-0001 and next INV-2007-0002

Sorry, if I'm lazy, but i'm running with time to replace Crystal Reports with Reporting Services.

Thanks and Regards,

Kusno.

These are some great links that will give you any answer you want

http://www.codeproject.com/sqlrs/AHCreatRepsAspNet.asp
http://msdn2.microsoft.com/en-us/library/ms170246.aspx
http://www.codeproject.com/sqlrs/ReportViewer2005.asp

Have Fun

How to set a parameter for filtering not blank records

In my report I want an optional parameter to filter all records with a specific field that is not blank. I tried several scenario's without result...

In the parameter I want to set a text value like "exampletext".

In the filter I want a check: if the parameter value is "exampletext", only show the records where field "abc" is not blank.

On the tab Filters from the Table properties I can set three values: Expression, Operator and Value.

Please help!

I've found the solution.

Expression: =Iif(Parameters!Parameter.Value="exampletext",(Fields!Fieldname),"NULL")

Operator: >

Value: 0

How to set a parameter for filtering not blank records

In my report I want an optional parameter to filter all records with a specific field that is not blank. I tried several scenario's without result...

In the parameter I want to set a text value like "exampletext".

In the filter I want a check: if the parameter value is "exampletext", only show the records where field "abc" is not blank.

On the tab Filters from the Table properties I can set three values: Expression, Operator and Value.

Please help!

I've found the solution.

Expression: =Iif(Parameters!Parameter.Value="exampletext",(Fields!Fieldname),"NULL")

Operator: >

Value: 0