Using expressions in other expressions in SSRS 2000

Using expressions in other expressions in SSRS 2000

• bitbum

  Hello Fang Wang,

  I read your article/code on custom aggregates at (http://blogs.msdn.com/bwelcker/archive/2005/05/10/416306.aspx CommentPosted=true#commentmessage). It was great and intresting. I have a scenario wherein I wanted to add the values of distinct transaction number, how do I do that. i.e.

  Financial organisation (GROUP (Company))

  12/31/2003 606.60 approved 123 (Transaction Number) (1st Row)

  5643577(Wok Report) (2nd Row)

  01/05/2004 1000.00 approved 124 (Transaction Number) (to Satisfy $1000 three work reports were raised)

  5643500(Wok Report)

  5643501(Wok Report)

  5643502(Wok Report)

  02/05/2004 2000.00 approved 125 (Transaction Number) (to Satisfy $2000 three work reports were raised)

  5643300(Wok Report)

  5643301(Wok Report)

  5643302(Wok Report)

  Total 3606.60 (Total per Company group)

  I want to add the visible row values only. Because the 1000.00 and 2000.00 was repeating for 01/05/2004 and 02/05/04 I am hinding the repeated values.

  I have used the code posted on the link provided above but it isn't working. Please help.

  Thanks,

  Deepak Vodethela

  
  
  

• stift

  You can create either a calculated field (http://msdn2.microsoft.com/en-us/library/ms345330.aspx) or a textbox that has the expression you want to reuse, and reference the field/textbox from other expressions (http://msdn2.microsoft.com/en-us/library/ms157274.aspx).
  
  
• Using expressions in other expressions in SSRS 2000