Dynamic Row group in matrix

Hi All !

I want to show row groups as hierarchy levels and need the

sub total values belongs to each group and sub group levels. But the

most important point is that my top next top group (from child to

parent ) is not static its dynamic.i.e for a diffrent senario my under

displayed example can have Universe>Earth as parent for Australia and USA.

eg:

1.Australia

|-sydney

|-Melbourne

2.USA

|North US

|North US(1)

|North US(2)

|South US

|South US(1)

|South US(2)

Can I get some help from anybody for making a dynamic row groups in the matrix.

Waiting for a kind help.

Regards,

This is the Dynamic Group I used. I am not the original author, I search on dynamic grouping for SSRS and modified the example showed.

Put this is group expression:

=iif(Parameters!Group_By.Value is Nothing,Fields!SomeField.Value , Fields(iif(Parameters!Group_By.Value is Nothing, "DefaultID",Parameters!Group_By.Value)).Value)

|||Look at this blog entry from Chris Hayes http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx|||thanx for ur help.
I have done this with some other logic.

Dynamic Row group in matrix

Hi All !
I want to show row groups as hierarchy levels and need the sub total values belongs to each group and sub group levels. But the most important point is that my top next top group (from child to parent ) is not static its dynamic.i.e for a diffrent senario my under displayed example can have Universe>Earth as parent for Australia and USA.
eg:
1.Australia
|-sydney
|-Melbourne
2.USA
|North US
|North US(1)
|North US(2)
|South US
|South US(1)
|South US(2)
Can I get some help from anybody for making a dynamic row groups in the matrix.
Waiting for a kind help.
Regards,

This is the Dynamic Group I used. I am not the original author, I search on dynamic grouping for SSRS and modified the example showed.

Put this is group expression:

=iif(Parameters!Group_By.Value is Nothing,Fields!SomeField.Value , Fields(iif(Parameters!Group_By.Value is Nothing, "DefaultID",Parameters!Group_By.Value)).Value)

|||Look at this blog entry from Chris Hayes http://blogs.msdn.com/chrishays/archive/2004/07/15/DynamicGrouping.aspx|||thanx for ur help.
I have done this with some other logic.sql

Dynamic Row Group in a matrix

Hi All !

I want to show row groups as hierarchy levels and need the

sub total values belongs to each group and sub group levels. But the

most important point is that my top next top group (from child to

parent ) is not static its dynamic.i.e for a diffrent senario my under

displayed example can have Universe>Earth as parent for Australia and USA.

eg:

1.Australia

|-sydney

|-Melbourne

2.USA

|North US

|North US(1)

|North US(2)

|South US

|South US(1)

|South US(2)

Can I get some help from anybody for making a dynamic row groups in the matrix.

Waiting for a kind help.

Regards,

Hi Sanjib,

Check this link.It will be helpful.

|||

Hi Dear !

Thanx for reply me , but i'm sorry to say that there is no link mentioned.

Plz mention the link.

waiting for u'r reply,

Dynamic merging cells in Matrix

I have a matrix like this,

October

W1

W2

W3

W4

W5

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

michelle

Jack

cindy

1 1 1

Nina

Lucia

I need it to be like this:

October

W1

W2

W3

W4

W5

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

michelle

Jack

cindy

1

Nina

Lucia

The problem is: how to group (merge) those 3 cells. Because this a matrix, the columns are generated by a dataset, so this should be related to something like "dynamic merging cells". I think this not about adding a row group or column group. You can see I have used row groups in the week row and month row.

I wonder if somebody has any idea how to support this. If not, is there any other alternatives, as long as they can produce this result.

I am using SQL Server Reporting Services 2000 SP2

Thank you VERY MUCH!

Nobody has any idea? Or I didn't put something clear?

I need helps.

Dynamic merging cells in Matrix

I have a matrix like this,

October

W1

W2

W3

W4

W5

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

michelle

Jack

cindy

1 1 1

