matrix sum

hello

I have a count (bookings.id) as nobookings in my query, which returns a count of all specific classes for a member. In the matrix i have sum(fields!nobookings.value) which adds the bookings by class type (1 tennis, 2 golf, 3 cricket). Now i need the total of all classes by pmember (6 in this case). Can srs do this?

I assume you have a row or column grouping on the class type in the matrix, and then you get the sum of nobookings in the cells under each class type. If this is what you currently have in the matrix, just add subtotal (right-click on the row or column header, and click on subtotal) to that row or column, and you should get the total or all classes in the cells under the subtotal.|||I have the same problem, but whenever I add subtotals, the total figure is just the first value in a cell and not the total of all values. What am I doing wrong? Thanks!|||Check on the aggregate function in the expression for the cell textbox, and make sure you are using Sum() instead of First().|||I have the same problem as the subtotal only displays the first value of the row. But I could not find where is the place to change the expression. All the values below the 'Total' header in layout is greyed out and it drived me crazy. Could you please advice? Thanks a lot.|||

You dont directley edit the subtotal expression.

Add the Sum() to the row\column details expression,
as the subtotal uses the expression from R/C detail
as it's own.

Hope I'm being clear enough

G

|||Thanks you so much. I think I finally got it.|||Regarding about the issue of subtotal.I am encountering a problem,wherein,when i use the aggregate sum in the details expression,the value changed from the actual value in my database?Can you have any suggestions about it?Thanks!!

matrix sum

hello

I have a count (bookings.id) as nobookings in my query, which returns a count of all specific classes for a member. In the matrix i have sum(fields!nobookings.value) which adds the bookings by class type (1 tennis, 2 golf, 3 cricket). Now i need the total of all classes by pmember (6 in this case). Can srs do this?

I assume you have a row or column grouping on the class type in the matrix, and then you get the sum of nobookings in the cells under each class type. If this is what you currently have in the matrix, just add subtotal (right-click on the row or column header, and click on subtotal) to that row or column, and you should get the total or all classes in the cells under the subtotal.|||I have the same problem, but whenever I add subtotals, the total figure is just the first value in a cell and not the total of all values. What am I doing wrong? Thanks!|||Check on the aggregate function in the expression for the cell textbox, and make sure you are using Sum() instead of First().|||I have the same problem as the subtotal only displays the first value of the row. But I could not find where is the place to change the expression. All the values below the 'Total' header in layout is greyed out and it drived me crazy. Could you please advice? Thanks a lot.|||

You dont directley edit the subtotal expression.

Add the Sum() to the row\column details expression,
as the subtotal uses the expression from R/C detail
as it's own.

Hope I'm being clear enough

G

|||Thanks you so much. I think I finally got it.|||Regarding about the issue of subtotal.I am encountering a problem,wherein,when i use the aggregate sum in the details expression,the value changed from the actual value in my database?Can you have any suggestions about it?Thanks!!

matrix sum

hello

I have a count (bookings.id) as nobookings in my query, which returns a count of all specific classes for a member. In the matrix i have sum(fields!nobookings.value) which adds the bookings by class type (1 tennis, 2 golf, 3 cricket). Now i need the total of all classes by pmember (6 in this case). Can srs do this?

I assume you have a row or column grouping on the class type in the matrix, and then you get the sum of nobookings in the cells under each class type. If this is what you currently have in the matrix, just add subtotal (right-click on the row or column header, and click on subtotal) to that row or column, and you should get the total or all classes in the cells under the subtotal.|||I have the same problem, but whenever I add subtotals, the total figure is just the first value in a cell and not the total of all values. What am I doing wrong? Thanks!|||Check on the aggregate function in the expression for the cell textbox, and make sure you are using Sum() instead of First().|||I have the same problem as the subtotal only displays the first value of the row. But I could not find where is the place to change the expression. All the values below the 'Total' header in layout is greyed out and it drived me crazy. Could you please advice? Thanks a lot.|||

You dont directley edit the subtotal expression.

Add the Sum() to the row\column details expression,
as the subtotal uses the expression from R/C detail
as it's own.

Hope I'm being clear enough

G

|||Thanks you so much. I think I finally got it.

matrix sum

hello

I have a count (bookings.id) as nobookings in my query, which returns a count of all specific classes for a member. In the matrix i have sum(fields!nobookings.value) which adds the bookings by class type (1 tennis, 2 golf, 3 cricket). Now i need the total of all classes by pmember (6 in this case). Can srs do this?

