Matrix Rows

Is it possible to move rows in a matrix up and down from its original
position? Preferably in a drag n drop structure.
Everytime I add a new field to a matrix I need to do manually change the
field names in the text box in the position I need the new field name.
Thanks.Do you have list of fields,you want to see on the matrix
I mean when you are saying i am adding new field ,i feel you cant get
additonal column unless you add in the table or stored procedure you
have to compile
So by assuming you have the list of filed names before you run the
report,
1)have a parametre,in that go to Non -Queried values,give the field
name desc in drop down
2)in place of column header ,give expression like
iif(parametre=1,"Desc",IIF(param=2,"Desc2","desc3)))
3)In detailcell
iif(parametre=1,"Fields!Desc.Value",IIF(param=2,"Fields!Desc2","Fields!desc3.value)))
Regards
Raj Deep.A
Brian Shannon wrote:
> Is it possible to move rows in a matrix up and down from its original
> position? Preferably in a drag n drop structure.
> Everytime I add a new field to a matrix I need to do manually change the
> field names in the text box in the position I need the new field name.
> Thanks.

matrix report

Hello,

Am having this problem, and i have not been able to solve it as yet.

The requirement is to have a matrix like structure such as:

Column Header

Row Header Value1;
Value2;

I was able to create a matrix report using SQL Reporting services 2000, placed the column as well as Row headers, however, the value can be just an aggregate expression, which means I can have only one value as the data. But the requirements is to have multiple values in the data placeholder.

Does anyone have experienced the same problem as me? Any help will be highly appreciated.

Regards

Santosh

You can make like a tree in a Table control. You can add the main value in Header and when u click on it, it can display multiple values in detail row.

Matrix or Table

Good afternoon!
I have the following problem:
There is a table with following structure: PersonID, PersonName,
Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ...,
Z1,Z2,Z3).
I need the following table:
PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... |
Z1|Z2|Z3| Z1 + Z2 + Z3|(Z1+Z2+Z3)/Total|Total
Is Table is the only solution (and I really need to fill each cell
with details) or it cone be done by means of Matrix
Thank you,you can use either, but Matrix is dynamic - table is static
If there will always be a fixed number of columns, then you can use table,
but in your example, i'd go the matrix approach.
<mnemets@.gmail.com> wrote in message
news:1170333996.383084.308920@.j27g2000cwj.googlegroups.com...
> Good afternoon!
> I have the following problem:
> There is a table with following structure: PersonID, PersonName,
> Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ...,
> Z1,Z2,Z3).
> I need the following table:
> PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... |
> Z1|Z2|Z3| Z1 + Z2 + Z3|(Z1+Z2+Z3)/Total|Total
> Is Table is the only solution (and I really need to fill each cell
> with details) or it cone be done by means of Matrix
> Thank you,
>|||On 1 æÅ×., 18:46, "Immy" <therealasianb...@.hotmail.com> wrote:
> you can use either, butMatrixis dynamic -tableis static
> If there will always be a fixed number of columns, then you can use table,
> but in your example, i'd go thematrixapproach.
Thank you for reply.
Bur really I can't do it by matrix. Which column groups should I use,
and how can I do it ?
Thank you,|||To be clear "I can't do it by matrix" means "I don't know how to do
it by matrix"|||It means 26 * 3 + 2 = 80 columns in your table is it ok that you can have
this much, you cannot read and you need to scroll or you need all alphabets
in one row each.
Amarnath
"mnemets@.gmail.com" wrote:
> Good afternoon!
> I have the following problem:
> There is a table with following structure: PersonID, PersonName,
> Field1. Filed1 is enum type with values (A1, A2, A3, B1,B2,B3, ...,
> Z1,Z2,Z3).
> I need the following table:
> PersonID|PersonName|A1| A2|A3|(A1 + A2 + A3)|(A1+A2+A3)/Total | ... |
> Z1|Z2|Z3| Z1 + Z2 + Z3|(Z1+Z2+Z3)/Total|Total
> Is Table is the only solution (and I really need to fill each cell
> with details) or it cone be done by means of Matrix
> Thank you,
>|||Actually I am talking about 3 groups (A,B,C). In a future the nuber of
these group can be changed (not more than 5!). So it means 3*4 (three
values in a group and subtotal for the group) + 1 = 13. Maximum is 5*4
+ 1 = 21. Not so bad.
But the real problem is that I have no ideas how such matrix can be
done.
Thank you

Matrix building difficulties

Hello all,
I have the following temporary table structure which I already
populated with a regular query to the main database:
CREATE TABLE #MESVENPAR2 (
CONTAID BIGINT, -- ID of Partner
CONNAME VARCHAR(100), -- Name of Partner
CONZONE VARCHAR(50), -- Geaographical Zone of Partner
PRODCAT BIGINT, -- Product Category Code
TOTAL BIGINT -- Total Products
)
Basically, the table contains the total of sales per product category
for each partner. Were there an index, it would be a composite one
between CONTAID and PRODCAT
Now...
I need to query this data into a matrix. The structure would be:
IDPART | PARTNAME | PARTZONE VARCHAR(50) | CAT_1 | CAT_2 | ...
Where CAT_1, CAT_2, and so forth, refer to the product category code
prefixed by 'CAT_'. Each line would thus contain the partner id, its
name and zone, and either 0 or the value of TOTAL for each product
category.
How can I make this?
TIAhttp://www.aspfaq.com/show.asp?id=2462
David Portas
SQL Server MVP
--|||On 7 Mar 2005 02:57:42 -0800, Marfig wrote:
(snip)
>Basically, the table contains the total of sales per product category
>for each partner. Were there an index, it would be a composite one
>between CONTAID and PRODCAT
Hi Marfig,
What's the reason for not actually declaring this combination as the
primary key in the tebporary table? Inquiring mind wants to know...

