Print Page | Close Window

New percentage column

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14431
Printed Date: 29 Apr 2024 at 1:42pm


Topic: New percentage column
Posted By: crystalreporter
Subject: New percentage column
Date Posted: 21 Sep 2011 at 4:39am
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?


Replies:
Posted By: lockwelle
Date Posted: 21 Sep 2011 at 8:13am
people use the Command Object to create tables for their reports.
 
CR won't let you add columns to the data, but you can link tables together which the command object would let you do.
 
If you could write a stored proc, well that is always my prefered method as it allows the most flexibility to the report writter.
 
HTH


Print Page | Close Window