I assume you have a row or column grouping on the class type in the matrix, and then you get the sum of nobookings in the cells under each class type. If this is what you currently have in the matrix, just add subtotal (right-click on the row or column header, and click on subtotal) to that row or column, and you should get the total or all classes in the cells under the subtotal.|||I have the same problem, but whenever I add subtotals, the total figure is just the first value in a cell and not the total of all values. What am I doing wrong? Thanks!|||Check on the aggregate function in the expression for the cell textbox, and make sure you are using Sum() instead of First().|||I have the same problem as the subtotal only displays the first value of the row. But I could not find where is the place to change the expression. All the values below the 'Total' header in layout is greyed out and it drived me crazy. Could you please advice? Thanks a lot.|||

You dont directley edit the subtotal expression.

Add the Sum() to the row\column details expression,
as the subtotal uses the expression from R/C detail
as it's own.

Hope I'm being clear enough

G

|||Thanks you so much. I think I finally got it.

Matrix Report: Need some suggestions please

I have to create a report that will list the room bookings for a certain
hotel in a certain time frame.
Sound easy enough right...
This is what the report should look like, first lets accept that I pass in
parameters for the following:
1. Start Date
2. End Date
3. The hotel I want the the bookings for
Then the report should look like the following:
Static Column
Twin Room 1
Twin Room 2
Single 1
1 Jan 2004
Party Name
Guest Names
Agency
Jones x2
R. Jones
T. Jones
AAA Travel
2 Jan 2004
Party Name
Guest Names
Agency
Twin Room 1
Twin Room 2
Twin Room 3
Single 1
3 Jan 2004
Party Name
Guest Names
Agency
Gates x1
B. Gates
MS
As you can see from above the amount of rooms changes on certain dates
depending on seasons etc. so the columns should be able to change
dynamicaly.
The rooms don't have a unique number - The hotel has listing of room types,
and how many rooms there are ie.
Hotel1,Twin,2
Hotel1,Single,1
Do i need to use some form of cubed data?
Have tables/matrix within tables/matrix?
Use lists, with tables in them?
How would I want my data returned to achieve the desired result?
Some suggestions, ideas would be appreciated.
Thanks in advance.Ok so Outlook Express don't like tables that much here is the table layout
Static Column Twin Room 1 Twin
Room 2 Single 1
1 Jan 2004 Party Name Jones x2
Guest Names R. Jones
T. Jones
Agency AAA Travel
2 Jan 2004 <empty row>
Twin Room 1
Twin Room 2 Twin Room 3 Single 1
3 Jan 2004 MS Party x2
Oracle x1
B. Gates
L. Jones
S. Balmer
MS Travel
Oracle Travel
Hope this is clearer now.
"Reg" <reg@.dsl.za.org> wrote in message
news:uaYE%23ugpEHA.2340@.TK2MSFTNGP11.phx.gbl...
> I have to create a report that will list the room bookings for a certain
> hotel in a certain time frame.
> Sound easy enough right...
> This is what the report should look like, first lets accept that I pass in
> parameters for the following:
> 1. Start Date
> 2. End Date
> 3. The hotel I want the the bookings for
> Then the report should look like the following:
>
> Static Column
> Twin Room 1
> Twin Room 2
> Single 1
> 1 Jan 2004
> Party Name
> Guest Names
>
> Agency
>
>
> Jones x2
> R. Jones
> T. Jones
> AAA Travel
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 2 Jan 2004
> Party Name
> Guest Names
>
> Agency
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Twin Room 1
> Twin Room 2
> Twin Room 3
> Single 1
> 3 Jan 2004
> Party Name
> Guest Names
>
> Agency
>
>
> Gates x1
> B. Gates
>
> MS
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> As you can see from above the amount of rooms changes on certain dates
> depending on seasons etc. so the columns should be able to change
> dynamicaly.
> The rooms don't have a unique number - The hotel has listing of room
types,
> and how many rooms there are ie.
> Hotel1,Twin,2
> Hotel1,Single,1
> Do i need to use some form of cubed data?
> Have tables/matrix within tables/matrix?
> Use lists, with tables in them?
> How would I want my data returned to achieve the desired result?
> Some suggestions, ideas would be appreciated.
> Thanks in advance.
>