Hi,

i have a report with DQL (Documentum Query Language). I use cross-tab reports because i need count of cases of workflows those are started by different users.

_____|case x___|case y___|total |
user a|count x-a |count y-a |tot a  |
user b|count x-b |count y-b |tot b  |

In addition i need percentages of count to totals

_____|case x___|____perc_1___|case y___|____perc_2___|total |
user a|count x-a |count x-a/tot a |count y-a |count y-a/tot a |tot a  |
user b|count x-b |count x-b/tot b |count y-b |count y-b/tot b |tot b  |

DQL does not let me use a select statement as a table ( from (select...) t1) so my question is:

can i add new columns using functions or other abilities of Crystal Reports?


Edited by crystalreporter - 22 Sep 2011 at 10:52pm