troubleshooting Question

Use current group member in a SQL Expression Field

Avatar of kolson14
kolson14 asked on
Crystal Reports
3 Comments1 Solution338 ViewsLast Modified:
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.
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros