Wednesday, March 7, 2012

multiple columns problem

Hi everyone,

I have this problem...
Trying to make a report which should look like this..

USER1 USER2 role32
role11 role21 role33
role12 role22 USER4
role13 USER3 ...
role14 role31

(role1X belongs to user1, role2X belongs to user2, e.g.)

I have XML data like:
<report> <row><user>USER1</user>
<role>role11</role>
</row>
<row><user>USER1</user>
<role>role12</role>
</row>
...
In report I have grouping by user, and detail section set to multiple columns. But the report looks like this:

USER1 role11 role12 role13
USER2 role21 role22 USER3
role31 ...

Is there any posibily how to make the report look like I want to? There is no problem to change XML file and schema.

I'm using CR XI

Please help me...

Thanks
PeterReasd about Cross tab reports in help file

No comments:

Post a Comment