Nina

Lucia

I need it to be like this:

October

W1

W2

W3

W4

W5

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

W

T

F

S

S

M

T

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

michelle

Jack

cindy

1

Nina

Lucia

The problem is: how to group (merge) those 3 cells. Because this a matrix, the columns are generated by a dataset, so this should be related to something like "dynamic merging cells". I think this not about adding a row group or column group. You can see I have used row groups in the week row and month row.

I wonder if somebody has any idea how to support this. If not, is there any other alternatives, as long as they can produce this result.

I am using SQL Server Reporting Services 2000 SP2

Thank you VERY MUCH!

Nobody has any idea? Or I didn't put something clear?

I need helps.

dynamic matrix reports

Hello,
Is it possible to create a report which allows users to select the
fields
for the matrix in a report. To explain in detail, can we allow the
users to
select the X and Y axis for a matrix in a report?
For ex., there is a report containing a matrix which shows the total
sales(
data cell) by month (X axis) and by Rep( Y axis). Can we have some
option
so that if the users select Year as the X axis and Company as the Y
axis
then they can view the same report but by company and Year instead of
Month and Rep?
Regards
Jaideepcertainly.
Just use a switch statement or iif statement for the values for the row
and column groups:
switch(parameters!group.value = 'x', fields!month.value,
parameters!group.value = 'y', fields!year.value)
or
iif(parameters!group.value = 'x', fields!month.value,
fields!year.value)
jai wrote:
> Hello,
> Is it possible to create a report which allows users to select the
> fields
> for the matrix in a report. To explain in detail, can we allow the
> users to
> select the X and Y axis for a matrix in a report?
>
> For ex., there is a report containing a matrix which shows the total
> sales(
> data cell) by month (X axis) and by Rep( Y axis). Can we have some
> option
> so that if the users select Year as the X axis and Company as the Y
> axis
> then they can view the same report but by company and Year instead of
> Month and Rep?
>
> Regards
> Jaideep

Dynamic field base on parameter

Hi,

I have a matrix based on a cube. I would like to load up a field based on the selection of a parameter.

The parameter values has, Actual, Budget, Target

For the one field, base on the above parameter, will select,

if the value for the parameter is Actual, then =Fields!Actual.Value

if it's Budget, then =Fields!Budget.Value

if it's Target, then =Fields!Target.Value

Is this possible? And If so, how should I do it?

Thanks a lot.

You can try

=IIF(Parameters!<ParamName>.Value="Actual", Fields!Actual.Value, IIF(Parameters!<ParamName>.Value="Budget", Fields!Budget.Value, Fields!Target.Value))

|||

hi,

thanks a lot for your reply.

But what if I loaded the parameter list from the database, that means there maybe more option later in the course, what can I do in that case?

|||You can try using this syntax =Fields(Parameters!<paramName>.Value).Value.|||thanks a lot for your great help... that works!

Dynamic Dates in Columns on Matrix Report?

I need to display 12 months dynamically in columns of a matrix report, starting with the current MMM, yy - 3 in the first column, current MMM, yy and incrementing by 1 month in columns 2-12.

For example a report that would run on today's MM, yy (5/2007) would look something like this:

MAR-07, APR-07, MAY-07, JUN-07, JUL-07, AUG-07, AUG-07, SEP-07, OCT-07, NOV-07, DEC-07, JAN-08, FEB-08

(Col 1 - Col 12 separated by commas)

How do I do this in a matrix report column?

1- Filter your datasource to return only those rows that meet the date criteria you describe

If SQL Server...

Code Snippet

Select Item, SalesDate, Sales from YourTable Where SalesDate >= DateAdd(dd, -3, GetDate()) AND SalesDate <= DateAdd(dd, 9, GetDate())

For example:

Item Date Sales

Bicycle Mar-07 $5000

Bicycle Apr-07 $4500

etc...

Then set your date column as the Column Group in the matrix report

