I have a sales report that in addition to supplying the sales numbers it also:
Calculates and Displays how many Business Days are Remaining in the current month.
This is accomplished by:
(@REMAINING DAYS - @HOLIDAY_REMAIN)

In December we have two holidays 12/24 and 12/25.

If I run this report today (12/03) these values are as follows:
(@REMAINING DAYS = 20 - @HOLIDAY_REMAIN = 2) = 18 business days left in the month.  This is correct (Today doesn't count).

If I run this report on 12/26:
(@REMAINING DAYS = 3 - @HOLIDAY_REMAIN = 2) = 1 business day left in the month.  This is incorrect it should show 3 days remaining... @HOLIDAY_REMAIN should = 0

@HOLIDAY_REMAIN
//Main formula
WhilePrintingRecords;
Local DateVar Start := {@FirstDay};
Local DateVar End := date(dateadd("m", 1, {@FirstDay})-1);
Local NumberVar Weeks;
Local NumberVar Days;
Local Numbervar Hol;
DateVar Array Holidays;

Weeks:= (Truncate (End - dayofWeek(End) + 1
- (Start - dayofWeek(Start) + 1)) /7 ) * 5;
Days := DayOfWeek(End) - DayOfWeek(Start) + 1 +
(if DayOfWeek(Start) = 1 then -1 else 0)  +
(if DayOfWeek(End) = 7 then -1 else 0);  

Local NumberVar i;
For i := 1 to Count (Holidays)
do (if DayOfWeek ( Holidays[i] ) in 2 to 6 and
     Holidays[i] in start to end then Hol:=Hol+1 );

Hol

How might I adjust this formula to account for the holiday as it occurs and after it occurs?

Hello,
      I have a field on a Crystal Report that I would like to show text if the field returns a certain entry. What I mean is I want the report to to have the field read NO COMMIT if the data in that field is 12/31/1899. I used this formula but got errors.

if {tcspodet.ppromtxt}  = 12/31/1899 then "NO COMMIT" else {tcspodet.ppromtxt}

It says a string is required here.
2sql_query_tactic.rpt

Hi there,
I have a parameter where the use chooses a numerical range and if the report, I want to suppress the group base on whether or not the number falls within the range.

My suppression formula is
Not (sum({@# Courses}) in {?Select Range for Number of Courses Taken})

But when I run the report, it suppresses every record regardless of what I enter - do you have any ideas on why it isn't doing this or, if it's possible?

thanks in advance - CS

I have a report with the number field {QUARTWAGE.PAYROLL_YEAR}.  I need a formula so that whenever the report runs it picks up only data for the CURRENT Year.  I would appreciate your assistance.

We have created a cross-tab report in Crystal Reports 14.1 pulling sales data from our Epicor P21 data, summarized annual sales by customer.  It currently sorts by total overall sales after displaying columns of annual data.  This results in a report which looks like this:

                        Year      Year     Total
Customer      Data      Data     Greatest
Customer      Data      Data     ...
Customer      Data      Data     Least

We would like to sort on the current year rather than the total.  We can't seem to find a way to do that.

I have to prepare a report, in which it contains nested subreports...i know that nested subreports is not possible in Crystal Reports. can some body tell me how to proceed with this issue.
I have Main Report which contains a subreports, which internally contains a subreport in it.
please help me with this!!

does anyone know where I can get a copy of Crystal reports 8.5 or how I can change the font on an old crystal report.

I have a REALLY old application that only works with 8.5, and after this version the file format changed, I need to edit the reports but editing in a later version means the reports are no longer compatible with my application.  I have no option to upgrade the app.

Crystal Reports - Cross Tab total for Credit Rebills.  I can't get the formula right to get the total % to work out.  

I need the total columns to take the total credits divided by total Invoices.  Right now the field is adding the total percentage across and the amount is not correct.  Example attached.
See example attached.  I have also attached the .rpt saved with data.

Thank you.
AR_CreditRebill_LFW_Exchange.rpt

I have a report that is using  calculated member in a cross tab.  The "insertion formula" is making it show up after a specific column
"GetRowGroupIndexOf(CurrentRowIndex) = 1 and GridRowColumnValue("glaccnttype.glaccnttype_id") = "Overhead Taxes - Income""

Problem is this Row of Data  "Overhead Taxes - Income"" is not in all reports depending on date range ran.
This is an income statement and depending on the date ranges there are variable numbers of Rows of data.

How do I write the insertion formula to simply have it display at the end of the report?  
My three calculated members are below and each has the exact same insertion formula and show up when the account "Overhead Taxes - Income"" displays

Total Revenue
Total Expense
Net Revenue

This is in Crystal Reports 11.0
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
               TVS123      tuition Fees      90.00
               TVS356      tuition Fees      75.00
               TVS255      tuition Fees      55.00
               TVS285      tuition Fees      65.00
        Group3(Fee_type)- Other Fees
               L342 extras fees      2.00
               L852 extras fees      7.00
Group-2 NULL
      Admin Fee      100.00

In the above scenario, I have created, Group 2(sp_code) and Group 3(Fee_type).  My Group-3 is in specified order.  Group-2 is in ascending order.  
My issue here is, I want to display Admin Fee in “Other Fees” group like  below.  When Group-2 became NULL, it is displaying Admin Fee as a different Group-2 section, I don’t want to display Admin Fee as different group section.  I want to display as below.
Group2(sp_code) - CRN53345XL
      Group3(Fee_type) -Tuition Fees
                   TVS123      tuition Fees      90.00
                   TVS356      tuition Fees      75.00
                   TVS255      tuition Fees      55.00
                   TVS285      tuition Fees      65.00
        Group3(Fee_type) - Other Fees
                     L342 extras fees      2.00
                     L852 extras fees      7.00
                   Admin Fee              100.00

Is that possible at all to display Admin Fee under Other Fees? Can anyone please help me?
Thanks in Advance.