January 7, 2015 at 4:13 pm
Hello all, I am unsure if this is the correct place or not, but if not please point me in the right direction.
I am working in Visual Studio 2010, I am making a report that is basically a scorecard report, so there are a lot of graphs and numbers pretty much.
However, I am trying to do a Sum IF expression. I can get it to work, but as soon as I add this expression into my report it takes the report about 3 minutes to render. When I take it out, the report only takes a couple seconds to render. If I take out the CDec(0) it runs faster also, BUT I get the #Error messages at that point.I am not sure what I am doing wrong, any help would be appreciated. I've tried a million things.
This is the expression I am using.
=SUM(IIF(Fields!DPDBckt.Value <> "NA" AND (Fields!DPDBckt.Value <> "0"), Fields!NetBal.Value, CDec(0)))
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply