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 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
I have a report that has a group by region. The first group and details extends to 2nd page but I want to have 2nd page blank and want to have it printed on 3rd page. I need to print on an odd page on a one-sided special paper (I must not print on back of special paper ). Means, my first page should print on special paper page1, extended group should print on page3. Another new group should start on page5 of special paper since page 4 is blank.

Means, I need to print page1, page2 blank, then page3, page4 blank, then page5. I also need to print every new group on a new page.

I cannot control from Visual studio programmatically. Please advise it from Crystal.

I tried lot of things already, Added this formula too. Nothing worked. Please help.

Remainder(PageNumber,2) <> 1. Thanks in advance.
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 create a crystal report. I have customers, work orders and the date enter for that work order. I am trying to show the new customers in past 3 years. I can't just exclude date enter below 2015 and show customers above the year 2015. if a customer been using us from 1990 and still using us will also appear if I exclude date enter below 2015. since some work orders are there for that customer after 2015. I want to see the minimum date enter and exclude those customers whose minimum date is less than 2015.
 Problem with that is I can do filters on summarized values like sum, max, min in the crystal.
Is there any other approach for this?
0
I need to extract the ten spaces after MAGNESIUM ALLOY: from the comment text field. Below is an example of one record from the comment text field.

Plate Number: 1                                                      
MAGNESIUM ALLOY:         Type: 6% Mg Fe- Si                          
SILICON RAISER:          Type: Low Ca & Al - 75% FeSi                
IN-STREAM INNOCULATION:  Amerinoc        SETTING:   5 (gram/sec.)    
TEST BAR REQUIREMENT: Daily
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've created a report in Crystal reports Developer 11.5 that includes a few grouping levels, in case this makes a difference...  I have one column of data that happens to exist in grouped data that displays in CR print preview but does not print on the physical report.  This data did print at one time but has not been printing for some time.  Not sure when it actually stopped.  I included a screenshot of my design view to show as example.  Red square shows column of data that shows up in preview but not on actual report.   What might be  causing this?
CRRpt_0518.docx
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
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
LastDate04/16/1804/23/18LastTime5327834142LastUserTGIBBRMPCOMHERRRMPCOPkgcode26

Need to split the above string field into multiple records:

LastDate 04/16/18 04/23/18
LastTime 53278 34142
LastUser TGIBBRMPCO MHERRRMPCO
Pkgcode  26
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
Crystal Reports Data Connection.  I have 2 tables (Dynamics GP in SQL) in the same database one the Current Year (GL20000) and the other the History Table (GL30000).  I need to pull them onto the same report to do percentage comparisons.  I have another table that is being used for each of them that has the description information for the Location.  I can seem to get this setup properly.  I get the Current all setup and it brings over the data I expected.  Then I pull the summary field over to the report for the History and it severely distorts the numbers.  Causing records to be counted several times?  Please help me figure this out...hopefully without using a subreport.

Thanks
0
Hello Experts,

I have a problem with deploy a desktop application in a  client machine without installing crystal reports or visual studio.

I searched on the internet and i find a lot of suggestion , but i can't find the correct way ( i can't find the files of runtime for crystal reports)

Thank you.

Regards,
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
Testing for dataset changes on form closing in WinForms 2015.

   
    If DS.HasChanges Then
            ChangesMade = True
             'Call Option to save code
        End If
        For Each dr As DataRow In DS.Tables("tCARDS").Rows
            If dr.RowState <> DataRowState.Unchanged Then
                ChangesMade = True

            End If
            If dr.HasVersion(DataRowVersion.Proposed) Then
                ChangesMade = True
            End If
        Next

Open in new window

The trouble is that when the user moves between datarows using a datagridview or bindingnavigator the Dataset is marked as changed.  It also shows the rowstate as being modified when it isn't.  The user isn't changing anything just navigating amongst records.  I'd like to figure out how to check for any true changes rather then getting the false positive?

Any ideas?


Thanks
0
I have a crystal report, which is connected with a stored procedure in a database.  My question is , if I change something in the store procedure without changing its input parameters, do I have to re-connected the crystal report to the stored procedure ?  I did a simple testing, i.e. change the stored procedure and then simply run the crystal report , it seems that the changed contents in the store procedure showed in the report.

Thank you in advance!
0
How to convert the existing old version of crystal reports to crystal reports XI..
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
The form is successfully loaded and reports are easily printed on Windows Vista win32.

Now, the client has bought a new computer; it has Windows 10 win 64, of which she wishes to use the form on.

I copied the whole folder to the new computer and I got the attached debug error.

Kindly assist.
Debug.docx
Labour.mdb
0
try
            {

                string pdfFile = "c:\\ccReportExport\\CrytalReport.pdf";
                ReportDocument cryRpt = new ReportDocument();
                cryRpt.Load(@"C:\ccReports\Invoice.rpt");
                cryRpt.SetParameterValue("InvoiceComments", "");
                cryRpt.SetParameterValue("InvoiceNumber", "11111");
                cryRpt.SetParameterValue("AccountNumber", "22222");



                ExportOptions CrExportOptions;
                DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
                PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
                CrDiskFileDestinationOptions.DiskFileName = pdfFile;
                CrExportOptions = cryRpt.ExportOptions;
                {
                    CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
                    CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
                    CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
                    CrExportOptions.FormatOptions = CrFormatTypeOptions;
                }
               
                cryRpt.Export(CrExportOptions);
}  

Error: "Database logon failed."

Stack trace:

at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
   at …
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 2016
SQL 2017

I am using individual running totals that are based on a value called "Categories" that are used to count all matching records for the category.  The issue I have is a customer can have any number of categories and that means each of them would need a customized report just for them.  What I want to do is have the running totals dynamically change based on the number of "Categories"


Example Categories found in

Customer A:  Database                     Customer B: Database

{ListFruit} = 'Apples'                           {ListFruit} = 'Apples'
{ListFruit} = 'Oranges'                        {ListFruit} = 'Oranges'
{ListFruit} = 'Cherries'                        {ListFruit} = 'Grapes'
{ListFruit} = 'Grapes'

So the display would look like this.

Apples    100                                        Apples       20
Oranges   40                                        Oranges      2
Cherries    20                                       Grapes    100
Grapes        6

As you can see above Customer B does not display any running total for the category Cherries because that category does not exist in their database.
0
Crystal - Need to return all data that is Left, 6 of the string.

Example:  227800kc04142

I want to return "KC04142"

I have found several MID functions but non based on length.
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
>