Could someone please advise on this problem?

 

I have a report, thats grouped by CUSTOMER.

 

in the group header, I have JULY sales, AUG Sales, SEP sales , Total Sales, Level Achieved.

 

mailto:%7b@TotalSales - {@TotalSales };

sum({julysales},customer) + sum({augsales},customer) + sum({Sep Sales},customer)

mailto:%7b@levelachieved - {@levelachieved };

IF mailto:%7b@totalsales%7d%20%3c150 - {@totalsales} <150   THEN "0%"

IF {@totalsales}>= 150 AND mailto:%7b@totalsales%7d%3c299 - {@totalsales}<299 THEN "1%" ELSE

 

Crystal reports process top to bottom and left to right.  Your count should process first then it should display the value, when it is counting it will process top to bottom and it can't come back and prit the value on reprot header.

 

Work around for this issue is :

 

Insert the same report as sub report on a different report header and write a manual running total like :

 

Whileprintingrecords;  // Insert this formula in your sub report group header//

Shared numbervar x;

 

if mailto:%7b@yourformula - {@yourformula } <150 then

x:=x+1;

 

Write one more formula like :

 

Whileprintingrecords; //  place this in your sub report report footer//

Shared Numbervar x;

 

 

Now in the main report Report create the following formula and place it on Report header ;

 

Whileprintingrecords;

Shared Numbervar x;

 

 

This will get the value into your main report.  You can suppress all sections of your sub report to avoide printing.

 

 

 

 

You dont know how long ive been on this.

I have tried many shared variables, sub reports, allsorts, but to no avail.

 

You have just finalized my report, that will be heavily used in my company.

 

I cannot thank-you enough.

 

It has certainly been a learning curve this one, and I now have the knowledge to implent this solution in other reports.

 

 

Sincere gratitude to you.

 

Anything i can do for you, just shout. anytime.

 

:)

 

Happy Mike.