crystal report formula issue

Question

0.00/5 (No votes)

See more:

hi everyone,

my first formula in crystal report is given below its name is "xy"

C#

currencyVar x :={RptNetSalebyCustomer;1.TotalSale} ;
currencyVar y :=sum({RptNetSalebyCustomer;1.TotalSale}) ;
currencyVar z :=x/y*100 ;

when i insert summary field the above formula not show in dropdownlist

and if i create another formula name is 'yz' and i put
Sum({yz})
then its not allowed me to create this its give me popup message "This field cannot be summarize".

please help me how i sum this formula and insert it into group.

thanks

Posted 25-Oct-11 3:15am

mohd vaquas

Add a Solution

2 solutions

Solution 1

you cannot summarize complex formulas,

you can create a running total for this field.

Posted 25-Oct-11 3:28am

Santopk

Comments

mohd vaquas 25-Oct-11 9:31am

how can i create running total .....
when i create running total this formula not show.....
please help me

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)

Santopk · Accepted Answer · 2011-10-25T17:32:00

Solution 2

Ok Do one thing create a new formula called "sumxy"

inside that formula just declare a variable like

global numbervar sumxy

and in your old formula after all add this line

sumxy=sumxy+z;

and use sumxy as your summary

Posted 25-Oct-11 17:32pm

Santopk