Then select that column header in SSRS Layout view, and change the format property to the MMM-yy

(If the granularity of the dates in your source data is not month, if it's by day instead for instance, then you'll need to aggregate that data in your query with the appropriate Group By calls)

Hope this helps,

Geof

Dynamic Dates in Columns on Matrix Report

I need to display 12 months dynamically in columns of a matrix report, starting with the current MMM, yy - 3 in the first column, current MMM, yy and incrementing by 1 month in columns 2-12.

For example a report that would run on today's MM, yy (5/2007) would look something like this:

MAR-07, APR-07, MAY-07, JUN-07, JUL-07, AUG-07, AUG-07, SEP-07, OCT-07, NOV-07, DEC-07, JAN-08, FEB-08

(Col 1 - Col 12 separated by commas)

How do I do this in a matrix report column?

I would do this by created an enumerated type for months and then iterate through them based on current month value(5). when you reach 12(or 13 depending on starting value) then reset to 0 or 1 respectively and increase the year by one.

Eric

|||

I'm still not sure how to actually do this. Can you send me an example of how to do this?

|||

Can you post your code please so I understand what you need.

|||

I ended up declaring a begindate and enddate, based on the current month in the stored procedure and passed that in.

Dynamic Data sets in reports

Hi,

I'm using a matrix report where in i want to use two datasets in the same report. How can i make the dataset dynamic for a single report.

Regards

Can the two datasets be accessed from the same datasource/connection?

Can they be made to "express themselves" using exactly the same column names ?

>L<

Dynamic columns of matrix

I have a matrix, I would like to have a subtotal and total that only
performs the action if the dynamic collumn has a particular value.
I have dynamic column A and B. I only want the subtotal for A not B.
BruceOn Mar 6, 12:31 pm, "Bruce L-C [MVP]" <bruc...@.newsgroup.nospam>
wrote:
> I have a matrix, I would like to have a subtotal and total that only
> performs the action if the dynamic collumn has a particular value.
> I have dynamic column A and B. I only want the subtotal for A not B.
> Bruce
I would suggest using a loop or cursor in the stored procedure or
report query sourcing the report to determine the subtotals and total.
Then in the report use a conditional expression to check for a
particular column value and if it is not the one that needs the
subtotal and total, substitute an empty value for the subtotal and
total. Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer

dynamic columns in matrix

hi all,

i m using ssrs 2005. i want to generate a report which displays data according to the dataset returned.Now this dataset can return any number of columns.

does matrix use helps out in this case..

if anyone can really explain me on it or can even point to certain articles in this regard,that wudd be wonderful

thanks a ton...

hi all
m quite new to reporting services so may b it sounds easy for u champs but still ur replies wudd b appreciated..

thanks a ton ...

|||Hi,hilander:
Try to do this.
1. Convert your RDL files in RLDC files (see this topic at VS2005 help).
2. Configure your ReportViewer to a LocalReport mode. This will allow you to
link yourdataset to a report at runtime by using ReportViewer.LocalReport methods or at disign level too.

Hopefully I help you.

|||

Hi,hilander:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

dynamic column population?

Hello I'm new to reporting services (2000)
How do I dynamically populate a matrix column (or table) using the
parameters entered by users?
Example: A user enters a date range to filter the dataset. Parameters are
Start Date and End Date.
Then I want to be able to display in the report all the days between start
date and end date in the columns so that the
Table headers contain all the days/dates between start date and end date.
Start: 1/1/2006
End: 1/7/2006
--Col1: 1/1--Col2: 1/2--Col3: 1/3--Col4:
1/4--Col5:1/5--Col6: 1/6--Col7: 1/7
Row1
Row2
Row3
..how is this implemented in reporting services? is this possible?hey man,
right click on the 1st column header and select [expression] then you will
have to type something like:
=Parameters!startdate.Value
for the other columns you have to add 1 or 2 or 3 to the [days] part of the
parameter... then for the last column right click and select [expression]
then type:
=Parameters!enddate.Value
peace out...
"Abi" wrote:
> Hello I'm new to reporting services (2000)
> How do I dynamically populate a matrix column (or table) using the
> parameters entered by users?
> Example: A user enters a date range to filter the dataset. Parameters are
> Start Date and End Date.
> Then I want to be able to display in the report all the days between start
> date and end date in the columns so that the
> Table headers contain all the days/dates between start date and end date.
> Start: 1/1/2006
> End: 1/7/2006
>
> --Col1: 1/1--Col2: 1/2--Col3: 1/3--Col4:
> 1/4--Col5:1/5--Col6: 1/6--Col7: 1/7
> Row1
> Row2
> Row3
> ..how is this implemented in reporting services? is this possible?
>
>

