Crystal Reports

34K

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

Hi

I am converting seconds to hh:mm:ss from seconds (CR2016)

I usually use the formula below which works fine for anything under 24 hours

CStr(CTime(currentfieldvalue/ 86400), "hh:mm:ss")

I have a few fields that go above 24 hours, so for 25:00:06 - this reads 01:00:06.

I have tried

 CStr(CTime(currentfieldvalue/ 3600), "hh:mm:ss") - doesnt work

Any ideas on how this can be used for anything over 24 hours

Thanks
0
Free Tool: Port Scanner
LVL 12
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I am trying to parse a Full Name field into First, Last, & Middle Initial in Crystal Reports.  I am able to get the Last name, but am having issues getting the first & middle initial.  The issue lies in the data. (And my lack of knowledge).  The data looks like:

Smith; John
Smith; John D.
Smith; John D
Smith; John David

I was able to parse the last name, but I am unsure how to get the first & middle separated.  I can get them both, but I can't figure out how to get them separated when the data is inconsistent.  
Any help would be greatly appreciated!  Thanks!
0
What is the best way to configure my database connections to maximize the speed when refreshing the report. currently, to return 15 records it is taking 15 seconds. I expect this should take much less time like many other reports I have.

I am connecting to 3 dbf tables using the odbc (rdo) connection. see attachment showing the database expert configs in crystal reports 2013.

How else can I organize my connections to make the report run faster?DB-expert-configs.docx
0
Unable to successfully locate step by step instructions to create a publication or Burst Report in Business Objects Launch pad 4.1
Have tried numerous times (using the previous set up on 3.1 which is successful as a guide).  The Burst report in 4.1 continues to fail.
I'm not able to understand the log file completely in order to troubleshoot to resolution.  The crystal report runs successfully, the parameters are correct.  

I would be grateful to receive assistance in interpreting the error log file.  Step by step instructions to set up a Publication Burst report from scratch would be helpful too please. I am not the system administrator but working closely with the System Administrator to successfully set this up.  When the System administrator executes the burst report, they receive a failed run also.  The burst report is extremely important and without it, I would not know how to make it happen.  Thank you so much in advance.  I have been working with the System Administrator for months and I'm hoping to be steered in the right direction.  I have been able to create a Burst report from scratch using a working version in 3.1.  The System Administrator was able to create a server group where we thought that was needed and after referencing the server group, we still have failures.  Any and all assistance is appreciated.  Thank you.

 Publication-Admin-Log-1---618106.logRecent-run_Expert.docx
0
I have a field which has first and second names (OR the field may only contain the first name)
How can I create a formula which only show the first name
0
Need help with the correct placement of Parentheses.



AND eap1.proc_code IN ('98966','98967','98968','99441','99442','99443','99201','99202','99203','99204','99205','99211','99212','99213','99214','99215') AND EAP.POS_TYPE_C = '2' and px1.MODIFIERS like '%95%'

AND prc.prc_abbr LIKE ANY
(    
 'CDTAV%',
'LANGTAV%',
'MHTAV%',
'PHONE%',
'PNTAV%',
'TAV%',
'ESVV%',
'LANGVID%',
'OBVV%',
'VAV%'
)

OR eap1.proc_code IN ('98966','98967','98968','99441','99442','99443','99201','99202','99203','99204','99205','99211','99212','99213','99214','99215') AND EAP.POS_TYPE_C = '11' AND px1.MODIFIERS LIKE '%GT%'

I believe "prc.prc_abbr LIKE ANY" where I am using the wild cards could also apply to the OR portion of the code.
0
How would I format this so I can use wildcards in the criteria I am searching for. If want to be able to use % at the end

,CASE  prc.prc_abbr                                                
WHEN 'CDTAV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'LANGTAV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'MHTAV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'PHONE%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'PNTAV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'TAV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'ESVV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'LANGVID%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'OBVV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
WHEN 'VAV%' THEN  prc.prc_name || ' ---> ' || prc.prc_abbr
ELSE 'No Visit Type'
END AS "Enc_Name-Visit_Type"
0
I am trying to calculate the percentage of each security in a given portfolio. The calculation should be value of the security divided by portfolio total. For example, in account 1, first portfolio, the percentage for Select Financial Svcs should be 400/1500 = 0.267.

