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 table of records where one of the fields is a date and time. I need to create a report in Crystal Reports XI that will show how many records there are where the date and time falls into each of a 24 hour time period for each day during a specific date range which will be determined using a parameter. i.e.

2/1/2019
00:00 - 00:59 = 0
01:00 - 01:59 = 5
02:00 - 02:59 = 2

2/2/2019
00:00 - 00:59 = 0
01:00 - 01:59 = 1
02:00 - 02:59 = 6

etc...

I need to show all 24 time periods for each day regardless of whether there are any matching records or not. I would like to show a list of the values for each time period as well as a chart that shows the counts graphically.

Any ideas how I should setup this up in Crystal reports?
0
Running Crystal Reports XI on a stand alone, Windows 10, 64 bit PC. I create a very simple report & try to save it. But I'm getting an error - File Not Found. Check the file name & try again.

I've tried doing a fresh install of Crystal on a different PC. I've tried using a different ODBC source. I've tried unticking Save Data With Report.

I get the same error whatever I call the report or wherever I try to save it.

Screenshot attached.
CrystalSave.PNG
0
I am working on a VS 2008 application.  It was copied from one server to another.  In the original server I was able to open up the Crystal Reports rpt file and make changes to it.  Now, when I open it I get below.

How do I fix .NET to view the rpt with Crystal Reports?

I've installed CRRedist2008_x86.msi and CRRedist2008_x64.msi
CrystalReports.JPG
0
Hi, I have a labor report that I run using "FROM" and "TO" dates as parameters. Is it possible to eliminate weekends?
0
Hi All.

Don't know if this is possible but going to give it a shot. We have a SQL table, myTable, that stores item numbers and descriptive information for item numbers:
Table fields: ItemNumber, ProductLine, ProductLineAppearOnReport, Height, HeightAppearOnReport, Width, WidthAppearOnReport, Color, ColorAppearOnReport, UnitOfMeasure, UnitOfMeasureAppearOnReport

As you can see each field has a "AppearOnReport" that will either be Yes or No.

We want to create a Crystal Report that will list the ItemNumber and only the fields that have the "AppearOnReport" equal to YES. The problem is that each item number will be different because some items we don't want to display the Height and Width on the Report while others we do. The problem is we don't want to display a blank where the field would display data if it was set to YES.

So for example, let's say we have item ABC (has ProductLineAppearOnReport = YES and ColorAppearOnReport = YES), item DEF (only has UnitOfMeasure = YES ) and item GHI (HeightAppearOnReport = YES and WidthAppearOnReport = YES) here's how the data should appear on the report:

ABC--ProductLineA--Blue
DEF--Box
GHI--12 feet--10 feet

As you can see there is no blank space where ProductLine or Color would be if it was set to YES for item DEF and the same for item GHI

Any idea if this can be done?

Thank you in advance!
0
I am working with Crystal and working with parameters definitions.  When I link the params together I only see 2 of the 10 values for the INVBWHSNCODE?  Not sure where to look and how to solve this issue.    
I pulled the data apart so I know the data is correct...   Would it be hitting a limit of some kind?
Please see screen copy.
Any help would be appreciated.
Thanks
Terry
CrystalParams.jpg
0
Crystal Reports Calculate and display date 9 days ago.    the formula below works but only within the same month.    Can't figure out why.     So if today minus 9 days stays within the current month it works.     But as in todays date of Feb 4th.    9 days ago is a date in January the formula does not work.

numbervar DATEFROM2;

DATEFROM2 := tonumber(totext(CurrentDateTime, 'yyyyMMdd'));

DATEFROM2 := DATEFROM2 - 9;

pwformatdate (DATEFROM2)
0
A Crystal Report no longer prints from a VB6 program running on Windows 7 after the most recent Windows Update.  The error = 20534 Error detected by database DLL.  

Another VB6 program running on the same computer with similar type reports prints fine.

The Windows Update was KB4480970.

Does anyone have a recommendation to correct the issue?
0
I have a number of Crystal reports from the same VB.net program that are not accepting / transferring / referencing the database details for the connection.  Attached is the screen shot of the error message and the code that is used to populate the connection.

Can someone please shed some light on the issue?
DBConnection.PNG
DBCode.PNG
0
I have created a formula to include a full address, which works ok
Have the added it to a group called @fulladdress and done a sort on this, seems to work ok, but:

For some reason it is only showing unique @fulladdress records rather than duplicates
The suppress duplicates is not ticked
I guess it has something to do with The section will be printed on change of address, in the Change Group Options
Not what I am looking for, need to see the duplicated records

Any Ideas

Gordon
0
I have a report where the print order as determined by the A-Z criteria says:

Group#1:@Full Name -A
A-@FullAddress

I would like to change this to read with the @FullAddress first
But it will not allow me to change the sort order

On the report I have created Group Header#1a with the @Fulladdress in
and Group Header#1b contains the @Full Name

How do I do this?

Gordon
0
I'm working with a VB6 program that uses Crystal Reports 8.5 on various Windows Operating Systems.   The program and reports have been operating for many years until a Windows Update this past week.  The error occurs when trying to open a report to view or print "Error = 20534 Error Detected by Database DLL".  This only happens with Windows 7.  Same program on Windows 10 is not affected.


Removing updates KB4480960 and KB4480970 corrects the issue.  Our concern is these Windows Updates will update again shortly.  So, my two questions are:


1)  Is there a way to not have these specific Windows Updates update the computers?

2)  Do you have an idea on what the conflict is where we can update something with the program or an associated file?
0
I have a crystal report that does not contain any groupings.

I am trying to add in a field to my report that is causing the report to print numerous additional pages. Is it possible to add to concatenate the values into a string at report print time and have it not grouped? I hope this makes sense and based on the responses, I can provide more details.
0
I want to be able to group the unitCost value by increments of amount value in 5 in Crystal Reports 2008.
How is this accomplished?


Example:

Group 1
Item ID      Unitcost
AB123        1
AB124         2
AB125        3
AB126        5

Group 2
Item ID      Unitcost
CD123      6
CD124      6
CD125      7
CD126      10

Group 3
Item ID      Unitcost
CE123       11
CD124      12
CD127      14
CD128     15

Please help. Thanks.
0
Hi
When I export a report as a PDF document it gives me an extre “t” where there is a t in the text
An example would
The word text would then read ttextt
Any ideas?

Gordon
0
Have the attached crystal report where it list several emails for same supplier code.  I need formula to combine into one for same supplier code.

Example:  
supplier 60008   contact1  matt@gmail.com
supplier 60008  contact 2  john@gmail.com
supplier 60008 contact 3  mark@gmail.com

Desired output:   matt@gmail.com, john@gmail.com, mark@gmail.com
Daily_Supplier_Email.rpt
0
Is it possible to create several pdf files for a Crystal Report
Ok, have a report that creates data for each person, would like to export the data to individual pdf files which I could then distribute.
If possible would like to know how to do this

Gordon
0
I have a report from a database with 400 odd names
I would like to be able to email idividually all the people with the individual report, but do not know If it is possible, and if so, how to set this up

Gordon
0
I have a report where I have created a parameter with several membership types. Have added this criteria to the record selection.
when I run the report I get data for all the membership types except where the type begins with the word Junior
there are several formula in the report, have deleted each one in turn from the report but it still does not work for this group
have checked the group selection expert part, does not seem to be an issue.
Do not know where the problem may lie?
0
What is wrong with this?
if ({@DBSCheck}) = 'No' then 'NA' else ({MembersDetails.DBS Expiry Date})

it says a string is required after else
0
I am running a Crystal report inside of BOE - and having it store in a file location as a CSV file.

The report has one header row and one detail row.

However, when the file extracts, it extracts the header row once for every detail row.
I only want the header row to extract one time.

Does anyone know how to do this?  I have attached samples of setup and final results.

Becky
design_VIew_Crystal_Report.JPG
Export_Format_BOE.JPG
File_Destination_BOE.JPG
Testing_01082019.xls
0
I had this question after viewing How to Save Database Connection info with Crystal Report Version 11 for Use on Business Objects Server.

I have a Crystal Report v 11.5ish that I want to send to a conversion company but I'd like to delete the Database information for security reasons.  However, when I try to delete it or replace info with junk, it attempts to make the connection and then fails.  How can I remove those details?
0
I'm trying to use Crystal Enterprise to pull data from a secured database, format it into a CSV file, and then FTP it to a server for a separate program to pick up and run with.  However, the filename needs to be in a certain format:

"Discharges_20190102.csv"

I know that to get a date in the filename, I'd need to use something like this:

"Discharges %SI_STARTTIME%.%EXT%"

However, the date isn't in the correct format.  Is there a way to custom format the date or is there an option I'm missing?

My research shows this has been an ongoing problem with SAP Business Objects/Crystal Reports since before 2008.  

Have they gotten around to updating this and providing ALL of US a solution?
0
Hello experts,

There is an issue in printing records in sub-report. I have explained my query in detail in attached file.



Please help.

Regards,
D Patel
0
Hello, the attached Crystal Report sorts by Qty (High to Low)
I then want it to sort by the first column; Product Code so all the similar codes are grouped together but I'm having trouble.
Are you able to help? The report is saved with data.
Than you.
SalesByProductByCustomerSummaryQtySo.rpt
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
>