>Now...
>I need to query this data into a matrix. The structure would be:
>IDPART | PARTNAME | PARTZONE VARCHAR(50) | CAT_1 | CAT_2 | ...
This is called a crosstab (or pivot) operation. Several useful links can
be found here: http://www.aspfaq.com/show.asp?id=2462
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Thanks both.
It's a somewhat small table, Hugo. Not worth at all of an index. In
fact, I will rather prefer to have it done without a temporary table.
With your help, I'll be able to come up with a more elegant solution.
Thanks again.

Matrix and Averages

My Matrix has the following structure
Product Jan Feb Mar Total
--
Prroduct1 2 4 1 6
How would I add an "average column"
Product Jan Feb Mar Total Avg
--
Prroduct1 2 4 1 6 2Okay, I solved my % Total problem.
In the data region, I split the cell into two, one is the original data, the
other is the % of the left cell to the scope. Then the Total and %Total
appear side by side if you do subtotal to the group. After that, hide the
%Total column using inscope function if it is in the scope.
But I am very interested in knowing if it is possible to do average though.
"Frank RS" wrote:
> I have the similar situation-- to add a %Total after the Total filed.
> It looks impossible because Total column is pretty much the last column in a
> matrix.
> Microsoft gurus, please help on this problem.
> At least let us know if it is doablt.
> Thanks in advance!
> Frank
> "SAcanuck" wrote:
> > My Matrix has the following structure
> > Product Jan Feb Mar Total
> > --
> > Prroduct1 2 4 1 6
> >
> > How would I add an "average column"
> >
> > Product Jan Feb Mar Total Avg
> > --
> > Prroduct1 2 4 1 6 2
> >|||I guess I got the answer to this question too.
Just modify the expression to change the sum function into average function.
I will post if I got time to play with it.
"Frank RS" wrote:
> Okay, I solved my % Total problem.
> In the data region, I split the cell into two, one is the original data, the
> other is the % of the left cell to the scope. Then the Total and %Total
> appear side by side if you do subtotal to the group. After that, hide the
> %Total column using inscope function if it is in the scope.
> But I am very interested in knowing if it is possible to do average though.
> "Frank RS" wrote:
> > I have the similar situation-- to add a %Total after the Total filed.
> > It looks impossible because Total column is pretty much the last column in a
> > matrix.
> > Microsoft gurus, please help on this problem.
> > At least let us know if it is doablt.
> > Thanks in advance!
> > Frank
> >
> > "SAcanuck" wrote:
> >
> > > My Matrix has the following structure
> > > Product Jan Feb Mar Total
> > > --
> > > Prroduct1 2 4 1 6
> > >
> > > How would I add an "average column"
> > >
> > > Product Jan Feb Mar Total Avg
> > > --
> > > Prroduct1 2 4 1 6 2
> > >