SQL 2005 Reporting Services

Ice Rhino

Registered User.
Local time
Today, 14:49
Joined
Jun 30, 2000
Messages
210
I am not sure whther I am allowed to post this in here but I could not find anywhere else on the board. Apologies if incorrect

Textbox Calculations
I have 2 text boxes on my report that contain values. I want to be able to divide one by the other and the result placed in a third. I have try some variants on the expression builder to do the sum but it won't have it. Obviously I can't use =Fields!etc as they are not fields in the soure data for the report.

What is the syntax to basically say TextBox3Value = Result of (Textbox1.Value / Textbox2.Value)

Regards
 
Resolved by using

TextBox3 syntax was:-

=((ReportItems!TextBox1.Value)/(ReportItems!TextBox2.Value))

Regards
 

Users who are viewing this thread

Back
Top Bottom