change filed caption dynamicly

• adiya78

  SSC Journeyman

  Points: 84

  More actions

  October 27, 2008 at 7:08 am

  #200025

  Hi,

  I have a dataset that fill with a list:

  Col1 col2 col3

  1 '888' 'Lable1'

  2 '123' 'Lable2'

  3 '659' 'Lable3'

  4 '999' 'Lable4'

  .

  .

  .

  I have a Parameter that has as a value col1 and description col2.

  I have to put on the result table one column that has caption of col3.

  for example: if i select the Description '888' the caption of the column on the result table should be 'Lable1'.

  how can I do this?

• shilpareddy2787

  Mr or Mrs. 500

  Points: 502

  More actions

  November 2, 2008 at 11:27 pm

  #892886

  Hello,

  Go To Report Parameters, add a new parameter,

  Select From query radio button bwlow available values, Select the Dataset which you get the result,

  In the Vlaue field select 'Col1'

  In the Label Field select 'Col3'

  Check the Internal CheckBox.

  In the Default Values Section , Give Parameters!Parameter1.Value.

  In the Column Header where you required the name give as Parameters!Parameter2.Label

  Hope this helps