Hi
This is what you do
Create the below formulas
Frm_outage_Mins
Minute({probsummarym1.outage.dur})
Frm_delayed_Mins
Minute({probsummarym1.delayed.dur})
Then Insert Summary,in that Field to summarize select the Frm_outage_Mins type of summary sum and insert in report footer this will give you sum for outage minutes.
Repeat the same steps for delayed minutes
This will give you total minutes for outage and delayed, then create a final formula to add the output of the above formulas.
Frm_Total_Mins
{@Frm_delayed_Mins}+{@Frm_Outage_Mins}
this will give you total minutes.
Then Insert Chart in report header ,then in data tab select for all records.
Show Values
Move the Frm_Total_Mins formula
Click Ok
Ans2) for exporting to excel depends what expoting options you are using you will need to read guidelines in crystal help......
Cheers
Rahul
Edited by rahulwalawalkar - 27 Feb 2009 at 2:37am
IP Logged
