June 17, 2010 at 3:23 pm
I have a report with several levels of drill down grouping. At each level, I have a column each for sum of cost and sum of items. Then I have a column that needs to be the sum of cost divided by the sum of items. If I include this calculation in the sql query I will end up with the sum of each individual cost/item instead of (sum cost)/(sum items). If I put the calculation in the report, it times out again and again. I'm pretty new to SSRS and am not sure what I can do. Any help would be greatly appreciated.
Here's what I currently have (I was originally using custom code for the divide by zero issue but thought that may be slowing things down even more):
Cost
=Sum(Fields!COST.Value)
Item
=Sum(Fields!ITEM.Value)
Division
=IIf(Sum(Fields!ITEM.Value) = 0, 0, Sum(Fields!COST.Value)) / IIf(Sum(Fields!ITEM.Value) = 0, 1, Sum(Fields!ITEM.Value))
June 29, 2010 at 9:27 am
From your description, it is unclear of what is source of your problem. It could be your sql query, or the groups/drilldowns in your report.
Try playing with the TimeOut field in the data set window.
If nothing works, consider posting back with some sample data and how your report should look like... i am sure some can help you out
July 2, 2010 at 4:40 am
Hi there
This is Jessica
I am new to here could anyone tell me about Internet Marketing
______________________________________________
"Want to get-on Google's first page in 48 hours and flood your site with traffic?
Try Traffic Geyser, the internet's #1 video marketing software at Traffic Geyser "
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply