?
Solved

Crystal XI - Summarizing Counts

Posted on 2015-01-27
4
Medium Priority
?
99 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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