Crystal Reports: Top 10 percentage

[sandrineL]

Hello,
I would like to have a report with Top 10 of a variable defined and accessible in a subgroup context but unavailable in the global report.
this is the variable formula for instance:

"if Sum ({@timespan}, {OPC_V_SERVICE_LOG.SERVICE_NAME}) = 0 Then 0
Else Sum ({@timespan}, {@severity_order}) / Sum ({@timespan}, {OPC_V_SERVICE_LOG.SERVICE_NAME}) * 100"

Thank you in advance.
Sandrine.

 

[lbass]

Please identify your CR version and also show the content of all nested formulas.

-LB

 

[sandrineL]

The CR version is XI.
The problem is not the formula. I tried with an other one: I just would like to use a variable which in a group and class top 10 in all the report with this varaible.

Thank you.
Sandrine.

 

[lbass]

I wasn't suggesting there was anything wrong with your formula, but for a solution, I need to understand how you are calculating this.

Please show the contents of the formulas for further help.

-LB

 

[AlexRezid]

Hi,
You can download the report from:

http://dl.free.fr/bnLlf1LeP/Cust_Av1_d.rpt

I would like to have top 10 of percentage.

Thank you.

 

[CR85user]

Hi Sandrine,

Please just provide the requested information.

LB is trying to help you solve the issue and by simply answering the questions i'm sure he will endeavour to do so.

If you are lazy in your approach to suppolying the requested information then don't be suprised if people are lacsidaisical in supplying the answer.

Note: You are welcome to replace any sensitive information with sample data which shows the same functionality if you have concerns in that area.

'J