September 9, 2010 at 9:24 am
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 😉
September 13, 2010 at 11:18 pm
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:
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply