Crystal Reports

34K

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

Enterprise system HTML can be modified ("hacked"), allowing a user to see data they shouldn't see, by inspecting the page.

I'm no web programmer but generally familiar with HTML. I was really surprised that the HTML could be modified so easily.

The HTML is generated from Oracle Designer, a really old tool that is outdated but we're still using it.

Isn't there some way to mask the code? or make it unchangeable? We've also had issues in the past where SQL code / values are exposed and were able to be changed. That too surprised me. That was fixed with some back-end programming (the HTML could still be modified).

In the screen shot, the ID # can be changed and so the user can see another user's info, by either guessing another's ID or sleuthing to find someone specific's ID.
Inspect-HTML-and-change.png
0
Cloud Class® Course: Certified Penetration Testing
LVL 12
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

CRV 11 - I have a report that lists all employee numbers (and other employee demographic data) and their supervisor's employee number.   The EMPLOYEE table has an inner join to the SUPERV table (which has the supervisor's employee number).  I need a formula that will identify if an employee is ALSO a supervisor.  Thanks
0
Hello,
As you can probably tell from my question below, I have no experience with Crystal Reports....need some help with one file.
I have a field in Crystal Reports that's pulling info from 2 different fields in Database.
Right now that info shows in one row, and I'm trying to find a way to print those two fields below one another.
Formula looks like this:
:= {WMSalesLine.Description}&" "&{WMSalesLine.ShortDescription}

Displayed text: "text 1  text 2"

Would like it to show like this, even if database field(s) are =""
Text 1
Text 2

Is there a way to modify existing formula to achieve this?

I tried adding a separate field in Crystal Report, but it keeps coming back that "formula didn't compile".
Report is attached...field is "SalesLineDescription" under section :"Details"

Thanks!
0
Hello,
      I have a Crystal report that I would like to have the word “Stockroom” print in a field if another field is greater than 0.00 or if yet another field is null. I used the following but it does not seem to work.

if {@adjusted_qty}  > 0.00 or IsNull ({@excess})then "Stockroom"

Any help with this would be appreciated.

Thank you
0
This is a question that I have little understanding of. I understand what a Equal, Left Outer, Right Outer and Union Join is. As for the rest I am confused. This document  is straight out of Crystal Reports Help file. As you can see there are literally no definitions or examples for it. I do not know how hard this would be to give an example and give some definitive answer to what they mean but I thought I would try. Here it is straight out of the help....

Linking options
Crystal Reports enables you to specify the type of join and type of link you want to use when linking tables. You can also enforce the use of tables in your joins. Joins and links indicates how linked fields in two tables are compared when records are read. Join, enforce, and link options can be specified in the Link Options dialog box. Using the various join enforcement options can ensure that linked tables are included in the SQL query, even when none of the fields in the table are used in the report.

Note
 When you link fields using joins, no indexed fields are required.
The join types are:

Inner join
Left Outer join
Right Outer join
Full Outer join
The enforce join options are:

Not Enforced
Enforced From
Enforced To
Enforced Both
The link types are:

Equal [=] link
Greater Than [>] link
Greater Than Or Equal [>=] link
Less Than [<] link
Less Than Or Equal [<=] link
Not Equal [!=] link
0
I cannot figure out how to remove the period from a number formatted field in Crystal Reports. So basically here is the situation:

For the amounts.....
  • 501.20
  • 21001.93
  • 792.00

I need them to output like this:
50120
2100193
79200

Does anyone have any suggestions on things I can try? I already tried Replace and ToText and a couple others with nosuccess. Thank you in advance.
0
Hello Experts,

I want to have a clear understanding of how Crystal Reports 2013 processes subreports. I have a main report that includes four subreports linked to the main report by a case_id database field. Two of the subreports reside in a page header b section of the main report. The other two subreports reside in group header 4a and 4c sections of the main report. I want to know how Crystal Reports processes the subreports...either one at a time after processing or pulling all of the data from the database for the main report, or if it pulls the data for the subreports as it's processing each case_id returned by the query in the main report. There are a total of 5 groups in the report...event type, defendant_name, dfndt_id, case_number, and charge_disp. Is it possible for you to provide a general explanation of how Crystal Reports would process the data and generate the report based on the information I've provided here?

