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

We have a piece of third party software that was recently updated, including updates to the SQL database.  We also have a Crystal Report that makes a call to a stored procedure in this DB and now the report fails because something with the sproc has changed and I don't know what.  

To start with, here is the piece of code that execs in the Crystal Report:

DECLARE @SDATE DATETIME = NULL
DECLARE @EDATE DATETIME = NULL
SET @SDATE = dateadd(day, -(datepart(dw, getdate()) + 7), CONVERT(date,getdate()))
SET @EDATE = dateadd(day, -(datepart(dw, getdate()) + 1), CONVERT(date,getdate()))

exec software.dbo.sp_test @StartDate = @SDATE, 
	@EndDate = @EDATE, 
	@LocationCSVList='398EMD5F-B4D0-4AD7-88D8-4RTC721875C9,DE50439F-42CA-4158-BB94-8D172F442D89,B669534F-C021-4D2B-8F0F-E54842C94D27,B40AE910-BD62-40CC-99A3-F065MM8C80B3'

Open in new window


When this executes against the sproc now, we receive an error that it's unable to convert the varchar value to data type int.

Here is the sproc as it stands now:

USE [software]
GO

DECLARE @RC int
DECLARE @StartDate datetime
DECLARE @EndDate datetime
DECLARE @LocationCSVList varchar(1000)

-- TODO: Set parameter values here.

EXECUTE @RC = [dbo].[sp_test] 
   @StartDate
  ,@EndDate
  ,@LocationCSVList
GO

Open in new window


I can't change the code for a sproc in a third party app DB, so how do I change the code I'm using in Crystal to still get the results I need and convert that data type?
0
Crystal Reports XI Release 2 - I have several parameter fields in a report that have different values the end user can chose from.  The report has worked for years. I upgraded the computer to Windows 10 and now when the user clicks on the parameter to see the entire list, the mouse doesn't do anything.  The user can use the down arrow keys to toggle through the list.  The fields are defined as String and the List of Values is Static.  

The computer is a Lenovo ThinkCentre - Model #.10M7000QUS.  Operating System is:   Windows 10 Pro version 1803.  This is specific to this model of computer, all other models are working fine.  It's not a mouse issues, I've tried many and it's the same issue.Any suggestions?
0
Can you help with a formulas
One that would include records where a field is blank
Another one, the opposite where the field is not blank

Gordon
0
I have a crystal report that summarizes telephone call data for a group of agents. The report works as is but I need to add a few more pieces of data to the report. The data is pulled from a SQL express table that has a list of telephone calls for all of the agents with the number that was dialed, date and time of the call, and call duration. The data that I need to add for each agent is the following

Most frequently called number (only for calls where the number dialed is longer than 3 characters)
Longest call: Call duration, Number dialed, Date and time

I have attached a copy of the current report. I am running Crystal reports XI.
0
I have a web site that creates reports using Crystal Reports 2008.  Currently I have no trouble creating a new .pdf each time a report is run.  However, my customer is asking to create one big .pdf file with a series of Purchase Orders in it.  So, I can create the .pdf for each PO individually, but I can't find an option to tell Crystal to Append instead of Overwriting.
Thoughs?

Thanks in advance,
Harold
0
Hi:

I made a copy of a Crystal report.  I needed to change this copy to point to a different SQL table than the other report.  I was able to use Set Datasource Location, to do so.

In the copied report, the connection now points to the table that I want it to point to.  But, in "Database Fields", the table name is the same as that of the "previous" table.

And, the "old" report continues to pull data from the correct table.

Really, both reports are pulling data from their correct respective tables. That's good.  

But, why does the copied report still display the name of the "previous" table?

Thanks!

