troubleshooting Question

Grouping ranges in SQL for Crystal Reports

Avatar of garyjgs
garyjgsFlag for United States of America asked on
Crystal ReportsSQL
4 Comments1 Solution428 ViewsLast Modified:
I am creating a Crystal Report using SQL.  The Crystal Report has to display various ranges (or Groups) that are not contigous.  For example, this is a comparison report which displays FTE data at the top of the page. Then there is Revenue data which is then displayed.  Expenses is the third grouping.  Last group in the report is more statistical data.

"Account Nr."       "FTEs Count"   "Actuals"  "Flex Budget"   "Static Budget"

"Account Nr."        "Revenue"      "Actuals"  "Flex Budget"  "Static Budget"


"Account Nr."        "Expenses"      "Actuals" "Flex Budget"    "Static Budget"

I was trying to avoid using Groups in Crystal Reports.  Is there a way to group this in a SQL statement?

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

Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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