I tried using a following manual formula ({@Secur_Value} / {@Acct_Sum}), but it does not calculate the correct percentage.

The report is attached. Please help solve the problem.
Report
0
I haven't worked with Crystal Reports for several years.   I wanted to ask a general question regarding table joins within the query for a crystal report.   I have 5 tables, with identical fields that I query using a UNION ALL statement.  I group the data by the fields and summarize.   Pretty straight forward.   However, I was wondering if there was a way to identify (without separating in separate reports) the tables... basically grouping on this information and then drilling down to group on the field information.     If you need to see code examples, please let me know.
0
Crystal 2013, this one I'm just drawing blanks on today,

I have a field (customer) it is a number and I need to burst these reports but the software wants to strip out duplicates  because of my grouping.  So if i could add Groupnumber to the customer number that should allow me to burst based on this  generated number..that's my thought.  I tried {customer}+Groupnumber but get a string error so my thought was I've got the syntax wrong or just brain dead today .
0
Take Control of Web Hosting For Your Clients
LVL 12
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

I am trying to do a crystal XI R2 report that I have attached.  I just attach the detail section and not the header. I also have a key that is in the main table and sub report table that I have them link on. They want element of BMP, Potential Problem, How to fix Problem, and who will address problem Columns hard coded on the report. The Y/N field is in a table. It can be Yes, no, Satisfactory, or non-Satisfactory. Comments are also in a table. The main table has a one to many relationships with this table. There can be anywhere from 17 to 30 records for the one record in the main table. The element of BMP and Potential Problem is actually in the table but I have to search for a dash and then split the field into the Element of BMP and Potential problem columns. My problem with this is they will have to key the dash just right. I added a sub report and set the form up like you see it on the attachment then tried to set up fields for the ones that need updating. That did not work as I thought it would.   I tried another process were I created one line in the sub report but set up formulas to search for a word in the sentence and then print the right How to fix the problem and who will fix the problem. That reports work but if they change, the word I am searching on this will not work. I tried setting this up on the main report in the detail section then have the sub report pass the information back to the main report but that does not work correctly, since it is so many …
0
Hi There,
In Crystal report 8.5, I'm trying to find if a field in the report a date field is in range of current week or in a date 2 weeks before 3 weeks before or older

if {@ExpDate} > LastFullWeek then "Late Current Week"
else


if {@ExpDate} in LastFullWeek then "Late Last Week"
else
if {@ExpDate} in something for 2 weeks before  then "Late for  Last 2 Weeks"      ---- Not sure how to do this
else
if {@ExpDate} in something for 3 weeks before  then "Late Last 3 Weeks"      ---- Not sure how to do this
else
"Late more than 3 Weeks Ago"

Will appreciate if somebody can tell how to do 2 weeks and 3 weeks.
Thanks
0
Hi
I have a report which shows 20 random records, works ok
I would like to extend this to make sure it only shows unique values in another field
The random selection is linked to the work order field I would like it only to show unique departments
Have attached the rpt file
GR-Customer-Survey-Data-4.rpt
0
The crstal reports were created with Crystal XI R1 on a Windows  7 machine. The user has upgraded to a windows 10 machine 64 bit. When they open a file either on the server or their C drive it will open the report but not let them edit a header field. They can most times edit a text field on the detail line. They cannot suppress a section or they get the error message I attach. I have removed Crystal and reinstall it. I can take the same report and edit it on my windows 10 machine 64 bit. I have Crystal XI R2. Has anyone seen this problem before? I appreciate any help.
Thanks
Steve
Crystal-error.PNG
0
Is there a way to export a Crystal Reports cross-tab report to a text file and have the values comma-delimited?  If so,  please provide sample.

Thanks
0
Hello!

I am trying to summarize values within  a group, but only values that are not suppressed.

I am suppressing the values that are dupplicate in that group.

Can't figure what to do next.

Need help!
0
Hi,

I have a report which is showing two totals that comes from 2 different tables.

1st table is the committed cost (PO_Items.Cost using formula sum({PO_items.cost})
2nd table is the Budget cost (ACCOUNT.Cost_BAC_Approved)  which can also be seen under Project.Cost_BAC_Approved.
the PO_items is being shown using grouped by PO_ID
the Budget is being shown using  Group_ID_A  

Issue:

Using the attached snapshot of the link, I cannot correct one of the item, if I link the Account to the Purchase Order Tables The PO_items.cost is giving me different amount it multiplies to numerous amount.  but the other the budget amount is show incorrect amount.  If I I take of the link between Account and PO the committed amount is correct and the budget is blank or multiplying as well to numerous amount.

I am attaching the snapshot of my link and the RPT file itself.

Please help me to show the correct value of the PO using PO ID and the Budget Using one of the Group ID (package Number).

Thanks.

Romeo
Capture.PNG
Link.PNG
CAF--EE-.rpt
0
HI I am using Crystal report 2016, I am getting my Database thru SQL server and application is Prism G2.

I have 2 Tables PO_Item (itemized), Purchase_Order (Summary with Vendor and other terms)

I get my PO details in PO_Items and insert it to the detail section.  When ever I insert a field PO_items.PO_ID in the report Header I am getting the correct preview of all the items in a particular PO.  I need to display the Terms, vendor, vendor address to the report header as well and will get it from the table Purchase_order.  Once I insert the filed vendor, vendor address and terms to the report header from table Purchase_Order my details are getting hay wire, it multiplies the number of filed I inserted.  I know that adding a field to the Report header form another Purchase Order table creates the multiplying of items because when I deleted the fields from the report header it goes back to the correct preview.

The thing is I need the Vendor, Vendor Address the Terms and delivery terms in my PO Form, but this causes the problem.  How do I correct this.

Is there a way to make this field read only or use this field but will not affect the details.

I did not use any linkage from one table to  another, because if I do auto Link, the PO will be blank.

Can somebody explain to me the principle of Linking Tables and tips on how to link table properly (what to remember and to do etc...)

One last thing is the first page of my PO form is the Purchase order Cover form …
0
When I insert an 850kb jpeg image into my report,  the image disappears from the screen after I save the file. The box remains in the report, just the image goes away.  If I double-click in the box, the image opens in Paint.  The image does not appear on the screen or print with the report.  

I am experiencing the same behavior in both Crystal 2013 and Crystal XI.  Any help or insight would be appreciated.

Thanks,
John
0
Free Tool: Site Down Detector
LVL 12
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have a parameter in a crystal report for the end user to enter a number.  I want to pass this parameter to a formula that will be

if parameter > 0 then (parameter# * 35) + other field
else other field

I cannot figure out how to pass the parameter into the formula.
0
I have a report that I'd like to have a second version of that runs by 3 months instead of 12. The report will prompt for the ending date, and will currently run based off of a range of 12 months prior. The prompt accepts the date as YYYYMM, ie 201801. It is a string variable, which makes calculations against it (like subtracting a year for the range) difficult. I could add in a starting date field, but I like for the report to figure everything out with minimal input. Getting a range for year is not so hard, just subtracting 100 from the entered value. Switching to a month range is more difficult though. I would need to subtract 2 from the input date, but not if it ends in 1 or 2. I would then need to subtract a year and a month or 2. I'm not sure how to do this though.
0
Hello,

The attached report works great - now what the sales staff would like is the current criteria as shown but to add the prior year data below each month.  For example - Jul 17 Gallons then in a section directly below would have Jul 16 gallons.  I thought I could modify the formula by copying and just adding -1 to the year but that didn't do the trick.  Any help is greatly appreciate!

Thank you.
Sales.rpt
0
I am trying to calculate the percentage of two column totals in Crystal Reports.  The formula below is the formula I am trying to use:

If {Command.cost}= 0 then 0 else sum{Command.cost}/sum{@labor gross}*100

What am I doing wrong?

Thank for your help in advance.
0
I have a Crystal Report formula for a parameter I enter.  The first two work great, number three is not sorting how I want it.

It is sorting it like below:

0
1
2
3
4

I would like it sorted like:

20
19
18
17
16

The formula is below:

if {?SortColumns} = '1' then {Command.findname} else
if {?SortColumns} = '2' then {Command.lendercode} else
if {?SortColumns} = '3' then totext({Command.age},"00",0)

I want option number three to sort descending.  What in the world am I doing wrong?

Thank you in advance.
0
I have the following and it works fine, but I need it to be in a date format 01/08/2018 example

(ExtractString({MASTER_LABEL.FG_LOTNO},"-","-"))
0

Crystal Reports

34K

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.