Matrix with 2 subtotal

Hi All,

I wish to have a report with 2 subtotal using matrix control given by reporting service.

CD

DVD

Total Price

Total Qty

2.00

5.00

JOHN

5

25.00

5

JOLIN

5

10.00

5

Total Price

10.00

25.00

Total Qty

5

5

I only can came out total price(subtotal) which provided by matrix control.

Does the matrix control able to come out as table above with 2 subtotal?

Thanks

Kendy

The grid above has the unit price in the header and only the quantity measure in the details area. You need to create and additional Price measure and display both measures in the details area either on the rows or the columns as a static group. E.g.

Measures on Columns

CD

DVD

Total

2.00

5.00

Quantity

Price

Quantity

Price

Quantity

Price

JOHN

5

25

5

25

JOLIN

5

10

5

10

Total

5

10

5

25

10

35

Measures on Rows

CD

DVD

Total

2.00

5.00

JOHN

Quantity

5

5

Price

25

25

JOLIN

Quantity

5

5

Price

10

10

Total

Quantity

5

5

10

Price

10

25

35

|||

Thanks for your helps and advice.

Its really give me an ideas

Thanks Adam

Matrix Question

I have a view that gives me the following information from some tables.

Cust # Cust Name Date Order Type

001 John Doe 20070401 OR1

002 Miss Doe 20070401 OR2

001 John Doe 20070402 OR2

002 Miss Doe 20070402 OR2

What I would like to do is set up a matrix type report. The report is by the last 6 rolling order dates, with some % columns. So two row examples might be

Cust# Cust Name 20070401 20070402 % (of last x = OR1) %(of last x = OR2)

001 John Doe OR1 OR2 50% 50%

002 Miss Doe OR2 OR2 0% 100%

Another column just like the last two % based off a 3rd type, and finally a total % column that simply adds the 3 columns up (should always equal 100%, just an error check)

First, can this be done with a matrix? I tried a table but it lists cust# twice, but I can be doing it wrong. I am ok doing this within the query if need be, if someone gives me a hint how

Thanks,

When you tried the table, did you set a row group on the customer number?|||Yes, and it will not give me a column for each date in table form.

Master transaction log

Quick question - why is it not possible to backup the master database's transaction log
TIA
John BrownJohn Brown wrote:
> Quick question - why is it not possible to backup the master
> database's transaction log? TIA,
> John Brown
See:
PRB: Transaction Log Backups of Master Database Are Not Allowed
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q285/2/88.asp&NoWebContent=1
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Sebastian, this is helpful, but what I wondered is is there any logical reason why a master transaction log backup is not possible
Regards
Joh|||John Brown wrote:
> Thanks Sebastian, this is helpful, but what I wondered is is there
> any logical reason why a master transaction log backup is not
> possible? Regards,
Yes, it is. Master database is setup in the SIMPLE recovery mode, when
transaction log is truncated on checkpoints and its space occupied by
commited transactions is constantly reused. That is why SIMPLE recovery
model does not allow transaction logs backups. It is a small database with
only a few transactions from time to time, SIMPLE recovery model is optimal
for this system database.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Master transaction log

Quick question - why is it not possible to backup the master database's tran
saction log?
TIA,
John BrownJohn Brown wrote:
> Quick question - why is it not possible to backup the master
> database's transaction log? TIA,
> John Brown
See:
PRB: Transaction Log Backups of Master Database Are Not Allowed
http://support.microsoft.com/defaul...&NoWebContent=1
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Sebastian, this is helpful, but what I wondered is is there any logic
al reason why a master transaction log backup is not possible?
Regards,
John|||John Brown wrote:

> Thanks Sebastian, this is helpful, but what I wondered is is there
> any logical reason why a master transaction log backup is not
> possible? Regards,
Yes, it is. Master database is setup in the SIMPLE recovery mode, when
transaction log is truncated on checkpoints and its space occupied by
commited transactions is constantly reused. That is why SIMPLE recovery
model does not allow transaction logs backups. It is a small database with
only a few transactions from time to time, SIMPLE recovery model is optimal
for this system database.
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.