7 Replies Latest reply: Apr 7, 2011 3:50 PM by Debi Herbert RSS

Add Column to Cross-tab in Crystal Report

soeun tony
Currently Being Moderated

Hi all visitors

I have created one report by using Cross-Tab.

in my query, i have 3 columns(hour,floor,amount)

In my design, i add columns hour in Row,Floor in Col and amount in summarized field in Cross-tab.

Then the result will show like this.

_________________________Floor1___________Floor2____________Floor3___________Total

 

9-10_____________________4534_____________0________________0______________4534

11-12______________________0______________345________________0____________345

Total_____________________4534_____________345______________0_______________4879

but now my manager want me to update the report to add one more columns in cross-tab

the report update should show like this.

_________________________Floor1___________Floor2____________Floor3___________Total_______Ratio

 

9-10_____________________4534_____________0________________0______________4534_______70%

11-12______________________0______________345________________0____________345________30%

Total_____________________4534_____________345______________0_______________4879_______100%

To show the report like the report update, How can i do that?

Best Regards,

Actions