Software Engineer
0
Hi
I have a report which I am trying to group by a formulae, but it will not shown in the group option (group Header #1
The formulae is Category
Also I want to sort the group Header #2 by the Sum of the Transactions.total
But again it does not show the option

Any ideas?
Have attached the report
Members-Bar-Spend.rpt
0
Ok, I have a report that outputs information about individuals one per page
I want to distribute this via email to the individuals, I know I could get some bursting and distribution software, but it is far too expensive. So looking for other ways.
My first thought is, can I add the email address as a link in the crystal report, I have some free software that woul burst a pdf file, which I could export from CP
Maybe then I could find something that could use the link to send the emails
All sounds very complicated!!
Anybody got any ideas?
Gordon
0
Does anyone know how to use logiciity to burst a crystal report report
0
I have created a subreport which passes a variable to the main report.  The subreport is the only item in the detail A section.   If I suppress the detail A section, it causes the shared variable to become zero.   If I don't suppress it, even though I suppress everything in the subreport, it messes up my line spacing with a blank line.  I'm assuming I'm missing something simple.   Any help would be appreciated.
0
I have written the following formula in Crystal reports. If {CnAttrCat_1.CnAttrCat_1_Description} = True then "" else {CnAdrSal.CnAdrSal_Addressee}. The problem is, when I view this information now, there are blank spaces when {CnAttrCat_1.CnAttrCat_1_Description} = True. Is there a way to supress these?
Thank you!
0
I am at the final stage of  getting crystal report to work

in my c# application.

I got to the stage of dragging the CrystalReportviewer to the Report Screen
but found out that the CrystalReportViewer is greyed  out (Not Active)  and simply
gives me a circle crossed red  when dragged  which does not get the viewer dragged

See attached screen below:

Crystal Report Viewer Greyed Out  . WHY ???
I believe i have followed all the steps by emoreau  except for the fact that this
time around my datasource is not inline but from a database

What do i need to do,  to get the Tools/Reporting/CrystalReportViewer  active and
selectable

Thanks

Olukay
0
I have this script below in my c# application
Its under a click button and its supposed to run a crystal report


[] private void button3_Click(object sender, EventArgs e)
        {
           
            var results = GlobalConfig.Connection.GetStateCode_All();
            CrystalReportProcessor processor = new CrystalReportProcessor();
            LoginDetails._dsData = processor.ToDataTable(results);

            DataTable dataTable = new DataTable { TableName = "stateorigin" };
            string strFullPath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "StateCodes.xsd");
            LoginDetails._dsData.WriteXmlSchema(strFullPath);
           
            _rptDoc.Load(System.IO.Path.Combine("c://TournamentTracker//ReportLibrary//StateCodes.rpt"));
            //Pass the dataset to the report
            _rptDoc.SetDataSource(LoginDetails._dsData);
           
            //Pass the Report Document object to the viewer
            crystalReportViewer1.ReportSource = _rptDoc;
         
        }[/code]

The first 3 lines executes without error and gets data from a table in database. (see previous post if required to see the data retrieved from database)

However when i got to the line   " LoginDetails._dsData.WriteXmlSchema(strFullPath);"below I got an error

See error screen below:

Error Screen while writing a Crystal Report
Grateful for your  help

Olukay
0
In Crystal Reports 2008  I have Crosstab simple layout where I present top 10 of manufacturers of 25 and totals of sold items.

Manufacturer             Number Of Items       Sold
R                  35                        
S                  22                        
C                  18                  
D                  16
N                  14
P                  12
M                  10
B                  9
A                  8
T                  6
TOTAL                  150
Total number of Items for those 10 manufactures is 150.

What I need is to add next column in my cross tab as percentage as below.
 
Manufacturer             Number Of Items       Sold       %
R                  35                        23.33
S                  22                        14.66
C                  18                        12.00
D                  16                        ...      
N                  14                        …
P                  12
M                  10
B                  9
A                  8
T                  6
TOTAL                  150
0
I understand that this is not easy to debug and help with but I'm posting some screenshots...hopefully someone can give me an idea where to look and how to do this...

(My first day of working with Crystal Reports and I'm not a CR developer )

1. The report looks like this. You see the tab "Main Report"? I want to add another tab but I don't know how this tab is built. I did a search in the code for "Main Report" and I don't find it. Did a search in stored procs and I don't see "Main Report". Did a search in our Web Services code and I don't see the word "Main Report"
EE-CR.png
2. The report itself looks like this and I see the file

EE-CR-2.png
3. This is the Windows Forms that's the container. Maybe I need to check all the User Controls but still....where is that tab coming from?

EE-CR-3.png
It's ok if no one can help.  I know it's hard to debug it without the code. I can ask my manager if it's ok to give the code and someone here could tell us how this all comes together.
0
Working on my first Crystal Report code. It was done by another developer and now I have to make changes to it.

The datasource is a stored proc. I added a new column.

How can I bind the column from the stored proc to the field? The other fields are already there. It's the Phone field I need to add.

EE-CR.png
0
Hello, can you please help me set criteria on the crystal form to suppress any line item from printing (in the body) if the quantity equals zero?
The form is attached with saved data.

Thank you.
PurchaseInvoiceDias.rpt
0
Error while publishing  report with dynamic cascade params in CR Enterprise  . Error:The server with kind rptappserver returned an error result. Failed to copy the report file to the report object. Refreshing the report object properties might have failed. Failed to read data from report file . Reason: Failed to read parameter object

Report runs OK in developer .  Also  when first published, ensured "Update Repository" box on the Save As is selected. User is added to admin group as last resort.No effect.
Also
-Verified the database

- File--> printer-->Ensured 'No Printer' is checked
Restarted RAS server and also all the servers . Since this did not fix, when to CCM and restarted Apache TOmcat & application servers.
What could be the soluction ? CR enterprise  BO 11 4.1 . BVM isn't available because its CR enterprise ?
0
I'm working on a Windows Forms application/desktop written in 2002. Yes, you read that right.... Windows Forms that uses Crystal Reports.

We can't upgrade the code to web at this time. Too many clients on it and the owner doesn't want to invest in a web application.

We want to replace the Crystal Reports section of this application.

These are some of the options we've been talking about:

1. SSRS (a developer here said SSRS is being replaced)
2 . Power BI - how would this work with an old code like the one we have?
3. A developer here said we can write the stored procs and have one of the web developers design and code the pages. Custom web pages that act like reports. Don't think we can do this because clients are not setup for web. They all use our desktop application.

A developer here is pushing for Power BI. I don't know how it would work with Windows Forms/desk top.

Any ideas?
0
I am trying to rebuild a computer that crashed.  The old computer was Win7 Pro, new computer is Windows 10.
I had a couple of versions of Crystal Reports as well as Visual Studio 2005 and Visual Studio 2010.  I have re-installed these (CR XI, CR
I was able to save all the data files, including all the source code for all the projects I was working on but had to re-install apps/compilers/etc.

When I open VS2005 to be able to modify/re-compile an app that worked on the old computer, I get this error:
Warning      1      Cannot load type library for reference "CRAXDRT". Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))      CD_Main

in trying to research the issue, it seems that the problem is that I need to register the Craxdrt.dll.  (not sure if this is the real solution or not).

I opened a cmd window in Administrator mode and changed directory to the path where the .dll file is (c:\Program Files (x86)\Common Files\Business Objects\2.7\Bin)
I type "Regsvr32  craxdrt.dll" and I get this message:
The module "craxdrt.dll" failed to load.  Make sure the binary is stored at the specified location... The specified file could not be found.

I did a "dir" and it shows the craxdrt.dll file.

Suggestions?
Thanks!
1
Hello,

I am trying to join two tables and I am not sure if I wrote the command right.

  SELECT "PRT_CURRENT__TIME"."Period_End_Date", "PRT_CURRENT__TIME"."Units", "PRT_CURRENT__TIME"."Pay_ID", "PRT_CURRENT__TIME"."Job", "JCM_MASTER__JOB"."Description", "PRT_CURRENT__TIME"."Amount", "PRT_CURRENT__TIME"."Employer_Taxes", "PRT_CURRENT__TIME"."Fringes", "PRT_CURRENT__TIME"."Cash_Fringes", "PRM_MASTER__EMPLOYEE"."Employee_Name", "JCM_MASTER__JOB"."Cost_Account_Prefix"