Thank you
0
We have a crystal report that has been in production for a few years, now we want a parameter added to interface which is our erp system syteline.   We have added a simple check box which we have as a binary field 1 true and 0 false.  
Next we need to pass that new value to the crystal report, so we right click and add parameter to be binary to the report and place it in the correct location.   When we open the interface and pass the value we get the below.  We have never been able to add parameters to crystal once is was built without rebuilding it.    I really don't want to rebuilt this report any ideas?

The report calls a sql procedure Sql 2012 R2.  I have attached a screen shot of the added parameter if that helps.


crystal version 14.1.4.1327 (crystal reports 2013) .




***** Error [6/26/2018 10:15:12 AM] *****
Experienced an exception while executing [PrepareReportParms]; The types of the parameter field and parameter field current values are not compatible.
CrystalDecisions.ReportAppServer.DataSetConversion
   at CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
   at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetParameterValue(String name, Object val)
   at Mongoose.MGReportProcessor.CrystalReportProcessor.PrepareReportParms()
<InnerException>The types of the parameter field and parameter field current values are not compatible.</InnerException>

The process [C:\Program Files …
0
How to print QR Code in Crystal report 8.5 and Crystal Report 11 ?
0
I have an existing VB.net application which uses Crystal Reports & remote (on the internet) MySQL. I wish to add an image to the report for each record.
I've got the images saved in a field called photo structured as a LONGBLOB.

1. How do I add the 'photo' field in the Field Explorer, so that it can be included & displayed on the report?

Currently I'm using ADO.NET (XML) to reference the MySQL data.

            sql = "select gate.fullname, gateaccess.id, gateaccess.gadate, gate.photo from gateaccess join gate on gate.id = gateaccess.id where gadate > '" & datetime & "' and gadate < '" & datetime2 & "' order by gateaccess.gadate, gateaccess.id asc;"
            cmd.CommandText = sql

            myAdapter.SelectCommand = cmd
            myAdapter.Fill(myData)

            myData.WriteXml("C:\GateAccess\gateaccessdataset.xml", XmlWriteMode.WriteSchema)

            conn.Close()

Open in new window


Here is the gateaccessdataset.xml:

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="Table">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="fullname" type="xs:string" minOccurs="0" />
          …
0
Cloud Class® Course: Microsoft Azure 2017
LVL 12
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

I have a string field of high school gpa which is 4 characters long, i.e., 4.00
I created the tonumber formula on the field.
I need to pull a range from 2.31-2.40 so I say @hsgpa is between 2.30 and 2.41.
It is pulling students with a high school gpa of 2.41 and I don't know why?
0
I have a crystal report with decimal number in it (.34) as it is in the report but I want to display it like this (.3400).


Note: I Edit Format Object in  Number Tab to (-1,123.0000) but still NOT working, I still have (.34)  .
0
I am trying to remove the Aging Basis parameter from the below statement.  
Can anyone tell me why I'm unable to remove the parameter from BooleanVar field?  I don't understand what's defining how many parameters there are...
Thanks!  
 
WhilePrintingRecords;
Global BooleanVar CustomerWillShowDetail := tsarCustomerDetailWithRetainage({@tsDataFolder}, {@tsFileName(ARA)}, {@tsFileName(ART)}, {ART_CURRENT__TRANSACTION.Customer}, {?Aging Date},{?Aging Basis}, {?Include Retainage?}, {?Unpaid only?}, {?Include Finance Charges?});
0
Hi

I have a date field in a report which I need to highlight yellow when the field contains no date. The field must retain its date format and not be changed to text for instance.

I have tried the following with the following report optuions ticked

Convert Database NULL Values to Default
Convert Other Null Values to Default

I have used the following in Format Field > Border > Background

If isnull({Command.draft}) = true then crYellow
else if {Command.draft} = date(0,0,0) then crYellow else crwhite

Using the above it still stays white instead of yellow

Thanks
0
I wonder if I can get some help migrating a VB6 project with Crystal 8.0/8.5?  These are windows' 10 PCs.

The reports are working in the development machine but the production machine keeps having problems with an 20599 error.

I checked the ODBC 32bit connection and that is connecting fine.
0
Im getting the value like 2hrs 122 min and i need the solution like 4hr 2min what formula i need to try?
0
I am trying to get the Head, Subhead and Body fields to appear on the same page. With the current report design, the Head, Subhead appear on one page and the Body field appears on a separate page. I worked with the Keep Together feature in the Section Expert without success.

Please help me resolve the problem.
DesignCover_EE.rpt
0
I am trying to write a formula that will suppress records that have a null value for the Task_Date field but I get an error. Please help me resolve the error.

I created the following formula for null date values but I get a "a number, currency amount, boolean, ..." error.
Formula: if {Task.Task_Date} = NULL then 1 else 0

In the screen shot, I only want to display the Task 1 record, which has a 1-1-18 date.
DesignReport
0
hi

I want to build a chart in crystal reports that will show 2 lines on a line chart for the different years for a set of data

Line 1 represents 2017
Line 2 represents 2018

the columns are the weeks for each year

see attached for a sample of the data and also a sample of how it looks in excel


thanks
Mike
sample.jpg
sample-excel-chart.jpg
0
Cloud Class® Course: MCSA MCSE Windows Server 2012
LVL 12
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Hello,

I am wanting to create a crystal report where a User can select various data fields from a table called PRODUCTS, (EG Product Code, Sales Info) then have a field to display the counted characters on the second field. So you would have:

Product Code     Sales Infor                           Counted Characters of Sale Info
ABC123                Is product is sold online    25

Can this be done?

Thanks.
0
Hi,

I've installed Crystal Report for Visual Studio on my Windows 10 laptop but it doesn't allow me to use the editor.

Hope someone can help me with my problem

thanks
0
Summary Crystal Reports--at the Group Level--counting if any records satisfy the criteria from the details section.  

In the details section, there is a field that is either "Y" or "N".  I've added a formula at the group level that states:

IF {FM_Influenza_Reporting.immunization_done} = "Y"
    THEN 1
ELSE  0

Open in new window


This appears to be working correctly when I run the report (see attached photo labeled E1).  

I then added a formula to the Report Footer section that is a SUM of my group count (the 1s and 0s as noted above).  See attached photo labeled E2.


The problem is--when that sum displays, it is showing a sum as though my formula is placed in the detail section instead of the group section.  So while I might have 145 unique patients that satisfy that question (i confirmed that number), it's displaying 348 (the total number of visits).  I'm not quite sure why due to me placing the original 'IF THIS THEN 1' formula in the group header section.

I'm open to a more elegant way of doing this--however when I attempted running totals, I ran into the same issue.  Crystal Reports 2013.

Thanks!
E1.png
E2.png
0
I am researching the best Reporting Programs out there to fit our needs.  I've used both Crystal Reports and Cognos - years ago (I know they've changed).
I need to be able to connect to our database and allow users to create their own reports.  Of course I would want to create some and publish those to our website.

Any recommendations on the best programs out there (that don't cost a fortune) to configure and get something out there for our users?  I don't need something that is going to take
me months to get reports available.
0
I need to reset a value at the change of a GH1 in Crystal Reports , but I cant seem to get the formulas correct
CrystalQuestion.docx
0
When I select "Export to Excel (Data Only)"  option For Export Report  Header is not Showing .
I have attach sample rpt file when i Select 'Details' Report Type then  showing Header in Excel but select 'Summary' then header is not showing.
Test-Rpt.rpt
test-rpt_Details.xls
test-rpt_summary.xls
0

Crystal Reports

34K

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
>