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'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
I have an issue with the link between VB.net and Crystal reports.

I want to produce an invoice for a customer.  I have produced the invoice on crystal reports and I have produced all data needed on VB.net but how do I send information from VB.net to Crystal reports.  Obviously I need to pass data per invoice number and client using the software. example companycode ="XC029" invref = "1500"

       Dim directory As String = My.Application.Info.DirectoryPath.Replace("\bin\Debug", "").TrimEnd()
        Dim cryRpt As ReportDocument = New ReportDocument()
        Dim InvRef As String
        Dim showMsg As Boolean

        cryRpt.Load(directory & "\rptSalesInv.rpt")
        InvRef = txtSIInvRef.Text
        cryRpt.RecordSelectionFormula = "{vwSalesInvDistinct.InvRef} = '" & invRef & "'"

        Dim crtableLogoninfos As New TableLogOnInfos
        Dim crtableLogoninfo As New TableLogOnInfo

        Dim CrTables As Tables
        Dim CrTable As Table
        Dim s As String = ConnstringSQL

        Dim parts As String() = s.Split(New Char() {";"c})

        Dim crConnectionInfo As New ConnectionInfo()
        With crConnectionInfo
            .ServerName = parts(1).Split(New Char() {"="c})(1)
            .DatabaseName = parts(2).Split(New Char() {"="c})(1)
            .UserID = parts(3).Split(New Char() {"="c})(1)
            .Password = parts(4).Split(New Char() {"="c})(1)
            .IntegratedSecurity = False
        End With

        CrTables = …
0
Hi there,
I have a parameter where the use chooses a numerical range and if the report, I want to suppress the group base on whether or not the number falls within the range.

My suppression formula is
Not (sum({@# Courses}) in {?Select Range for Number of Courses Taken})

But when I run the report, it suppresses every record regardless of what I enter - do you have any ideas on why it isn't doing this or, if it's possible?

thanks in advance - CS
0
I have a crystal report that has a field 'placement area" .  When I browse it I can see data.  But when I added it to a report it does not show data?
0
I have a report with the number field {QUARTWAGE.PAYROLL_YEAR}.  I need a formula so that whenever the report runs it picks up only data for the CURRENT Year.  I would appreciate your assistance.
0
I am creating a report in Oracle Developer and usually do not like to add my Schema name to each line in my From Clause for each Join. HCCLSC.Pat_enc so in Oracle Developer I can use ALTER SESSION SET CURRENT_SCHEMA=HCCLSC


and this defines the schema so I do not have to add it to each line of my From Clause.

My question is, how do I use this code in Crystal Reports? Is there a way to setup the SCHEMA without having to add it to each line?  We have switched from Teradata to ExaData.

 FROM HCCLSC.pat_enc pat_enc
        LEFT OUTER JOIN HCCLSC.patient
                ON pat_enc.pat_id  = patient.pat_id
0
Have a report that I would like to put the totals into a cross tab sheet
Need some help

Gordon
WO-Stats_JV1.rpt
0
Group Sum not working
Please see attached report
The sum of the BD should be 10 not 8391
Not sure what is going wrong
WO-Stats.rpt
0
Crystal Reports 2016

I am using the standard grouping by field in my report.  However I would like to actually combined several fields to fall under one specific group.  How would I go about doing that.

Field to group by.  A, B, C, D, E, F


Example:
                       Group: A
                           Detail A
                       Group B
                            Detail B
                       Group C
                            Detail C
                       Group (Contains D, E & F)
                            Detail D,E,f
0
I added five new formulas to a report (Daily_Dosage3b) and the results of the original three formulas on the new
report are different than on the original report (Daily_Dosage3a) that has only the original three formulas. Please
help me resolve the error. Why do the original formulas have a different result on the new report (Daily_Dosage3b)?

New formulas:
LowerTestResult = global numbervar LowerTestResult;
if {Test_Date.TestDate} = {?From Date} then
LowerTestResult := LowerTestResult + {Aspirin_Test.Reading};
LowerTestResult

UpperTestResult = global numbervar UpperTestResult;
if {Test_Date.TestDate} = {@ToDatePlusDay} then
UpperTestResult := UpperTestResult + {Aspirin_Test.Reading};
UpperTestResult

ToDatePlusDay = DateAdd (“D”,1,{?To Date})

TestResultDiff = {@UpperTestResult} - {@LowerTestResult}

Original formulas:
testAverageDosage = if not({@testDosageCount}=0) then {@testDosageAmount}/{@testDosageCount}
else 0

testDosageAmount = global numbervar dosageAmount;
if {Test_Date.TestDate} >={?From Date} and {Test_Date.TestDate} <= {?To Date} then
dosageAmount := dosageAmount + {Aspirin_Dosage.Dosage};
dosageAmount

testDosageCount = global numbervar dosageCount;
if {Test_Date.TestDate} >={?From Date} and {Test_Date.TestDate} <= {?To Date} then
dosageCount := dosageCount + 1;
dosageCount
Daily_Dosage3aDaily_Dosage3bDaily_Dosage3a.rpt
Daily_Dosage3b.rpt
0
Crystal Reports 2016 SP4

I wish to display a count of records based on a certain criteria at the Top of the report before the detailed listing.  Is it appropriate to use the Count() function to accomplish this.

SQL Columns

Location   Trustee
A Block          N
A Block          Y
B Block          Y


So in this case I wish to display the count of  all Records where Trustee  is "Y".

Count of Trustee:  2
0
I have created a report that runs as planned in crystal reports 2016 SP4 and through the proprietary software using  Crystal Reports runtime 2008 SP5.  On another computer using the proprietary software using  Crystal Reports runtime 2008 SP5 the report will give me different data each time it is run.  When I first ran the report it showed only data where all the linked fields matched, which is not correct( attached file called incorrect.pdf.)  Then I ran it again and it gave me the correct information,(attached file called correct.pdf).  
The report has 6 tables Customer, Sales rep, Order, Dr, and customer type and are left outer joined, not enforced from customer to the other tables.

The Data base is MySQL

It is the same report  Incorrect ran first, then ran correct right after and different results.  
incorrect.pdf
correct.pdf

Thanks in Advance
0
I need help with doing a Crystal Reports Label. I have messed with this so much this morning and cannot seem to get this to print as I need. I get one label print and then it spits out 7 additional labels. If someone can help and attach a file with the 3 basic values (I can rewrite my SQL) for this dimension, I would forever be grateful. I just need it to print one label and it keeps printing the additional labels.

The Zebra Label Printer is LP2824 Plus.
https://www.zebra.com/us/en/support-downloads/printers/desktop/lp-2824-plus.html

The label dimension is 2 and 1/4 by 1 and 1/4.

I need on the label the following:

Name
Address
City State Zip
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
>