We help IT Professionals succeed at work.

Use current group member in a SQL Expression Field

kolson14
kolson14 asked
on
335 Views
Last Modified: 2012-02-15
I am currently working on a report in Crystal Reports. I have a bunch of SQL Expression Fields that I'm using for most of the data in the report, and I was wondering, is there a way to insert the current Group value into the SQL Expression?

I currently have two levels of groups in my report: Group 1 is the employee, Group 2 (nested within Group 1) is the client. I basically am running totals of billable hours, costs and fees, and then many more complex calculations, for each client that each employee is working with. Each client works with only one employee. I want to be able to use the employee of the group I'm in as essentially a variable in the SQL Expression Field. Is there a way to do that? I figure it should be similar to using a parameter field {?paramname}, or formula field {@formulafieldname}, but I can't seem to figure out what it is.
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Commented:
As mlmcc said, you may be able to use the field.  CR can be picky about how you enter the name, so if you want to try it, go into the SQL Expression editor, put the cursor where you want the field name, find the field in the list of Report Fields and double-click it to add it to the Expression (as opposed to just typing in the name).

 James

Author

Commented:
Thanks, guys!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.