[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Crystal Reports

35K

Solutions

15K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Share tech news, updates, or what's on your mind.

Sign up to Post

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. Picture with example
See example attached.  I have also attached the .rpt saved with data.

Thank you.
AR_CreditRebill_LFW_Exchange.rpt
0
CompTIA Network+
LVL 12
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

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
0
Crystal Reports 2016

I am trying to generate a report to display stock which has been received more than one - all will be unique items which have a "receipt" and a "despatch"

what I'm after is reporting those which have been received despatched then received again (those with simply a receipt despatch can be ignored.

the result being a small list of items

the actual history database is huge so I am only looking to search a smaller amount but do need to consider if items have been received prior to my date range (ie 90 days)

any suggestions appreciated

thanks
0
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
0
I had this question after viewing Append all database values in Parameter not bringing in all data..

I have been trying to append values for site (customer site names) and it is bringing in (on estimate) the first 1000 sites in the database.  If I create an "ALL" selection and run the report it does bring in all sites.  Basically when appending I can see up to values beginning with 'H', but running "ALL" bring up to 'Z'.

It is a standard parameter
Crystal report version is SAP Crystal Reports 2016 Support Pack 5 Version 14.2.5.2618
I am currently in Evaluation to see if we can make use of the system before purchasing!  Not sure if this has an effect.

I have so far attempted:
Creating the parameter in a fresh report but same result
Setting the parameter to dynamic has the same limited number of selections
I have gone into registry and created a new key - LOV, with the string MaxRowsetRecords and set as 1000000.

I have come to the end of any other solutions?

Any help is much appreciated!
0
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.
0
Crystal Reports 2016

I am using the standard grouping by field in my report.  However I would like to actually combined several fields to fall under one specific group.  How would I go about doing that.

Field to group by.  A, B, C, D, E, F


Example:
                       Group: A
                           Detail A
                       Group B
                            Detail B
                       Group C
                            Detail C
                       Group (Contains D, E & F)
                            Detail D,E,f
0
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_Dosage3aDaily_Dosage3bDaily_Dosage3a.rpt
Daily_Dosage3b.rpt
0
Crystal Reports 2016 SP4

I wish to display a count of records based on a certain criteria at the Top of the report before the detailed listing.  Is it appropriate to use the Count() function to accomplish this.

SQL Columns

Location   Trustee
A Block          N
A Block          Y
B Block          Y


So in this case I wish to display the count of  all Records where Trustee  is "Y".

Count of Trustee:  2
0
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
0
Amazon Web Services
LVL 12
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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

Any ideas?
CR-Report.pdf
0
Crystal report not open more then 75 times
0
when i print crystal report more then 75 times then it give error
0
I need help with doing a Crystal Reports Label. I have messed with this so much this morning and cannot seem to get this to print as I need. I get one label print and then it spits out 7 additional labels. If someone can help and attach a file with the 3 basic values (I can rewrite my SQL) for this dimension, I would forever be grateful. I just need it to print one label and it keeps printing the additional labels.

The Zebra Label Printer is LP2824 Plus.
https://www.zebra.com/us/en/support-downloads/printers/desktop/lp-2824-plus.html

The label dimension is 2 and 1/4 by 1 and 1/4.

I need on the label the following:

Name
Address
City State Zip
0
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

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).
0
I am working on a formula that calculates the number of milligrams of aspirin that a patient consumes daily. A patient consumes varying amounts of aspirin daily. A blood test determines the concentration of aspirin in the patient. The test results are always fluctuating.

Here is some sample data:
Patient takes the following quantity of aspirin from January 1, 2018 to January 3, 2018: 1-1-18: 1 mg of aspirin;
1-2-18: 2 mg and 1-3-18: 3 mg.

Calculation: 6 divided by 3 = 2 mg in 3 day period. Result is 2 mg per day.

Here is the formula that I am trying to work with:
sum({Aspirin_Dosage.Dosage},{Test_Date.TestDate},”1/01/2018, 1/02/2018, 1/02/2018”)/count({Aspirin_Dosage.
Dosage},{Test_Date.TestDate}, ”1/01/2018, 1/02/2018, 1/02/2018”)

Database fields (Access):
{Test_Date.TestDate} = Need 3 days.
{Aspirin_Dosage.Dosage} = Need to add daily dose in mg for 3 days.

Report = The attached report is grouped on the {Test_Date.TestDate} field and “for each day” is selected under “the section will be printed” option under “Options”.

Screenshots of the database tables are shown below. How do I write a formula that performs the calculations?
 TablesDaily_Dosage2.rpt
0
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?
0
I am working on a formula that calculates how many milligrams of aspirin a patient consumes daily. A patient consumes 1 or more mg of aspirin daily. A blood test determines the concentration of aspirin in the patient. The test results are always fluctuating.

Here is some sample data:
Week 1: Patient takes 1 mg of aspirin per day. The date range is January 1, 2018 to January 7, 2018.
Calculation: 7 divided by 1 = 7 mg in 7 day period. Result is 1 mg per day.

Database fields (Access):
{Test_Date.TestDate} = Need 7 days.
{Aspirin_Dosage.Dosage} = Need to add daily dose in mg for 7 days.

Screenshots of the database tables are shown below. How do I write a formula that performs the calculations?
Tables
0
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
0
PMI ACP® Project Management
LVL 12
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

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
0
Hello,

I’m hoping you can help me with the attached (saved with data) backorder report?
The report is currently only showing remaining to deliver (or what is on backorder) quantities.
I am wanting to change the report so it shows all line items regardless of the delivery or invoiced status.
Are you able to assist?

Thank you.
CustomerBackorders.rpt
0
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!
0
I have a formula
if (isnull ({MembersDetails.Medical Conditions})) then 'None recorded' else ({MembersDetails.Medical Conditions})

But is does not work
The field in the database is completely blank, so is the problem that I am saying 'isnull'
How do I correct this?
Gordon
0
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
0
I have two groupings.  Student i.d. and detail code.  Some detail codes are the same amounts, which is an User error so my dollar amount is in my GF2 section.
I want to sum all amounts by i.d
What is happening when I sum is that I am seeing the wrong amounts because it is summing what I am trying to supress.
What am I missing?
Word doc. attached.
Thanks!
0

Crystal Reports

35K

Solutions

15K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Top Experts In
Crystal Reports
<
Monthly
>