Need a group total for an expression result NOT from the elements value
Simple question and still new to SSRS 2005. Did a bit of Crystal reports before. I have created a bit of code that returns a 0 or a 1 in a column based on a text evaluation as I could not get IIF to behave for me. But either way the textbox displays the 0 or the 1 if the result is true. I want to sum up the results, but I cannot seem to find the proper name for the text box to use in a =sum(textbox38) sort of statement. So I have a couple columns like this talked to customer estimate given 1 0 talked to customer estimate accepted 0 1 I need to count up those 0 and 1s in the footer so I know how many estimates went out and how many were accepted Thanks Alan
October 28th, 2010 3:53pm
Hi Alan, You can try something like: =SUM(IIF(Fields!MyAmount.Value > 25, 1, 0)) HTH, Igor
October 28th, 2010 4:49pm
Thank you, that seems to not blow up the report on the line line I have set up to test with now. What can I do with the sum to bring that into the footer or the header of the group now? I want to have two cells in the header that tell me the quantity of each event? Thanks Alan
October 28th, 2010 10:58pm
Alan, Use that exact expression in the footer or header. Igor -Remember to mark as an answer if this post has helped you.
October 29th, 2010 12:00pm
I appreciate the help, must have had my tongue hanging the wrong way that afternoon. I was able to get everything to work a couple days later with the help in this thread. Onto bigger and tougher problems now.
November 19th, 2010 7:50pm