Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Crystal XI - Summarizing Counts

Posted on 2015-01-27
4
Medium Priority
?
102 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
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

636 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