Post reply

Referring to a Column

  • January 16, 2006 at 5:59 pm

    #111722

    Hi,

    I have a report with a column that is calculated using 3 columns of the query source, and another column that uses the result of the prior calculation and applies another operations.

    How can I make reference to the 1st calculated column, so that I don't have to write the operation again?

    Hope I've explained myself !

  • January 17, 2006 at 11:26 am

    #615231

    Refer to the name of the column/textbox the calculation is on.. for example...

    =ReportItems!textbox22.value(this would be the calculated field) + fields!CountOfSomething(this would be what ever you want to add to the calculation)

    There is also another way as well..in the design view of the report go to the panes on the left and look at your fields pane and right click and add... now put in the calculation in the expressions portion and wahla you have a new field you can call from... hope this helps...  

     


    Moe C

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply