It seems the row/column lables are not automatically created in the matrix
report as in table report.
Anyone know how to do this?
Thanks,The matrix automatically creates the labels based on the x-axis (columns)
fields that you supply it.
-Tim
"yongli" <yongli@.discussions.microsoft.com> wrote in message
news:3BF751AA-4752-41B0-B1EE-5A6247B9C6B4@.microsoft.com...
> It seems the row/column lables are not automatically created in the matrix
> report as in table report.
> Anyone know how to do this?
> Thanks,|||Thanks for the quick response. Probably I didn't provide the full details.
When I used the report model base on my OLAP cube, the labels were created
automatically. I was talking about creating a free-form report using matrix,
when I draged the dataset (based on MDX) field over to the column/row in the
matrix, it didn't create lable for me, so I wonder if I have to manually add
it in the case.
Thanks,
"Tim Dot NoSpam" wrote:
> The matrix automatically creates the labels based on the x-axis (columns)
> fields that you supply it.
> -Tim
> "yongli" <yongli@.discussions.microsoft.com> wrote in message
> news:3BF751AA-4752-41B0-B1EE-5A6247B9C6B4@.microsoft.com...
> > It seems the row/column lables are not automatically created in the matrix
> > report as in table report.
> >
> > Anyone know how to do this?
> >
> > Thanks,
>
>|||Gotcha. If you use the report wizard first to see how the wizard sets up
the matrix, this might help. I usually use the matrix wizard to create the
report, mainly because I'm lazy...
T-im
"yongli" <yongli@.discussions.microsoft.com> wrote in message
news:19CACC04-476B-47A1-9962-3A90A724B7A4@.microsoft.com...
> Thanks for the quick response. Probably I didn't provide the full
> details.
> When I used the report model base on my OLAP cube, the labels were created
> automatically. I was talking about creating a free-form report using
> matrix,
> when I draged the dataset (based on MDX) field over to the column/row in
> the
> matrix, it didn't create lable for me, so I wonder if I have to manually
> add
> it in the case.
> Thanks,
> "Tim Dot NoSpam" wrote:
>> The matrix automatically creates the labels based on the x-axis (columns)
>> fields that you supply it.
>> -Tim
>> "yongli" <yongli@.discussions.microsoft.com> wrote in message
>> news:3BF751AA-4752-41B0-B1EE-5A6247B9C6B4@.microsoft.com...
>> > It seems the row/column lables are not automatically created in the
>> > matrix
>> > report as in table report.
>> >
>> > Anyone know how to do this?
>> >
>> > Thanks,
>>
Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
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.
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.
Subscribe to:
Posts (Atom)