FROM   ("\\TEST\Timberline Data\TEST\"."PRT_CURRENT__TIME" "PRT_CURRENT__TIME" INNER JOIN "\\TEST\Timberline Data\TEST\"."JCM_MASTER__JOB" "JCM_MASTER__JOB" ON "PRT_CURRENT__TIME"."Job"="JCM_MASTER__JOB"."Job") INNER JOIN "\\TEST\Timberline Data\TEST\"."PRM_MASTER__EMPLOYEE" "PRM_MASTER__EMPLOYEE" ON "PRT_CURRENT__TIME"."Employee"="PRM_MASTER__EMPLOYEE"."Employee"
WHERE  "PRT_CURRENT__TIME"."Period_End_Date">={d '2019-12-12'} AND "JCM_MASTER__JOB"."Cost_Account_Prefix"='20'
ORDER BY "JCM_MASTER__JOB"."Cost_Account_Prefix", "PRT_CURRENT__TIME"."Job", "PRM_MASTER__EMPLOYEE"."Employee_Name"
 UNION
 SELECT "PRT_EXECCURENT__TIME"."Period_End_Date", "PRT_EXECCURENT__TIME"."Units", "PRT_EXECCURENT__TIME"."Pay_ID", "PRT_EXECCURENT__TIME"."Job", "JCM_EXECMASTER__JOB"."Description", "PRT_EXECCURENT__TIME"."Amount", "PRT_EXECCURENT__TIME"."Employer_Taxes", "PRT_EXECCURENT__TIME"."Fringes", "PRT_EXECCURENT__TIME"."Cash_Fringes", "PRM_EXECMASTER__EMPLOYEE"."Employee_Name", "JCM_EXECMASTER__JOB"."Cost_Account_Prefix"…
0
I am trying to create a new definition for 'previous month' from a dropdown parameter selection. The typical solution = 'LastFullMonth' but I need it to be from the first day of the previous month 03:00:00am to the first of the current month 02:59:59am
0
I need to create a Virtual calendar that defines starting and ending hours different to a standard day. A standard day, today, for example, December 20, 2019, started from 00:00:00 to 23:59:59. The new virtual 12-20-2019 should start from 12-19-2019 03:00:00 to 12-20-2019 02:59:59.

The month of November should include 11-01-2019 03:00:00 to 12-01-01 02:59:59 and each day should be defined as above with the exception of the 1st which always starts from 03:00:00 and the 30th includes the 3 hours of December 1st.

The year (2019) should include 01-01-2019 03:00:00 to 01-01-2019 02:59:59 with the months and days defined as mentioned above.

Even though I'm using Crystal reports it probably would be easier creating the mentioned in SQL.
0
I am trying to create a dataset which I will  then will feed into crystal report
with the script below

[private void button2_Click(object sender, EventArgs e)
        {
       
            CreateDataSet2();
            // MessageBox.Show("The dataset is created and filled");

            if (_dsData == null)
            {
                MessageBox.Show("You first need to create the data source");
                return;
            }

            string strFullPath = System.IO.Path.Combine(System.IO.Path.GetTempPath(), "StateCodes.xsd");
            _dsData.WriteXmlSchema(strFullPath);
            //MessageBox.Show($"The schema has been created as >>{strFullPath}<<");

            //Load the standalone report
            // c://TournamentTracker//ReportLibrary//StateCodes.rpt
            //_rptDoc.Load(System.IO.Path.Combine("c://DotNetReports//StateCodes.rpt"));
            _rptDoc.Load(System.IO.Path.Combine("c://TournamentTracker//ReportLibrary//StateCodes.rpt"));
            //Pass the dataset to the report
            _rptDoc.SetDataSource(_dsData);
            //Set values of some objects dynamically
           // ApplyTextObject("txtTitle", "Title of the report provided dynamically by the application");
            //Set the values of the parameters
            //_rptDoc.SetParameterValue("PopulationThreshold", 5000000);

            //Pass the Report Document object to the viewer
            crystalReportViewer1.ReportSource = _rptDoc;…
0
We have been using Crystal Report within our company for several months now with excellent results.    We are also using the Datalink viewer on many of our employees desktops.

Our weak link is exporting these reports into Excel.     Lots of extra columns and rows are inserted during the export and columns and rows  just don't line up well.   Are there any tools out there that would do that better?
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
>