CrossTab Report Help Required.

Hi All,

I need help regarding cross tab reports. I want a report something like this

_______________________________________________________
Users | APP1 | APP2 | APP3 | APP4 ...
_______________________________________________________
user1 | Active | Active| Inactive| Active...
user2 | Active | Active| Active | Active...
user3 | InActive | Active| Inactive| Active...
..
.
.

Here APP1, App2, App3 are different columns coming from DB. user 1,user2 etc are also rows coming from db.

Now i got the APP1,APP2 dynamically as well as user1,user2. but how to get the status against the application. It only allows to drop aggregate columns in summarize data field. Please help.

Find more posts tagged with

Comments

Hi zkhalid,

If you change the function from "SUM" to "FIRST" on the summary field in your dataCube, you should be able to pass the single string of "Active" or "Inactive".

Hope this helps.

Thanks a lot dude. quick reply man.

Got the above example working thanks to your help. Now a change in requirement. Now need grouping on a column. Got it working without crosstab as option of insert group helped. But in crosstab "data field" I cannot insert a group.

_______________________________________________________
Users | APP1 | APP2 | APP3 | APP4 ...
_______________________________________________________
Category1
user1 | Active | Active| Inactive| Active...
user2 | Active | Active| Active | Active...
user3 | InActive | Active| Inactive| Active...

Category2
user12 | Active | Active| Inactive| Active...
user4 | Active | Active| Active | Active...
user5 | InActive | Active| Inactive| Active...

zkhalid,

If I'm understanding correctly, if you create a table grouped by "category" and put the crosstab in the group header or footer, you can filter the crosstab based on the outer tables group value. Let me know.