latout naming textbox
hi ,
in need to create calulated fields and use them in the expression of another field
insted of writing the whole expressions for every change i make in basic field form witch i calculate
for example :
textbox21 -> ((CountDistinct(IIf(Fields!activitycount.Value<>0,Fields!new_actionitemid.Value,
Nothing))
textbox23 -> CountDistinct(Fields!new_contactidname.Value))
the current expression :
=((CountDistinct(IIf(Fields!activitycount.Value<>0,Fields!new_actionitemid.Value,
Nothing))/CountDistinct(Fields!new_contactidname.Value)))*100
the wanted expression :
textbox21/textbox23
is this possible?
November 29th, 2010 4:04am
You can write
=ReportItems!Textbox21.Value/ReportItems!Textbox23.Value
Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 6:45am
thank's
how can i reach it by click? (it's not part of the exppression options)
November 29th, 2010 7:34am
I didnt understand what you meant by "reach by click". If you meant how to put the expression, you can just right click on any textbox, go to properties and copy and paste the expression into the value of the textbox.Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)
Free Windows Admin Tool Kit Click here and download it now
November 29th, 2010 7:42am