Showing posts with label items. Show all posts
Showing posts with label items. Show all posts

Monday, March 26, 2012

how to total the values in a numeric column?

I'm building a report using the matrix control. I have financial data in
different line items (Salary, Rental Expense etc) that needs to be shown by
month (so the columns have months). I have it pretty much working but can't
figure out how to sum up the numbers in each column at the bottom so I can
have a total for every month. Could anyone help?
Thanks a lot.
BobRight-click on the row field that you wish to total, in your case it
would be the Salary field. Choose Sub-total from the menu.
To format the subtotals you need to right-click->properties on the tiny
green triangle that appears on the Total cell.|||ahhh. I was thinking this must be something really simple since it's such a
common function. You can't believe how much time I had spent trying to
figure this out. Thanks a lot.
Bob
"grahamiec" <grahamrichter@.gmail.com> wrote in message
news:1123769689.664448.10490@.g14g2000cwa.googlegroups.com...
> Right-click on the row field that you wish to total, in your case it
> would be the Salary field. Choose Sub-total from the menu.
> To format the subtotals you need to right-click->properties on the tiny
> green triangle that appears on the Total cell.
>

Monday, March 12, 2012

How to Suppress the Hiden Row

Hi Group,
When i rendered the report to MHTML the hidden items are still displaying
and in the preview mode a blank space is displayed.So how do i suppress the
hidden items.When you hide a control you , the control only doesnt show
up but it still holds its position.
So you could actually have the values in a table and then
apply the hidden expression to the column.
In this case the column if its hidden will not show a blank
space.
Hope this helps
>--Original Message--
>Hi Group,
>When i rendered the report to MHTML the hidden items are
still displaying
>and in the preview mode a blank space is displayed.So how
do i suppress the
>hidden items.
>
>.
>