Solved

Crystal XI - Summarizing Counts

Posted on 2015-01-27
4
86 Views
Last Modified: 2015-03-03
I have attached a report where at the report footer there is formula, SE Detail, and within the formula is another formula for Segment Counts, with formulas within.  Most of the detail formulas I am able to get counts on, but the 2 with the // I keep receivng a message that I cannot summarize the formula.  Could anyone give me a clue on why these 2 formulas I cannot summarize the data looks similar to other formulas so I am a little preplexed.

Count({@INS_Member Detail}) +
Count({@REF_Subscriber Detail}) +
//Count({@REF_Member Policy Detail}) +
Count({@REF_Subscriber_All Detail_17}) +
//Count({@REF_Subscriber_All Detail_DX}) +
Count({@DTP_Member Detail}) +
Count({@DTP_Member_336 Detail}) +
Count({@DTP_Member_All_356 Detail}) +
Count({@NM1_Member Detail}) +
Count({@N3_Member Detail}) +
Count({@N4_Member Detail}) +
Count({@DMG_Member Detail}) +
Count({@HD_Member_All Detail}) +
Count({@DTP_Member_All_348 Detail}) +
Count({@DTP_Member_All_349 Detail}) +
Count({@LX1}) +
Count({@NM1_P3_Provider Detail})

Formulas in question:
REF_Member Policy Detail:

"REF" + "*" +
//"1L" + "*" +
//"W0002961" + "~"
{@REF_REF01_Member Policy_Reference Identification Qualifier} + "*" +
{@REF_REF02_Member Policy Reference Identification} + "~"
 
REF_SUBSCRIBER_All Detail DX:

"REF" + "*" +
"DX" + "*" +
"1000" + "~"
Summarizing-counts.rpt
0
Comment
Question by:Grapelady
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40574505
REF_SUBSCRIBER_All Detail DX:
Doesn't have a database field in it so it is viewed as a constant and therefore doesn't have a "count".  Its count if you will would be the same as the count of all records.

REF_Member Policy Detail:

 What are these 2 formulas?
 {@REF_REF01_Member Policy_Reference Identification Qualifier}
 {@REF_REF02_Member Policy Reference Identification}

mlmcc
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40574521
Didn't see the attached report.

I changed the formulas as follows
REF_SUBSCRIBER_All Detail DX:
If {EMCS_CURRENT_SAL_JOB.ACTION_DATE} > date(0,0,0) then
    "REF" + "*" +
    "DX" + "*" + 
    "1000" + "~"
ELse
    "REF" + "*" +
    "DX" + "*" + 
    "1000" + "~"

Open in new window


REF_REF01_Member Policy_Reference Identification Qualifier
If {EMCS_CURRENT_SAL_JOB.ACTION_DATE} > date(0,0,0) then
    "1L"
ELse
    "1L"

Open in new window

REF_REF02_Member Policy Reference Identification
If {EMCS_CURRENT_SAL_JOB.ACTION_DATE} > date(0,0,0) then
    "W0002961"
ELse
    "W0002961"

Open in new window


The three formulas always return the same values but to the system it looks like they depend on a database field and therefore are calculated in the pass where summaries can be done and not in the pass before summaries.

After doing it that way I also tried this and it also worked.
REF_REF01_Member Policy_Reference Identification Qualifier
{EMCS_CURRENT_SAL_JOB.ACTION_DATE};
    "1L"

Open in new window


mlmcc
Summarizing-counts.rpt
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Change variables in SQL table 6 66
oracle query help 29 64
ORA-12560: TNS:protocol adapter error 8 48
Runtime 3044 error 14 15
In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

19 Experts available now in Live!

Get 1:1 Help Now