Friday, March 9, 2012

Matrix column titles problem

Hi,
I hope anyone can help me with a problem I've been struggeling with for some
days now?
I have a matrix that should look like this. It has a couple of static
columns at the beginning and variable ones (week numbers) at the end
-----
ID Description ...(More columns)... 200523 200524 20052
-----
abc some description 3
3 4
def something else 7
8 8
etc...
But I only get this:
-----
200523 200524 20052
-----
abc some description 3
3 4
def something else 7
8 8
etc...
So the problem is that I cannot get the titles for the first columns, only
the generated ones for the weeknumbers at the end. The matrix control has
only one text field above all other columns. Obviously I want to show Part
ID, Description, etc... there.
I also want these column names to be visible when this report gets exported
to a csv file.
Does anyone know how to do these two things?
I would really appreciate your help.
Thanks,
EdgarMultiple static columns in a matrix are a bit of an issue.
I think, from your post, you are adding the columns into the main data
area which is why you are getting unexpected results.
You can only get one static column per row grouping as it stands.
However there is a hack!
Create a rectangle outside the matrix, add all the textboxes you want
as static columns into the rectangle, now cut and paste the rectangle
into the row cell in the matrix. The matrix sees it as one column which
keeps it happy, but renders it as you formatted it, which should keep
you happy!
Chris
Edgar wrote:
> Hi,
> I hope anyone can help me with a problem I've been struggeling with
> for some days now?
> I have a matrix that should look like this. It has a couple of static
> columns at the beginning and variable ones (week numbers) at the end:
> ---
> -- ID Description ...(More columns)...
> 200523 200524 200526
> ---
> -- abc some description
> 3 3 4 def something else
> 7 8 8
> etc...
>
> But I only get this:
> ---
> --
> 200523 200524 200526
> ---
> -- abc some description
> 3 3 4
> def something else 7
> 8 8
> etc...
> So the problem is that I cannot get the titles for the first columns,
> only the generated ones for the weeknumbers at the end. The matrix
> control has only one text field above all other columns. Obviously I
> want to show Part ID, Description, etc... there.
> I also want these column names to be visible when this report gets
> exported to a csv file.
> Does anyone know how to do these two things?
> I would really appreciate your help.
> Thanks,
> Edgar

No comments:

Post a Comment