Need help with a Crosstab (columns are a field)

[albert.gil]

Hello all!

I'm having a problem when developing a crosstab. I have to make a crosstab. Rows should be the Test Sample ID (keyid1) from my sql query. Columns should the a column called “paramid” on the database. There are multiple paramid's. And the data on the table should be a column called “enteredtext” on the database. 

So, this is the result on my query:

And this is the crosstab I designed:

And this is the crosstab I'm getting on my report:

As you can see, instead of adding a new column for each "paramid" he gets from the sql query, he just draws a new table. I'd need my crosstab to add a new column for each paramid, in order to see all the data in just one crosstab.

Could anyone explain me how to achieve that?

 

Thanks in advance for your help, and sorry if my english isn't perfect! :)

[james.t]

To start with you want to remove the red lines and warning symbol that have appeared in the crosstab design. What is happening is that the $V{} elements you have do not fit in their container.

To do this you need to 

1. From your main report view, double click on the crosstab.This will then take you into the crosstab for editing.

2. From the Outline view, highlight the columns in the Column Groups and then extend them to be the same size as your $V{} elements. Or right-click on the $V{} elements and select Size To Container -> Fit Both

[alba.ortega]

Hi Albert,

I developed many crosstabs, I hope my screenshoot could help you configuring yours. See below:

 

Kr,