Solved

Create report Group based on Formula Field

Posted on 2009-04-12
4
740 Views
Last Modified: 2012-05-06
While this question: http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_23247486.html implies that it should be no problem to create a group based on a Formula Field, I'm unable to do so. I've created a Formula Field but can't find it in the list of fields available in the Group Expert.

The problem I'm trying to resolve is as follows:
- The company record includes an Industry Code
- I want to group all of the company records in my report based on the Industry Code Category.
- The industry code may be NAICS or may be SIC
- NAICS and SIC codes/descriptions/categories are stored in separate tables
- I must check each company record at runtime to determine whether it is an NAICS or SIC code

My approach, so far, was to create a formula field named Industry Category that tests the code and determines whether it is NAICS or SIC and then returns the associated Category (a string). I then wanted to add a group to my report based on Industry Category, but I can't find that field in the Group Expert.

Do I need to do something special to have the Formula Field available in the Group expert?
0
Comment
Question by:PolicyWorks
  • 2
4 Comments
 
LVL 16

Expert Comment

by:wykabryan
Comment Utility
Certain formulas you can not group on. Please provide the code that you are using in this formula.
0
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
Comment Utility
As he said, there are some limits.  For example, the formula must reference a field in your record (it sounds like you're doing that), and it can not use any CR summary functions.  If you post your formula, we can take a look at it.

 James
0
 
LVL 1

Author Closing Comment

by:PolicyWorks
Comment Utility
@James0628: Thanks, I wasn't referencing a field in my report, I was (for reasons I'm not sure of) referencing a different formula field (unnecessarily). I fixed up my formula and it work now. Stay tuned, I'll be adding another question that's a bit more complex (at least, it's complex to explain...we'll see if it's complex to resolve).
0
 
LVL 34

Expert Comment

by:James0628
Comment Utility
Ah.  Well, there you go.  :-)

 You're welcome.  Glad I could help.

 James
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now