Showing posts with label display. Show all posts
Showing posts with label display. Show all posts

Wednesday, March 21, 2012

Front end display of two fields

I am doing a report which needs to display a field like

totals/percentages...

the actual data values is something like this

=(Sum(Fields!B.Value))& " / " &

(Sum(Fields!B.Value))/(sum(Fields!A.Value) + sum(Fields!B.Value)+sum(Fields!C.Value)+sum(Fields!D.Value)+sum(Fields!E.Value)+sum(Fields!F.Value))

*100

the problem is sum (fields!B.value) is an integer (sum of students) like 32

and the aggregate value in the denominator is a percentage value (0.014343443%)

I need to approximate the value to 0.014

something like this

totals/percentages... .......32/0,014 instead of 32 / 0.014343443 in the front end of the report properties

Please help

Thanks

Wouldn't math.Round() do the trick? You just want to round the decimal to three decimal places....Right?|||

="32" & " / " & round(0.014343443, 3)

Friday, March 9, 2012

freeze display in Perfmon ?

Is the freeze display in Perfmon similar to pausing or stopping and starting
again. Are there any performance issues to freezing the display or should i
close the perfmon if i dont need to.
I have some counters that i would like to store and be able to run perfmon
any time with these set of counters rather than adding them every time i
open perfmon How can i do so ?Hassan
Use this link to see lots of tips for using perfmon
including how to store settings.
http://www.sql-server-
performance.com/performance_monitor_tips.asp
Hope this helps
John