views:

66

answers:

0

I'm not sure if the title properly explains what I'm trying to do. I'm trying to move from using SQL Reporting Services to a Crystal Reports Web App. I've gotten some reports to design properly because they are simple cross-tab reports that require nothing special. I'm running into a little problem of a user matrix report. Here's how the report looks on SQL Reporting Services:

                              group1 group2 group3
username1 first1 last1 title1 X             X
username2 first2 last2 title2 X      X
                              2      1      1

Normally in VS2008 with a SQL rdl, I would right click on the row and Insert Column. However, i don't see a way to do this in Crystal Reports. I've tried setting up multiple row groups, but that adds mutliple groupings like:

                          group1
Total                     ...
Username Total            ...
         first Total      ...
               last       ...