Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Get the Custom Created Field in the Expression Expand / Collapse
Author
Message
Posted Tuesday, March 18, 2014 9:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 1, 2014 1:45 PM
Points: 6, Visits: 33
I have a report having fields A, B, C,D
A and B are from the data set ,
Value of C is A+B
D is percentage of A

How can i get the custom added Field C in the expression of D ,so that i can calculate percentage for A

Thanks In Advance
Post #1552238
Posted Tuesday, March 18, 2014 3:15 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 3:24 PM
Points: 709, Visits: 4,523
Right-click on the dataset, choose Add Calculated Field, and then add the calculated expression to your dataset. Then you can filter/sort on that column.
Post #1552420
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse