[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

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.
0
Rowby Goren Makes an Impact on Screen and Online
LVL 12
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Have a report that I would like to put the totals into a cross tab sheet
Need some help

Gordon
WO-Stats_JV1.rpt
0
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 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 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
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
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
Exploring SQL Server 2016: Fundamentals
LVL 12
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

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
Hi All,

I want to decommission a file server that crystal reports server 9 saves it's report too.

Does anyone know where I can find the UNC, so it can be updated to a new file path

Phil
0
In my CR 2008 report I have main report as container for two sub reports that are created- based on the same sql command.
I am passing two parameters in each sub report.
 First parameter is ?Run_Date and I am using formula @CustomerNum to pass second parameter ?ListOfCustNum.
In each sub report I created sub report parameter named:
 ?Run_Date and ?CustomerNum – Name is the same as formula in main report.
 In sub report  parameter ?CustomerNum is number type and I did not checked Allow multiple value.
My formula in main report :
@CustomerNum
Numbervar Counter;
Stringvar display;
For counter := 1 to count({?ListOfCustNum}) do (
Display:= display + ToText({?ListOfCustNum}[counter], 0 , ””) +  ”,  “);
Left(display,len(display)-2);

I made links from main to subreport ?Run_Date and @CustomerNum.
I am getting proper date but not passing list of customer numbers in.
In sql command I have in Selection statement something as : Select ….where i.CustomerNum in ({?CustomerNum})
0
I have a crystal report
With some fields that do not contain data
I would like to suppress these and move other data up in it's place
Ie
Address 1
Address 2
Town

so I may not have any data for address2 so rather than a gap, can I then see, with no gap
Address1
Town

Gordon
0
I am looking for some direction in creating a Crystal Report using Crystal Reports 2016 and a SharePoint 2010 list as a datasource.
0
In Crystal Report 2008 .
I am working on one my old report that calculating rolling amounts from customer that have orders from different suppliers.
Columns that I need to compare are: Month, Three Months and Year (6 columns)
-      Full selected month this year to the same month previous year;
-       Three months back from selected month this year to the same three months in previous year
-      Current YTD up to full selected month to previous year to date.
Condition is that only Customers should be included that have orders from suppliers which are older than two years from selected date.
One customer can have several suppliers and one supplier can have several customers.
It means those customers have to have order older that two years from parameter date but they can have beside those  at the same time orders that are not older that two years too.
I need grouping on Suppliers and then their Customers and calculating those values for each customer with total for supplier.

Customer which do not have any orders (amounts) in previous year column should not be included in calculation and should not be shown in report.
I have problem how to restrict and not showing customers which do not have orders in previous year(even they could have in this year).

I created one Main report and two subreports (rpt_Main; rpt_SubMainA; rpt_SubMainB).
In rpt_SubMainA I presented every Supplier with their customer and do those calculation in columns.
In rpt_SumMainB I show only final …
0
What connection type to i use to connect Crystal Reports to an SQL express database?
Gordon
0
Fundamentals of JavaScript
LVL 12
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

Hello,

Can you please help me modify the attached report so it sorts the Quantity field from largest to smallest?

I am also wondering if it is possible to add a 'drill down' to the report on the header record and the drill down would show the child record?
An example of this in the report is:

10000.white.06
10000.white.07
10000.red.01

Header record would be:
10000

Drill down would then show:
10000.white.06
10000.white.07
10000.red.01

I have saved the attached file with data.

The existing drill down feature (To show Customers) can be removed if need be.

Thank you.
SalesByProductByCustomerSummary.rpt
0
i have develop Asp.net application With Crystal Report in Visual Stdio 2010...
Application Working Fine in local..
but i public application in IIS server application working fine 1- 2 hours..
after 1 hour application Not Display Crystal Viewer...



Please Help me...
1
Hello,

I’m wondering if I could please get some help with my Crystal Report?
The 5th column in from the left called “LYSales” is not calculating the correct last year sales values and I am unsure why.

The sales financial period in Australia is from July to June.

I have saved the report with data.

File attached.
MatrixSalesByProduct12Months.rpt
0
I am running sql server 2016 on a new server.  I have views that convert binary blob fields to text that I can use in Crystal Reports.  For some reason, when I bring them into my crystal report, it only show the very first character of the converted field.  If I look at it in SQL Server, it show the entire text in the converted field.  Anyone have any ideas why it's doing this and how to fix it???
0
Hi,
I am working with crystal reports in VB.NET 2008.  I need to understand that how can I insert a page number in the details section.  Please note it has to be in the details section. I've tried the traditional way of placing the special field "page N of M" in the details section but while printing multiple pages for a single record, it only appears at the end of the record, while what I need is that it should appear on each page and get reset for a new record.  Will I have to create a formula to accomplish this.

Thanks in advance.
0
Hi there,

I have a  report that has several columns but have just been asked to add a notes field which means that the lines used to create columns will appear in the notes as well, dividing the text.  Is there a way to retain the clarity provided by the lines but if there is a note for the lines to "suppress" or "disappear" when a note is present? - Perhaps overlay? But I can't figure this out - thanks so much in advance,

CS

 *Crystal 11 is the product I am using
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
>