troubleshooting Question

Finding sum in Crystal Report based upon some condition

Avatar of cinibia_nidhin
cinibia_nidhinFlag for Kuwait asked on
Crystal ReportsProgrammingSQL
15 Comments7 Solutions5674 ViewsLast Modified:
Hi,
In Crystal report I need to display the sum of a particular column based upon some condition. I'm using SQL database.
I have a Table named A and have in it I have 2 columns say A1, A2.. Can anyone let me know how to get the sum of those entries in A1 whose corresponding A2 is equal to, say, '1' in Crystal Report 10.0.

Thanks
ASKER CERTIFIED SOLUTION
peter57r

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 7 Answers and 15 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 7 Answers and 15 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