can somebody help me figuring out if the following is possible?
I have a matrix creating weeks out on "x-axis" and projects at "y-axis". For each project have i specified three rows, sum(Fields!hours.Value), sum(Fields!used.Value) and a total saying (sum)Fields!used.Value - sum(Fields!hours.Value).
12 13 14 15 16
A 3 4 5 3 4
2 4 3 4 1
-1 0 -2 1 -3
B ... and so forth...
What i would like is to have only the total row displayed initially, and the through drill-down on clicking A being able to se the two columns used to calculate the total.
I can't seem to figure it out.
Hope somebody out there has an idea for this - or can say that it cant be done for sure.. :-)
Best RegardsYou need to set the inner group (in the group properties) to be initially hidden and toggle the group visibility on the textbox. Make sure you have subtotals turned on (click on the outer group and select 'display subtotals').|||Thanks for the answer, but I can't seem to get this right.
I think maybe the problem is that i don't have anything to group for. Theres nothing that i can group so that the three rows becomes one. They are all just different sums of the one row in the dataset.
Am i getting it wrong? If i select one of the three fields i cant seem to select the "toggle visibility".
Can you follow me?|||
You always have a group in the matrix. If you aren't using any grouping, then you probably should be using a table dataregion. Can you bring up the matrix properties? Also, you could give more of an idea what you are trying to do.
|||Hi Brian,
I have a similar problem and I wandered if you answer is what I might possibly need, but I haven't been able to implement it.
This is the part of my report. I have first group row being same company branch, second group row are clients and the third one is destinations where those clients were travelling. The measurement is the amount they spent on those destinations. This is the expanded version which look as it should. But look below for not expanded version and that is the one I have problem with.
What I would like to see in not expanded version is just totals for the group rows. But what I am getting is suppressed description of the group rows but expended amounts as in the previous version. There is a little + next to Al in my version to show it is not expended version but for some reson it didn't come in here.
Interesting enough is that when exported into excel it works as it should be but in to Reporting Services as well.
Thanks a lot
Cheers
Marina
|||I think I found out what my problem is. I was setting up the visability on the field instead of on the group.
Thanks
Marina
|||Hi!!, what happend with you repor, t could you find an answer? I have the same question.
sql
No comments:
Post a Comment