Group Sum not working
Please see attached report
The sum of the BD should be 10 not 8391
Not sure what is going wrong
WO-Stats.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.

I added five new formulas to a report (Daily_Dosage3b) and the results of the original three formulas on the new
report are different than on the original report (Daily_Dosage3a) that has only the original three formulas. Please
help me resolve the error. Why do the original formulas have a different result on the new report (Daily_Dosage3b)?

New formulas:
LowerTestResult = global numbervar LowerTestResult;
if {Test_Date.TestDate} = {?From Date} then
LowerTestResult := LowerTestResult + {Aspirin_Test.Reading};
LowerTestResult

UpperTestResult = global numbervar UpperTestResult;
if {Test_Date.TestDate} = {@ToDatePlusDay} then
UpperTestResult := UpperTestResult + {Aspirin_Test.Reading};
UpperTestResult

ToDatePlusDay = DateAdd (“D”,1,{?To Date})

TestResultDiff = {@UpperTestResult} - {@LowerTestResult}

Original formulas:
testAverageDosage = if not({@testDosageCount}=0) then {@testDosageAmount}/{@testDosageCount}
else 0

testDosageAmount = global numbervar dosageAmount;
if {Test_Date.TestDate} >={?From Date} and {Test_Date.TestDate} <= {?To Date} then
dosageAmount := dosageAmount + {Aspirin_Dosage.Dosage};
dosageAmount

testDosageCount = global numbervar dosageCount;
if {Test_Date.TestDate} >={?From Date} and {Test_Date.TestDate} <= {?To Date} then
dosageCount := dosageCount + 1;
dosageCount
Daily_Dosage3a.rpt
Daily_Dosage3b.rpt

I have created a report that runs as planned in crystal reports 2016 SP4 and through the proprietary software using  Crystal Reports runtime 2008 SP5.  On another computer using the proprietary software using  Crystal Reports runtime 2008 SP5 the report will give me different data each time it is run.  When I first ran the report it showed only data where all the linked fields matched, which is not correct( attached file called incorrect.pdf.)  Then I ran it again and it gave me the correct information,(attached file called correct.pdf).  
The report has 6 tables Customer, Sales rep, Order, Dr, and customer type and are left outer joined, not enforced from customer to the other tables.

The Data base is MySQL

It is the same report  Incorrect ran first, then ran correct right after and different results.  
incorrect.pdf
correct.pdf

Thanks in Advance

Visual Studio 2005 crystal reports only shows half of print preview, The right half is faded out...
See attached.

Any ideas?
CR-Report.pdf

when i print crystal report more then 75 times then it give error

Here is my data:

country  category   description
US       9          dvfbwrtbrt sd rd
US       9          zdf s tbr t bs th sd
US       9          fdbwrt yr ns t s
CZ       9          tyjnd tyn etyn
US       11         xcbf dg erg
IT       11         far vwer  hade h

Select all Open in new window

In Crystal Reports I am trying to create a box label that has "Box 1 of x" but in the DETAILS section of the report.
The number of boxes is determined by the count of the category field

So for example, the first 4 line items are all category 9.
There are 4 records so there will be 4 boxes
The next 2 records are category 11, so there will be 2 boxes.

When the value of 'category' changes, the total resets.

And so the labels will print like this:

dvfbwrtbrt sd rd
Box 1 of 4

zdf s tbr t bs th sd
Box 2 of 4

fdbwrt yr ns t s
Box 3 of 4

tyjnd tyn etyn
Box 4 of 4

xcbf dg erg
Box 1 of 2

far vwer  hade h
Box 2 of 2

I am able to create a label that shows the "Box 1 of N" but the only way it works for me is if I place that in the group footer section of the report. I want it to be in the details section. (the header and footer are empty).

When I do a parameter field and choose the list of values to be dynamic, it only shows a certain amount of the list when the user runs the report. How did I get the entire list of values to return rather than only a certain amount?

Hello,

Are you able to help me suppress the line items on the attached report where “To Invoiced” column is equal to zero?

Currently, it's printing the zeros which make the report too long.

Thank you.
CustomerOutstandingOrdersCommentsSor.rpt

Hello,

Are you able to help me change the following report:

•      In the Product Code and Product Description columns where it says “text” I need this to be italics (text only though, please see screenshot attached)
•      Are these ‘text’ line able to print before the product code lines rather than after?

It has been saved with data.

Thank You.
CustomerOutstandingOrders.rpt
Untitled.png

I created a Cross Sell report - for every Fuel Customer we sell Lubes to - I need to count the customer in that Group and use the number in a formula for our score card.

In Crystal Reports - I have a field for Lube Sales  -I want to count any of the Lube sales in GF3 if the total is not 0.  I need to have the Count in GF2 to use in a formula.  I have tried several formulas and running totals and it is not working.  

Can you help?  I attached a screen shot of the report.

Thank you!

I have a .Net windows app.  It creates a Crystal Report in word.  It pulls data from a datasource and displays it in the report.  Sometimes the field is null and a textbox isn't created in the word document.  Is there a way to create the textbox even if the field is null?

Thanks