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! :)