Print Page | Close Window

Percentage time on bar graph in Crystal Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10060
Printed Date: 15 May 2024 at 9:51pm


Topic: Percentage time on bar graph in Crystal Report
Posted By: info12suchi
Subject: Percentage time on bar graph in Crystal Report
Date Posted: 19 May 2010 at 7:28am

Hi Experts,

ing to Chart/graph the data.

 

The co-orduinates of the graph are as below.


Vw_rp_job_status.CARD_TYPE on X-axis
And the Percentage of the work completion on Y-axis.

Here is the formula for the Percentage_work_Completed.
 
numbervar WIP_Cards := (Sum ({@QA Final}, {Vw_rp_job_status.CARD_TYPE})+
Sum ({@Work Complete}, {Vw_rp_job_status.CARD_TYPE})+
Sum ({@Audit Comp}, {Vw_rp_job_status.CARD_TYPE}));

numbervar Total_Cards := WIP_Cards + Sum ({@Open}, {Vw_rp_job_status.CARD_TYPE});

 WIP_Cards%Total_Cards


But When I am trying to right click on the chart and modify the SHOW in the DATA tab. It is not showing the Percentage formula in the drop  down.

Please help me on this.

 


Print Page | Close Window