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

Hello,

I need a Crystal reports formula to convert a duration stored as HH:MM to total minutes. For example, 02:00 would convert to 120.

Thanks!
0
I have had very disappointing results with Microsoft Report Builder and SSRS.  Neither have even printed a simple results of a query.  Report Builder 3 was a sad experience. So I just downloaded Crystal Reports 2016 trial and DevExpress Reports trial.  I was told that the learning curve for DevX is extremely difficult, so I will delete that one.  I don't need complex reporting, just results of stored procs, some complex with as many as 7 tables in a series of joins.

What reporting software do you guys recommend?

Barry D
0
We've recently started using Crystal Reports.   It works great using an ODBC connection.   Now we want to start using the Crystal Reports Viewer; however, we can't seem to get it connected to the ODBC connection already on those computers.  As a result the reports won't refresh.   Any help would be appreciated.
0
I am trying to create a Trial Balance output report (Maybe crystal reports) in VB.NET desktop application.

There are 5 different tables to retrieve the data from.  I have attached the VB.net Code.

My thought is to create a view within the SQL database that will do everything that the code attached will do.

My questions are:

Is this possible?

Can someone please help me?
TrialBalCode.docx
0
Hello,

I'm trying to make a line graph in Crystal where the line is accumulative and has a 3 year comparison.  I just can't get it to do it.  Can someone please help?  I've attached the Crystal report, and an example of what I'm trying to do.

EE.rpt

chart-example.pdf

Thank you!
Joel
0
There are two name formats in my system due to clerical error. I need a formula to extract the first name for the two formats below.

LastName;FirstName  Initial
LastName; FirstName Initial

This formula works fine for the first format but not the second.
Split(Split({PRM_MASTER__EMPLOYEE.Employee_Name},";")[2]," ")[1]
0
How would I create a filter in Information Design Tool 4.2.  in a Universe to report LastFullWeek , Sun to Sat ?
It could be scheduled to run on any day the following week.
0
If a field contains "Foreman"
then "Y"
Else "N"
0
Hello

The attached Crystal report file prints ok within Crystal Reports 2008 however when I use it in our accounting software it's adding an extra blank page.
Would anyone be able to assist me with this?

Thanks.
CustomerStatementAsAtDateVerticalLFT.rpt
0
I need to create an if and then formula for multiple fields.

For example

if field1 is null, then use field2 if not null, if field2 is null, then use field3 if it is not null, and so forth.

if isnull({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_6})
then if isnull({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_5})
then if isnull({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_4})
then if isnull ({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_3})
then if isnull ({PRM_MASTER__EMPLOYEE_CUSTOM_FIELDS.Term_Date_2})
then {PRM_MASTER__EMPLOYEE.Termination_Date}
0
Is it possible to have my assistant automate a report export in excel and save it into a specific folder?
0
Hot to take a field and add a number incrementally.


{PRT_CURRENT__CHECK.Batch}
Original: 1854
Line 1 Results:   1854001
Line 2 Results:   1854002
Line 3 Results:   1854003        
Line 4 Results:   1854004
0
Hello,

I need to change a field dollar amount into this format below:

Change Dollar Amounts into "$$$$$$$$$$CC" format

Last two numbers will automatically be cents.
Must be formatted as "$$$$$$$$$$CC"
Cannot Contain ","

Original:
125.23

Results:
000000012523
0
How to count the number of characters in a field (the field is all numeric)? Then if the count is equal to or less than 8, then add a 0 to the front of the field.
0
Hello this error is appearing while we generate Crystal report and Save, (Win Form application)

Faulting application name:  time stamp: 0x5ba984d7
Faulting module name: crpe32.dll, version: 13.0.22.2668, time stamp: 0x5a54abbd
Exception code: 0xc0000005
Fault offset: 0x0036bef5
Faulting process id: 0x6e8
Faulting application start time: 0x01d486453db469cc
Faulting application path: C:\Program Files (x86)\
Faulting module path: C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\crpe32.dll
Report Id: d831e0c1-f238-11e8-80
Faulting package full name:
Faulting package-relative application ID:
0
I need a resume in cristal reports 2008 that give me a result if all the columns are the same

Im attaching an image of what i need to do

if all "ir altas" then in the resume put me "ir altas" if not all "ir altas" in the reume remain blank or another textt
results.jpg
0
I need to extract the first name only.

Here is the current format from the system:

LastName;Firstname Middle Initial
Ex. Doe;Jane R

I am able to extract the first name with the middle initial. I just need the first name only.

I am using a two-part formula

Part 1: right({PRM_MASTER__EMPLOYEE.Employee_Name},len({PRM_MASTER__EMPLOYEE.Employee_Name})-InstrRev({PRM_MASTER__EMPLOYEE.Employee_Name},";"))


Part 2: left({@Formula 1},len({@Formula 1})+1)
0
Hello,

I need to write a formula in crystal report to tell Sage 300 when exporting to excel format the cell width based on the group footer.

Is this possible?


Crystal Export Options
0
Crystal Report Sage 300 - formula to take the hire date, add 60 days probation period, then round it to the nearest 1st of the month.

Example:
Current Data      Results
Hire Date           Eligibility Date:
01/15/2019       04/01/2019
01/01/2019       04/01/2019
0
Hi,

I need to extract ONLY the first letter of the below keywords:

example:
bavarian edge knife sharpener: deluxe black diamond edition
battery knife sharpener
16 degree

result:
b e k s d b d e
b k s
1 d

thank you
0
I have primary created reports in access but I am attempting to switch over to crystal. I am having an issue figuring out how to implement multiple conditions on one field.

Example

{ML.ML_LOCATION} in ["FACSUPPLY", "HFACSUPPLY", "MAINSUPPLY", "MBSUPPLY"]

but then I also need to pull anything that is in ML.ML.LOCATION that is between A-14-01-A to A-14-01-F and between A-12-01-A to A-12-06-F

I cant seem to figure out how to get that all to work together? I tried
{ML.ML_LOCATION} in ["FACSUPPLY", "HFACSUPPLY", "MAINSUPPLY", "MBSUPPLY"] and
{ML.ML_LOCATION} in "A-14-01-A" to "A-14-01-F" and
{ML.ML_LOCATION} in "A-12-01-A" to "A-12-06-F"

but that did not seem to work properly. Any suggestions?
0
Hi,

Im new to Crystal.

I have an excel file that i'm using as my datasource file.

In the excel file, there is a column I (Customer Search Term)

I want to create a Formula Field to view only the first word of column I.

For example,  the below Customer Search Term, i want to extra only the first word "anysharp".


anysharp pro knife sharpener

But, there are first word or number begin with 20 or 3 in the Customer Search Term (column I), i want those too to be extracted like shown below

7 degree knife sharpener

I want to extract "7" only

7

Hope i have explain my problem above and thanks for your help.

Leonard
0
I have a web application running in classic asp and I am currently using the crystal reports viewer to allow users to generate and download reports. My problem is I need to disable the IIS sessions and switch over to using cookies in order to handle a problem with query overlap on the web application. That is all working fine but the crystal reports viewer pages use sessions. Is there a way to run the crystal reports viewer without using sessions. Below is a sample of one of the crystal reports pages that  generate the reports.

<%@ Language=VBScript %>
<%
Dim Report_Template
Dim basepath, baseVirtualPath, iLen
Dim Param1, Param2, ParamValue2, P2, P2R, ParamValueEndRange2
Dim curValue
Dim viewer
 
basePath = Request.ServerVariables("PATH_TRANSLATED")
While (Right(basePath, 1) <> "\" And Len(basePath) <> 0)
    iLen = Len(basePath) - 1
    basePath = Left(basePath, iLen)
Wend
Response.Write basePath
baseVirtualPath = Request.ServerVariables("PATH_INFO")
While (Right(baseVirtualPath, 1) <> "/" And Len(baseVirtualPath) <> 0)
    iLen = Len(baseVirtualPath) - 1
    baseVirtualPath = Left(baseVirtualPath, iLen)
Wend

If Not IsObject(session("oApp")) Then
    Set session("oApp") = Server.CreateObject("CrystalRuntime.Application.11")
    If Not IsObject(session("oApp")) Then
        response.write "Error:  Could not instantiate the Crystal Reports automation server.  Please check to see that Crystal Reports or ReCrystallize has been properly installed on the web server PC.  

Open in new window

0
Hi Experts!
I have a crystal report that has a mock crosstab with 48 spaces.
Techs use this as a plate map for testing samples.  Each batch can have up to 47 samples (first cell is always a control).  
I need to be able to put the sample ID in the correct space but have not been able to do that so far because the batch does not always start on cell #2.  If the plate has cells that are not suitable for testing, they can start a batch on the next available cell, like cell number 22, for instance.
How can I possibly place the correct ID's in the correct cells whey they're starting at random numbers?  I created a table with 48 numbers as "cell addresses" and have a parameter called "First Cell" for the tech to enter the first cell they are using but I can't seem to get any further - how do I link the two??
Any attempt I've made to use *next* function works great on first and second values, but doesn't go anymore.  The ID's are alphanumeric so i can't really use +1.  I've also tried creating arrays and then calling each element out one by one but that's not working well either.
This mock table is in the report footer.
Any help is much appreciated!
0
In crystal report 2008 how you map old command to new  command they have the same filed but some selection criteria are different. What are the steps. Do I need to have old command in report then add new command or I remove old then add new?? Both of them working on same tables from the same database.
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
>