Crystal Report-Result of selection formula must be a boolean.Error in file ...\temp

Question

0.00/5 (No votes)

See more:

Hello,

I am working on crystal report and am relatively new to it.

I Added a formula field Per% and wrote the formula

Sum ({Masters_TService_TClass.abc})*100/Sum ({Masters_TService_TClass.Total})

But when I execute,I get the following error:

VB

Result of selection formula must be a boolean.

Error in file c:\Document~1\cubical6\LOCALS~1\Temp\temp_03ca344b-568e-4ea1-bea8-94f3ef92bbcd.rpt:Error in formula <group_selection>
'Sum({Masters_TService_TClass.abc})*100/Sum
'
Result of selection formula must be a boolean.
 </group_selection>

Same formula is running in another crystal report.
Even on the deletion of the formula and formula field Per%, I am getting the error.

Bye

Posted 4-Nov-11 2:30am

Kaira_29

Add a Solution

Comments

Prerak Patel 4-Nov-11 8:34am

What selection formula is used in your crystal report?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2011-11-04T02:35:00

Solution 1

Try something like this. Is it a selection formula BTW?

Sum ({Masters_TService_TClass.abc})*100/Sum ({Masters_TService_TClass.Total}) > 0

Posted 4-Nov-11 2:35am

Prerak Patel

Member 3652106 · Answer 2 · 2012-01-29T23:52:00

Solution 3

Open Formula Workshop by editing the formula, Expand Selection Formulas, select Group Selection - now formula will appear on right side. Select that and delete.

DONE!!!

Posted 29-Jan-12 23:52pm

Member 3652106

Kaira_29 · Answer 3 · 2011-11-04T02:44:00

Solution 2

Hello Thnx,

But My issue is I wrote the formula using the editor and even on deleting the formula field and the respective field 'abc',why is my crystal report giving the error when the formula no longer exists.

TC

Posted 4-Nov-11 2:44am

Kaira_29

Comments

Rajesh Anuhya 30-Jan-12 5:53am

Post your comment under the answer.
--RA

Member 9793349 18-Jul-13 4:37am

I have problem when i want to sum columns time in crystal report , but it doesn't work and i got Error " selection formula must be a boolean" so please , anyone has some answer please ..