Accessing sub totals in a matrix

Hi,

How can I access the subtotal cells/values from each of the columns in Matrix and use them for calculations on other places in the report?

Thanks.

Any body?

How can I access the sub-totals of a Matrix as I need to use them in calculations in another place on the report? How can I programatically access the matrix report item's cell or text box values, particularly the sub totals?

Thanks,

|||Does any one know how the sub total field can be accessed in the matrix?|||

Right click on your Column Group Header to acces the Column Subtotal. Same with the Row Group header for the Row Subtotal. I don't think you can access the Subtotal value in other places on the report though.

-Aayush

|||Well, I meant how to access the contents of a subtotal in a running matrix for use in computation in another column/text box. How to access a particular sub total cell value, and say, subtract it from the cell value of another matrix column at corresponding level and display that in a third column.

Accessing sub totals in a matrix

Hi,

How can I access the subtotal cells/values from each of the columns in Matrix and use them for calculations on other places in the report?

Thanks.

Any body?

How can I access the sub-totals of a Matrix as I need to use them in calculations in another place on the report? How can I programatically access the matrix report item's cell or text box values, particularly the sub totals?

Thanks,

|||Does any one know how the sub total field can be accessed in the matrix?|||

Right click on your Column Group Header to acces the Column Subtotal. Same with the Row Group header for the Row Subtotal. I don't think you can access the Subtotal value in other places on the report though.

-Aayush

|||Well, I meant how to access the contents of a subtotal in a running matrix for use in computation in another column/text box. How to access a particular sub total cell value, and say, subtract it from the cell value of another matrix column at corresponding level and display that in a third column.

Accessing report parameters from code module can it be done?

I'm trying to get around a problem where my client wants to have totals from
each grouping in the report table displayed at the top of the report body
above the report table. It's easy to see why you can't just grab values from
the grouping footers and place them elsewhere. I had an idea to create some
report parameters and as the report is being rendered, run some custom code
that evaluates the field I'm trying to total and modifies the report
parameter I created for that specific total. Then I could use the report
parameter to display that specific total.
The problems with this are.. It seems that if I pass the parameter object
into the custom code function, it becomes read-only. Next, how would I be
able to tell the textbox that will show the total to wait to render until the
END of the report rendering. Lots of problems to try to overcome.
Basically, I need to take the value of a total in a subgroup (there are like
7 subgroups, so 7 different totals -- I can already take the ENTIRE report
total, but that's not what's neded) and copy it to a textbox either in the
report body ABOVE the report table.
Thanks for any tips.
--
Ken Fayal
Raptor Development Corp.I thought about this some and the only thing I can come up with is to have a
second dataset that has the same grouping and sums and reference the second
dataset at the top of the report. (By grouping I mean in SQL, not in RS).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ken Fayal" <ken@.raptordev.com.spamfree> wrote in message
news:5E4D812B-4868-44A7-BD79-F9E75C748F5C@.microsoft.com...
> I'm trying to get around a problem where my client wants to have totals
from
> each grouping in the report table displayed at the top of the report body
> above the report table. It's easy to see why you can't just grab values
from
> the grouping footers and place them elsewhere. I had an idea to create
some
> report parameters and as the report is being rendered, run some custom
code
> that evaluates the field I'm trying to total and modifies the report
> parameter I created for that specific total. Then I could use the report
> parameter to display that specific total.
> The problems with this are.. It seems that if I pass the parameter object
> into the custom code function, it becomes read-only. Next, how would I be
> able to tell the textbox that will show the total to wait to render until
the
> END of the report rendering. Lots of problems to try to overcome.
> Basically, I need to take the value of a total in a subgroup (there are
like
> 7 subgroups, so 7 different totals -- I can already take the ENTIRE report
> total, but that's not what's neded) and copy it to a textbox either in
the
> report body ABOVE the report table.
> Thanks for any tips.
> --
> Ken Fayal
> Raptor Development Corp.
>|||Bruce,
Thanks. What I ended up doing was create a subreport and put that at the
top. It works great. I guess I could have created another dataset, but he
subreport was easy because I had to use the same subreport in many other
reports.
"Bruce L-C [MVP]" wrote:
> I thought about this some and the only thing I can come up with is to have a
> second dataset that has the same grouping and sums and reference the second
> dataset at the top of the report. (By grouping I mean in SQL, not in RS).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Ken Fayal" <ken@.raptordev.com.spamfree> wrote in message
> news:5E4D812B-4868-44A7-BD79-F9E75C748F5C@.microsoft.com...
> > I'm trying to get around a problem where my client wants to have totals
> from
> > each grouping in the report table displayed at the top of the report body
> > above the report table. It's easy to see why you can't just grab values
> from
> > the grouping footers and place them elsewhere. I had an idea to create
> some
> > report parameters and as the report is being rendered, run some custom
> code
> > that evaluates the field I'm trying to total and modifies the report
> > parameter I created for that specific total. Then I could use the report
> > parameter to display that specific total.
> >
> > The problems with this are.. It seems that if I pass the parameter object
> > into the custom code function, it becomes read-only. Next, how would I be
> > able to tell the textbox that will show the total to wait to render until
> the
> > END of the report rendering. Lots of problems to try to overcome.
> >
> > Basically, I need to take the value of a total in a subgroup (there are
> like
> > 7 subgroups, so 7 different totals -- I can already take the ENTIRE report
> > total, but that's not what's neded) and copy it to a textbox either in
> the
> > report body ABOVE the report table.
> >
> > Thanks for any tips.
> >
> > --
> > Ken Fayal
> > Raptor Development Corp.
> >
>
>