Can have two measure values?

Hi,
Can we have two measure values in a Matrix?
for example that I want to display both unit Sales and Sales Count in a
Matrix.Yes you can. Just right-click on a matrix cell and select "Add Column" or
"Add Row". You can then calculate the sales count in the new cell.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:OY%23xy6nlEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can we have two measure values in a Matrix?
> for example that I want to display both unit Sales and Sales Count in a
> Matrix.
>|||Why is it that when you add more than one value to a matrix report like this,
it will no longer export to HTMLOWC?
"Robert Bruckner [MSFT]" wrote:
> Yes you can. Just right-click on a matrix cell and select "Add Column" or
> "Add Row". You can then calculate the sales count in the new cell.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> news:OY%23xy6nlEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> > Can we have two measure values in a Matrix?
> > for example that I want to display both unit Sales and Sales Count in a
> > Matrix.
> >
> >
>
>|||Please read this section in BOL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
When adding additional "measures", you add static columns or static rows to
the matrix.
When a report is rendered to HTML with OWC, and you use static rows /
columns then you might run into one of these limitations:
* the matrix has both static columns and static rows
* dynamic columns or rows are nested inside static columns or rows
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clortex" <clortex@.discussions.microsoft.com> wrote in message
news:657353CE-0AEE-4EFD-B795-005F0BD06DB0@.microsoft.com...
> Why is it that when you add more than one value to a matrix report like
this,
> it will no longer export to HTMLOWC?
> "Robert Bruckner [MSFT]" wrote:
> > Yes you can. Just right-click on a matrix cell and select "Add Column"
or
> > "Add Row". You can then calculate the sales count in the new cell.
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > news:OY%23xy6nlEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > Hi,
> > > Can we have two measure values in a Matrix?
> > > for example that I want to display both unit Sales and Sales Count in
a
> > > Matrix.
> > >
> > >
> >
> >
> >|||Thank, it is good guestion to me!
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:#WEWpFulEHA.2588@.TK2MSFTNGP12.phx.gbl...
> Please read this section in BOL:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
> When adding additional "measures", you add static columns or static rows
to
> the matrix.
> When a report is rendered to HTML with OWC, and you use static rows /
> columns then you might run into one of these limitations:
> * the matrix has both static columns and static rows
> * dynamic columns or rows are nested inside static columns or rows
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "clortex" <clortex@.discussions.microsoft.com> wrote in message
> news:657353CE-0AEE-4EFD-B795-005F0BD06DB0@.microsoft.com...
> > Why is it that when you add more than one value to a matrix report like
> this,
> > it will no longer export to HTMLOWC?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> > > Yes you can. Just right-click on a matrix cell and select "Add Column"
> or
> > > "Add Row". You can then calculate the sales count in the new cell.
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "ad" <ad@.wfes.tcc.edu.tw> wrote in message
> > > news:OY%23xy6nlEHA.1656@.TK2MSFTNGP09.phx.gbl...
> > > > Hi,
> > > > Can we have two measure values in a Matrix?
> > > > for example that I want to display both unit Sales and Sales Count
in
> a
> > > > Matrix.
> > > >
> > > >
> > >
> > >
> > >
>

Can a table, matrix or list produce this?

I am converting a report from a Clipper application and the existing reports
shows States with some additional information in a format I am finding hard
to reproduce. On first glance the report looks like a simple tabular
format. There are something like 10 rows in the table with 3 columns. The
first item of data is placed in row 1 column 1. The second item is in row 1
column 2 and the third item is row 1 column three. The fourth item is in
row 2 and column 1. I can use a matrix and produce the rows going
horizontally but I am not sure how to limit the columns to 3 and start new
rows below that. Below is an example.
AL 12345 AR 12367 CA 19494
CO 38823 CT 43984 GA 39393
IA 39390 ID 39390 IL 39300
Any idea would be greatly appreciated.
Thanks.You may be interested in this blog article:
http://blogs.msdn.com/chrishays/archive/2004/07/23/193292.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lely@.nospam.com> wrote in message
news:e1xduBf4EHA.1452@.TK2MSFTNGP11.phx.gbl...
> I am converting a report from a Clipper application and the existing
reports
> shows States with some additional information in a format I am finding
hard
> to reproduce. On first glance the report looks like a simple tabular
> format. There are something like 10 rows in the table with 3 columns.
The
> first item of data is placed in row 1 column 1. The second item is in row
1
> column 2 and the third item is row 1 column three. The fourth item is in
> row 2 and column 1. I can use a matrix and produce the rows going
> horizontally but I am not sure how to limit the columns to 3 and start new
> rows below that. Below is an example.
> AL 12345 AR 12367 CA 19494
> CO 38823 CT 43984 GA 39393
> IA 39390 ID 39390 IL 39300
> Any idea would be greatly appreciated.
> Thanks.
>

Can a column from a table be split up into multiple columns?

I have a table in SQL SERVER with two columns that look kinda like
this:
type: amount:
trav 2.00
spend 1.50
matrix 3.00
spend 5.25
spend 2.25
trav 3.15
When these columns get to the report, they need to be split as columns
of those three types:
trav spend matrix
2.00 1.50 3.00
3.15 5.25
2.25
Would I go to the Layout tab to create agregated functions
to separate this with functions there?
Thanks,
TrinityDid you try to use matrix instead of table?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"trint" <trinity.smith@.gmail.com> wrote in message
news:1105478740.066071.114760@.f14g2000cwb.googlegroups.com...
>I have a table in SQL SERVER with two columns that look kinda like
> this:
> type: amount:
> trav 2.00
> spend 1.50
> matrix 3.00
> spend 5.25
> spend 2.25
> trav 3.15
> When these columns get to the report, they need to be split as columns
> of those three types:
> trav spend matrix
> 2.00 1.50 3.00
> 3.15 5.25
> 2.25
> Would I go to the Layout tab to create agregated functions
> to separate this with functions there?
> Thanks,
> Trinity
>