matrix row grouping

HI,
Is it possible to have row grouping for each row in a matrix'
Something like
header1 header2
Task1
Section1
Row1 value1 value1
Section2
Row2 value2 value2
Task2
Section1
Row1 value1 value1
When i use a matrix grouping it is producing the result as
Task1 Section1 Row1 value1 value1
Section2 Row2 value2 value2
Task2 Section1 Row1 value1 value1
What i need to get the similiar look and feel as the previous one....
I could get this design with a table grouping but the columns are populated
dynamically... which is not possible in a table so im shifting to a matrix...
Your help is highly appreciated...
Thanks,Right click the data cell and do 'Add Row'.
You are effectively creating two rows per record.
Chris
CCP wrote:
> HI,
> Is it possible to have row grouping for each row in a matrix'
> Something like
> header1 header2
> Task1
> Section1
> Row1 value1 value1
> Section2
> Row2 value2 value2
> Task2
> Section1
> Row1 value1 value1
> When i use a matrix grouping it is producing the result as
> Task1 Section1 Row1 value1 value1
> Section2 Row2 value2 value2
> Task2 Section1 Row1 value1 value1
> What i need to get the similiar look and feel as the previous
> one.... I could get this design with a table grouping but the
> columns are populated dynamically... which is not possible in a table
> so im shifting to a matrix...
>
> Your help is highly appreciated...
> Thanks,|||Thanks chris for ur reply...
When i add a row like that..its repeating column wise i want it to repeat
row wise...
Thanks,
"Chris McGuigan" wrote:
> Right click the data cell and do 'Add Row'.
> You are effectively creating two rows per record.
> Chris
>
> CCP wrote:
> > HI,
> > Is it possible to have row grouping for each row in a matrix'
> >
> > Something like
> >
> > header1 header2
> > Task1
> > Section1
> > Row1 value1 value1
> > Section2
> > Row2 value2 value2
> > Task2
> > Section1
> > Row1 value1 value1
> >
> > When i use a matrix grouping it is producing the result as
> > Task1 Section1 Row1 value1 value1
> > Section2 Row2 value2 value2
> > Task2 Section1 Row1 value1 value1
> >
> > What i need to get the similiar look and feel as the previous
> > one.... I could get this design with a table grouping but the
> > columns are populated dynamically... which is not possible in a table
> > so im shifting to a matrix...
> >
> >
> > Your help is highly appreciated...
> >
> > Thanks,
>|||I'm with you now!
It's possible but it's a bit of a hack.
Basically you need to squeeze two text boxes into the row header, you
can do this with 'rectangle' controls.
Create a rectangle OUTSIDE the data region, create two textboxes inside
the rectangle, laid out the way you want them. Set their values to the
appropriate fields.
Cut and paste the rectangle into the row group cell on the matrix and
Bingo! it should work.
The downside to this method is it can be quite fiddly to get the
formatting just right but you can do it.
To try and explain it graphically, the structure of your matrix should
be something like this.
+--Matrix--+--+
| | |
+--+--+
|+==Rectangle=========+| |
||+--Textbox1--+|| |
||| ||| |
||+--+|| |
||+--Textbox2--+|| |
||| ||| |
||+--+|| |
|+====================+| |
+--+--+
Chris
CCP wrote:
> Thanks chris for ur reply...
> When i add a row like that..its repeating column wise i want it to
> repeat row wise...
> Thanks,
>
> "Chris McGuigan" wrote:
> > Right click the data cell and do 'Add Row'.
> > You are effectively creating two rows per record.
> >
> > Chris
> >
> >
> >
> > CCP wrote:
> >
> > > HI,
> > > Is it possible to have row grouping for each row in a matrix'
> > >
> > > Something like
> > >
> > > header1 header2
> > > Task1
> > > Section1
> > > Row1 value1 value1
> > > Section2
> > > Row2 value2 value2
> > > Task2
> > > Section1
> > > Row1 value1 value1
> > >
> > > When i use a matrix grouping it is producing the result as
> > > Task1 Section1 Row1 value1 value1
> > > Section2 Row2 value2 value2
> > > Task2 Section1 Row1 value1 value1
> > >
> > > What i need to get the similiar look and feel as the previous
> > > one.... I could get this design with a table grouping but the
> > > columns are populated dynamically... which is not possible in a
> > > table so im shifting to a matrix...
> > >
> > >
> > > Your help is highly appreciated...
> > >
> > > Thanks,
> >
> >|||Thanks Chris,
That worked...
"Chris McGuigan" wrote:
> I'm with you now!
> It's possible but it's a bit of a hack.
> Basically you need to squeeze two text boxes into the row header, you
> can do this with 'rectangle' controls.
> Create a rectangle OUTSIDE the data region, create two textboxes inside
> the rectangle, laid out the way you want them. Set their values to the
> appropriate fields.
> Cut and paste the rectangle into the row group cell on the matrix and
> Bingo! it should work.
> The downside to this method is it can be quite fiddly to get the
> formatting just right but you can do it.
> To try and explain it graphically, the structure of your matrix should
> be something like this.
>
> +--Matrix--+--+
> | | |
> +--+--+
> |+==Rectangle=========+| |
> ||+--Textbox1--+|| |
> ||| ||| |
> ||+--+|| |
> ||+--Textbox2--+|| |
> ||| ||| |
> ||+--+|| |
> |+====================+| |
> +--+--+
> Chris
>
> CCP wrote:
> > Thanks chris for ur reply...
> > When i add a row like that..its repeating column wise i want it to
> > repeat row wise...
> >
> > Thanks,
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > Right click the data cell and do 'Add Row'.
> > > You are effectively creating two rows per record.
> > >
> > > Chris
> > >
> > >
> > >
> > > CCP wrote:
> > >
> > > > HI,
> > > > Is it possible to have row grouping for each row in a matrix'
> > > >
> > > > Something like
> > > >
> > > > header1 header2
> > > > Task1
> > > > Section1
> > > > Row1 value1 value1
> > > > Section2
> > > > Row2 value2 value2
> > > > Task2
> > > > Section1
> > > > Row1 value1 value1
> > > >
> > > > When i use a matrix grouping it is producing the result as
> > > > Task1 Section1 Row1 value1 value1
> > > > Section2 Row2 value2 value2
> > > > Task2 Section1 Row1 value1 value1
> > > >
> > > > What i need to get the similiar look and feel as the previous
> > > > one.... I could get this design with a table grouping but the
> > > > columns are populated dynamically... which is not possible in a
> > > > table so im shifting to a matrix...
> > > >
> > > >
> > > > Your help is highly appreciated...
> > > >
> > > > Thanks,
> > >
> > >
>