Solved

limiting result in crystal report formula field with a where

Posted on 2011-03-16
8
369 Views
Last Modified: 2012-05-11
Is there any way to limit a formula field with a select statement?  I want to be able to create multiple summed values but each one for a diferent value in a column of the dataset.

Filter   #Elements
A            5
A            7
B            2
A            7
B            10
B            10

I want to be able to create one formula SumA and another one that is SumB.  I can easily see how to sum all the #Elements but not how to filter the formula.  Any ideas how to do that?

Thanks!
0
Comment
Question by:jrepdev
  • 3
  • 3
  • 2
8 Comments
 
LVL 8

Expert Comment

by:kingjely
ID: 35153572
Please Show the results you expect to see.
0
 
LVL 8

Expert Comment

by:kingjely
ID: 35153577
do you mean

filter  #element
6        41
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35153661
Try this
Name - A_Values
If {FilterField} = 'A' then
   {#Elements}
else
    0

Name - B_Values
If {FilterField} = 'B' then
   {#Elements}
else
    0

You can then summ the formulas and show the values.

mlmcc
0
 

Author Comment

by:jrepdev
ID: 35157507
mlmcc,

I have done this but it seems that is a fixed number.  It does not filter for selections by groups in the report.  Is there anyway to do this and have the results relate to the group section it appears in?

Eva
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 35159323
Put the formula in the detail section
Right click it
Click INSERT --> SUMMARY
Set it as a SUM
Insert it into all group footers

mlmcc
0
 

Accepted Solution

by:
jrepdev earned 0 total points
ID: 35300709
Bottom line is I can't do what I want to do so I have completely altered my approach.  Thanks team for all your help!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35300978
Can you show given the data what you want displayed?

mlmcc
0
 

Author Closing Comment

by:jrepdev
ID: 35331378
I discovered I could not do what I want to do.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 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