CAlculate debits and credit total in ssrs report

• LutzM

  SSC Guru

  Points: 107049

  More actions

  September 9, 2010 at 9:24 am

  #1218717

  dbowlin (9/9/2010)

  ---

  Apologies. I have had similar problems, I should have thought of this before my answer.

  Usually when I run into this, I have to go back to the SQL in the dataset. You could try one change to see if it helps, but other than that I have no further suggestions. You could try to add a scoping statement to your sum formula.

  =Sum(ReportItems!txtCredits.Value)

  --changes to

  =Sum(ReportItems!txtCredits.Value,"ScopeOftxtCreditsField")

  I am not sure what the proper scope would be in your case. It is frequently a group name, possibly the name of the tablix/table.

  Good luck.

  Which is eaxactly what I recommended to do in the first place 😉

  ---

  
  Lutz
  A pessimist is an optimist with experience.

  How to get fast answers to your question[/url]
  How to post performance related questions[/url]
  Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

• anuhya.mudumba

  SSC Eights!

  Points: 928

  More actions

  September 13, 2010 at 11:18 pm

  #1220446

  Thanks All...for your replies..

  I was unable to resolve this from SSRS..took help from SQL.Since there is no other go and time was running away , i had to convince everyone to use Sql...

  I added 2 columns to the dataset to get the sum...and called those columns in the textboxes.

  Thanks to dbowlin and lutz for your replies..

  With Regards,
  Anu..;-):hehe: