u can create member flag which will give u values as true or false

for example:

with Member [Measures].[Status]as'[Measures].[ABC]>0'

and thn call this member is select

SELECT {[Measures].[Status],.......

and finally go to...

are u able to get both the charts in same report ???

I dont think that is possible....

Try using sub report option

may b u will hve to hide the sub report by default and when u click on some thing....the sub report should display...just call ur second...

First use sum(Field_Name) in all your Detail fields in Matrix and then Subtotal for Columns/Row Group....

you may try visibility option ...

say Suppose u have two tables in a report and second report is the sub-report of 1st one....

now say u want to show 1st table...

Hi,

Try using Sub-Total

Right click on Column/Row Group and select Sub-total

this might help u .....

right click on pie chart and go to properties . thr u will find the "Navigation" tab click on that and select "Jump to report" option

give the name of...

Hi

i m not sure abt showing both the charts in 1 report

and coming to going from 1 report to another ....the bar chart will b displayed in the...

you can try formatnumber function

e.g. =FormatNumber(Field,2)

where 2 is the number of digits u want after decimal

to display week as

lessthan 2 3-4 5-6 7-8 9-10 11-12 >14

write iif condition ...if...

Try using:

=(Fields!PersonnelCode.Value)

i m not sure wthr matrix within table is possible or not ..'

but table within matrix is possible...

try using Matrix within table by putting matrix in group header or group...

Make sure that "Repeat report item with data region on every page is selected " option is selected for that text box.

and also select data region for that ....that can...

U want both the chats to display on 1 report or when u click on pie chat based on that it show the bar chart in another report ???