round ( ([Actual Time Spent - Bank - YTD]/[Case Count - Bank - YTD] / 24), 2)
Tabular data is coming fine, but when i run the full report it is getting hang.
Actual data was 156.105 and data shown to be 156.11 .
Appreciate if some one can help me here.
Small change:
I'm able to get data in list report, issue with chart. Any clues please
Quotethe full report it is getting hang
Not quite sure what that means...
I really cannot tell what the "getting hang" is about, either. Especially when you seem to be saying it works in a list, but not in a graph - same query?
Also, the round function is doing what it is supposed to do. The expression round(156.105, 2) will return 156.11 so not sure what if any complaint you have there.
Hi Both, Thanks for your reply.
I mean to say when i ran tabular data, report is giving me data.
And from report studio if i add rounding in list report, report is generating as expected.
But, When i add same query to the chart report and run the report , report is not displaying......it is getting hand and when i refresh i see blank white page.
Regards,
Sai