Solved

Crystal XI - Summarizing Counts

Posted on 2015-01-27
4
88 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
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…

919 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

13 Experts available now in Live!

Get 1:1 Help Now