Dynamic Column - Total - Using Matrix - Help Neede!

Hi All,
I have a report with Dynamic Column - achieved using Matrix
The Output is something like this
Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
AA 100 10 20
30
BB 200 20 15
30
CC 300 10 10
10
I need the total of static and dynmaic column for each column individually
Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
AA 100 10 20
30
BB 200 20 15
30
CC 300 10 10
10
Total 500 40
45 70
For static Column I can say (=Sum(Field!Static-Col1.Value), but how can I
display the total for dynamic columns
Thanks
Balaji
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1BALAJI K wrote:
>Hi All,
>I have a report with Dynamic Column - achieved using Matrix
>The Output is something like this
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20
>30
>BB 200 20 15
>30
>CC 300 10 10
>10
>I need the total of static and dynmaic column for each column individually
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20
>30
>BB 200 20 15
>30
>CC 300 10 10
>10
>Total 500 40
>45 70
>For static Column I can say (=Sum(Field!Static-Col1.Value), but how can I
>display the total for dynamic columns
>Thanks
>Balaji
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1|||BALAJI K wrote:
>Hi All,
>I have a report with Dynamic Column - achieved using Matrix
>The Output is something like this
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20
>30
>BB 200 20 15
>30
>CC 300 10 10
>10
>I need the total of static and dynmaic column for each column individually
> Static-Col1 Dynamic-Col1 Dyn-Col2 Dyn-Col3
>AA 100 10 20 30
>BB 200 20 15 30
>CC 300 10 10 10
>Total 500 40 45 70
>For static Column I can say (=Sum(Field!Static-Col1.Value), but how can I
>display the total for dynamic columns
>Thanks
>Balaji
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200510/1

Dynamic change of the column size and location of a matrix

I have a report that has a matrix. That matrix can have from 2 to 16 columns dependinging on the dataset result. Right now I am forced to place this matrix on the left side of the report and make a column layout pretty narrow. When dataset has more than 13 or so columns it looks OK, but when dataset has only two or three columns it looks weird with a matrix sitting in the left corner with two or three narrow columns and a lot of empty space to the right.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

Thank you,

Simon.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

No

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

No

Curently, the RS object model doesn't support manupaluting the report definition at runtime. Please take a moment to put these on the wish list for a future release on connect.microsoft.com

|||Is the feature available yet or is it still a no go. I really need to be able to change the width of columns and the height of textboxes dynamically. Has anyone been able to acomplish this?
|||

No go, as far as I know.

:-(

|||

The only way to do this that I know of is to re-write the RDL dynamically at run time with the specifications that you need for this run. Does this help at all? There are probably only a couple of changes that you would need to make in your case.

>L<

|||Yeah that's what I have done. When the user selects the report from my web app, I load the rdl file, make the necessary changes to the xml, re-deploy the report and then generate it. A bit of a pain but unfortunately the only work around at the moment.
|||

Hi Mark,

One can imagine that something similar would be necessary if dynamic width were built into the product.

Unfortunately it would pretty much take the same work *and* -- this is the kicker that may have taken it off the Katmai table for all we know -- it might be very difficult to get it right for every type of scenario that people might want to use it in.

I think it would be a great idea for Katmai or some future version to provide a hook that allowed a "swap event" during the report rendering process (there's a reason I call it that, although I know it sounds odd <s>).

The basic idea here is that the kinds of work we need to do at this point in the process would still be up to us, the product wouldn't do the work of adjusting the RDL, but it would offer a safe and consistent point at which to do that work. It would maybe hand the RDL as a stream or a loaded DOM object, we could make whatever adjustments we wanted, and then it would continue on its way.

Would you agree that this would provide some benefit, or do you see it as not sufficiently "automagical"?

>L<

|||I think that any improvement in this area would be beneficial however I would prefer for the process to be a bit more "automagical" as you put it.

Dynamic change of the column size and location of a matrix

I have a report that has a matrix. That matrix can have from 2 to 16 columns dependinging on the dataset result. Right now I am forced to place this matrix on the left side of the report and make a column layout pretty narrow. When dataset has more than 13 or so columns it looks OK, but when dataset has only two or three columns it looks weird with a matrix sitting in the left corner with two or three narrow columns and a lot of empty space to the right.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

Thank you,

Simon.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

No

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

No

Curently, the RS object model doesn't support manupaluting the report definition at runtime. Please take a moment to put these on the wish list for a future release on connect.microsoft.com

|||Is the feature available yet or is it still a no go. I really need to be able to change the width of columns and the height of textboxes dynamically. Has anyone been able to acomplish this?
|||

No go, as far as I know.

:-(

|||

The only way to do this that I know of is to re-write the RDL dynamically at run time with the specifications that you need for this run. Does this help at all? There are probably only a couple of changes that you would need to make in your case.

>L<

|||Yeah that's what I have done. When the user selects the report from my web app, I load the rdl file, make the necessary changes to the xml, re-deploy the report and then generate it. A bit of a pain but unfortunately the only work around at the moment.
|||

Hi Mark,

One can imagine that something similar would be necessary if dynamic width were built into the product.

Unfortunately it would pretty much take the same work *and* -- this is the kicker that may have taken it off the Katmai table for all we know -- it might be very difficult to get it right for every type of scenario that people might want to use it in.

I think it would be a great idea for Katmai or some future version to provide a hook that allowed a "swap event" during the report rendering process (there's a reason I call it that, although I know it sounds odd <s>).

The basic idea here is that the kinds of work we need to do at this point in the process would still be up to us, the product wouldn't do the work of adjusting the RDL, but it would offer a safe and consistent point at which to do that work. It would maybe hand the RDL as a stream or a loaded DOM object, we could make whatever adjustments we wanted, and then it would continue on its way.

Would you agree that this would provide some benefit, or do you see it as not sufficiently "automagical"?

>L<

|||I think that any improvement in this area would be beneficial however I would prefer for the process to be a bit more "automagical" as you put it.

Dynamic change of the column size and location of a matrix

I have a report that has a matrix. That matrix can have from 2 to 16 columns dependinging on the dataset result. Right now I am forced to place this matrix on the left side of the report and make a column layout pretty narrow. When dataset has more than 13 or so columns it looks OK, but when dataset has only two or three columns it looks weird with a matrix sitting in the left corner with two or three narrow columns and a lot of empty space to the right.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

Thank you,

Simon.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

No

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

No

Curently, the RS object model doesn't support manupaluting the report definition at runtime. Please take a moment to put these on the wish list for a future release on connect.microsoft.com

|||Is the feature available yet or is it still a no go. I really need to be able to change the width of columns and the height of textboxes dynamically. Has anyone been able to acomplish this?
|||

No go, as far as I know.

:-(

|||

The only way to do this that I know of is to re-write the RDL dynamically at run time with the specifications that you need for this run. Does this help at all? There are probably only a couple of changes that you would need to make in your case.

>L<

|||Yeah that's what I have done. When the user selects the report from my web app, I load the rdl file, make the necessary changes to the xml, re-deploy the report and then generate it. A bit of a pain but unfortunately the only work around at the moment.
|||

Hi Mark,

One can imagine that something similar would be necessary if dynamic width were built into the product.

Unfortunately it would pretty much take the same work *and* -- this is the kicker that may have taken it off the Katmai table for all we know -- it might be very difficult to get it right for every type of scenario that people might want to use it in.

I think it would be a great idea for Katmai or some future version to provide a hook that allowed a "swap event" during the report rendering process (there's a reason I call it that, although I know it sounds odd <s>).

The basic idea here is that the kinds of work we need to do at this point in the process would still be up to us, the product wouldn't do the work of adjusting the RDL, but it would offer a safe and consistent point at which to do that work. It would maybe hand the RDL as a stream or a loaded DOM object, we could make whatever adjustments we wanted, and then it would continue on its way.

Would you agree that this would provide some benefit, or do you see it as not sufficiently "automagical"?

>L<

|||I think that any improvement in this area would be beneficial however I would prefer for the process to be a bit more "automagical" as you put it.

Dynamic change of the column size and location of a matrix

I have a report that has a matrix. That matrix can have from 2 to 16 columns dependinging on the dataset result. Right now I am forced to place this matrix on the left side of the report and make a column layout pretty narrow. When dataset has more than 13 or so columns it looks OK, but when dataset has only two or three columns it looks weird with a matrix sitting in the left corner with two or three narrow columns and a lot of empty space to the right.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

Thank you,

Simon.

Is it possible programmatically change the width of the columns depending on their number in the dataset?

No

Is it possible to move the location of the matrix (horizontally) depending on the number of columns in the dataset?

No

Curently, the RS object model doesn't support manupaluting the report definition at runtime. Please take a moment to put these on the wish list for a future release on connect.microsoft.com

|||Is the feature available yet or is it still a no go. I really need to be able to change the width of columns and the height of textboxes dynamically. Has anyone been able to acomplish this?
|||

No go, as far as I know.

:-(

|||

The only way to do this that I know of is to re-write the RDL dynamically at run time with the specifications that you need for this run. Does this help at all? There are probably only a couple of changes that you would need to make in your case.

>L<

|||Yeah that's what I have done. When the user selects the report from my web app, I load the rdl file, make the necessary changes to the xml, re-deploy the report and then generate it. A bit of a pain but unfortunately the only work around at the moment.
|||

Hi Mark,

One can imagine that something similar would be necessary if dynamic width were built into the product.

Unfortunately it would pretty much take the same work *and* -- this is the kicker that may have taken it off the Katmai table for all we know -- it might be very difficult to get it right for every type of scenario that people might want to use it in.

I think it would be a great idea for Katmai or some future version to provide a hook that allowed a "swap event" during the report rendering process (there's a reason I call it that, although I know it sounds odd <s>).

The basic idea here is that the kinds of work we need to do at this point in the process would still be up to us, the product wouldn't do the work of adjusting the RDL, but it would offer a safe and consistent point at which to do that work. It would maybe hand the RDL as a stream or a loaded DOM object, we could make whatever adjustments we wanted, and then it would continue on its way.

Would you agree that this would provide some benefit, or do you see it as not sufficiently "automagical"?

>L<

|||I think that any improvement in this area would be beneficial however I would prefer for the process to be a bit more "automagical" as you put it.|||

I had a similar requirement and after I read this thread it dawned on me!!! Why not copy the matrix or whatever object and duplicate it. One for each size and hide all but one. Then at run time show the one you want at the right size and position.

I know, not the best idea, but it's something.

|||

It's difficult to do that with the matrix because you don't have as much control over what is shown where... it works in some cases, but I end up using tables when I want to do stuff like this (where you can be less random about what is going to be in each column, you can write more targeted visibility instructions for each).

Unless you mean just have two matrices ? This only works if each column should get the same width within each case, not if they are mixed width.

>L<