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 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
I have a report that totals up sales, inventory change, spoilage and waste from general ledger database table.  It is grouped by district, then by store(glm_prft_ctr).  The users want to pick which column on the report to sort by in the store group.  I cannot find a way to make this work.  Clearly I'm missing something... I tried this:
 Select({?Sort})
Case "C-Store Sales" : Sum ({@C-StoreSales}, {Command.glm_prft_ctr})
Case "Total Loss" : Sum ({@TotalLoss}, {Command.glm_prft_ctr})
Case "Loss%Sales" : {@PC-Loss%Sales}

but this is not available as a field to sort on, or to group on.
0
I have the following error in Visual Studio 2012 Crystal reports:
"Unable to find the report in the manifest resources"

Can someone help?
0
Need help with a Crystal Formula. I would like to get the details line shown in red to summarize the quantity shipped when the lot number is the same, regardless of the bin location (shown in black next to it). I tried adding a group for the Lot Number, but then it messes with the quantity shipped per Line Seq. Maybe this is best handled by a conditional suppressio formula?

Example attached.
Scan.pdf
0
I'm trying to use the Running Totals in Crystal Reports 8.5 to get the minimum value of a series of fields.

Ex.:

A - 500
B - 300
C - 400


I need to get the B - 300 line.

Is there anyother way to figure this is out without using the Running Totals?

Thanks in advance
0
Is there a way to keep the entire Details section on a Crystal Report tied to a specific group header so that the details for a specific record will not split on to 2 pages.

However, have this happen without choosing the Paging option on the Group to begin a new page after each group change.
0
I have a report made in Crystal Reports 8.5, and in the last two pages I have two graphics showing some data. The problem is: I can see the graphic in my computer, but my users cant.

Can You guys help me?
0
Crystal Reports 2016
MS SQL

The problem I have is a formula that produces blank results along with the appropriate value.  You can see the blank spaces as  highlighted blue lines.  See image 1
Image 1  

In this example I am looking at a specific record.  In the finalized report I will be looking at records based on dates.  But to simplify this example I am using a specific test record.

Record Selection Formula:
{CivilPMaster.CivilPYear} = 2018 AND {CivilPMaster.CivilPID} = 241

The formula I used to display the Plaintiff's Name.  

Formula: Plaintiff
IF {CivilPPersons.Involvement} = 'PLAINTIFF'
THEN {CivilPPersons.Name} & ', ' & {CivilPPersons.Given1} & ' ' & {CivilPPersons.Given2}

Table: CivilPPersons

CivilPYear int
CivilPID int
Sequence int ( Not Really Needed just using for reference.)
PersonID int ( Not Really Needed just using for reference.)
Business char ( Not Really Needed just using for reference.)
Name varchar
Given1 varchar
Given2 varchar
Given2 varchar
Involvement varchar

Here is a view of the sql results in manager.

Sample CivilPPersons Table
The number of lines both with data and blank corresponds with the number of lines shown in the sql results.  Is this coincidence?
0
I have a sales report that in addition to supplying the sales numbers it also:
Calculates and Displays how many Business Days are Remaining in the current month.
This is accomplished by:
(@REMAINING DAYS - @HOLIDAY_REMAIN)

In December we have two holidays 12/24 and 12/25.

If I run this report today (12/03) these values are as follows:
(@REMAINING DAYS = 20 - @HOLIDAY_REMAIN = 2) = 18 business days left in the month.  This is correct (Today doesn't count).

If I run this report on 12/26:
(@REMAINING DAYS = 3 - @HOLIDAY_REMAIN = 2) = 1 business day left in the month.  This is incorrect it should show 3 days remaining... @HOLIDAY_REMAIN should = 0

@HOLIDAY_REMAIN
//Main formula
WhilePrintingRecords;
Local DateVar Start := {@FirstDay};
Local DateVar End := date(dateadd("m", 1, {@FirstDay})-1);
Local NumberVar Weeks;
Local NumberVar Days;
Local Numbervar Hol;
DateVar Array Holidays;

Weeks:= (Truncate (End - dayofWeek(End) + 1
- (Start - dayofWeek(Start) + 1)) /7 ) * 5;
Days := DayOfWeek(End) - DayOfWeek(Start) + 1 +
(if DayOfWeek(Start) = 1 then -1 else 0)  +
(if DayOfWeek(End) = 7 then -1 else 0);  

Local NumberVar i;
For i := 1 to Count (Holidays)
do (if DayOfWeek ( Holidays[i] ) in 2 to 6 and
     Holidays[i] in start to end then Hol:=Hol+1 );

Hol

How might I adjust this formula to account for the holiday as it occurs and after it occurs?
0
I have a report with 3 layers of grouping, I have instances where the GH2 only has one totaled rate with a group total below it (GF2). This makes the report look redundant having the GH3 and GF2 with the same values below each other. I'm trying to suppress GH3 if GH3 only has 1 row. Grouping as follow: GH1 - Facility (does not concern me), GF2 - totals of GH3 (I'm suppressing some GH's to avoid cluttering the report), GF1 - Grand Totals

Please see attached screenshot:

Grouping
0
Hello,
      I have a field on a Crystal Report that I would like to show text if the field returns a certain entry. What I mean is I want the report to to have the field read NO COMMIT if the data in that field is 12/31/1899. I used this formula but got errors.

if {tcspodet.ppromtxt}  = 12/31/1899 then "NO COMMIT" else {tcspodet.ppromtxt}

It says a string is required here.
2sql_query_tactic.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
>