Can you clarify your question a little more. Are you looking for a running total, the total for the row, or the column total. You did say supplier total, are...

This was done in SSRS 2005 and I was able to get it working only locally. I didn't realize it was not working once you deploy it. I have not...

It is not possible to stop the call to db after you run the report. The possible work around could be, in you dataset you can check the value of...

sorry guys if it did not work for you. I will have to get back to you guys at a later date after I get a chance to look at...

I got your email.. that is something I have worked on. My explanation would still stick along the line I mentioned earlier. If it was not clear, let me go...

I believe your XML is being rendered as an HTML out here.. I will send you my email address.. Just email me your rdl as an attachment. I will try...

In your solution explorer, right click your rdl and click the view code. That will give you the XML version of your rdl. Copy paste that in here.. I will...

So the Categories A, B and C are the actual data or the field name? If they are the actual data, the solution I proposed earlier should work.. well it...

What is your table structure like?

Are X and Y the column of the same table?

Can you may be re-state what are the columns of your table and what is the...

Try something like this.

For your ColumnX, change the visibility expression to:

= IIF((ReportItems!txtBoxClmnX.Value = "A") OR (ReportItems!txtBoxClmnX.Value = "B") OR (ReportItems!txtBoxClmnX.Value = "C"), False, True)

Here txtBoxClmnX...

if ( Sum (IIF(IsNothing(Fields1.Value), 0, Fields1.Value)), Field3.value) = 0 ) then

0

else

(Sum (IIF(IsNothing(Fields2.Value), 0, Fields2.Value), Field3.value) / Sum (IIF(IsNothing(Fields1.Value), 0, Fields1.Value), Field3.value)

i am struck in between, Can anybody please tell me...

Yup I see what you are saying. It is a PL SQL that I am using.. very similar to T-SQL ; I will definitely look at the way you suggested....

Thanks Jack but I got an error running the statement. This is the error statement I got..

...

What did you mean by "The dates do not necessarily reflect when a change in address was made so you could have rows and rows where the same address is...

Thank you again Jack. I would love to have you look at my rdl but I am not sure about the policy so let me try to lay out the...