Crystal Reports

34K

Solutions

14K

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

How do I get my Fields that I can select for my formula to show again. I must have clicked something accidently to make them disappear. How do I get them back?
0
Free Tool: Port Scanner
LVL 11
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'm using the following formula successfully with a summary (count) on that formula to count unique values in a field:
if {table.field} = 1   then '1'    else '0'

I'm now trying to count two unique values and cannot get the summary count to work:
if {table.field} = 1 OR  {table.field} = 2  then '1'    else '0'

It does not combine the two values in the count.
0
I currently have the resultset as below:

Program                        Rundate              Userid
---------------------------------------------------------------------
P:\Application2.rpt      2017-11-10         john                    
P:\Application2.rpt      2017-11-11         sam                        
P:\Application2.rpt      2017-11-13         sam

P:\Application4.rpt      2017-11-12         john  
P:\Application4.rpt      2017-11-14         sam                  
P:\Application4.rpt      2017-11-15         luna

P:\Application1.rpt      2017-11-14         john                    
P:\Application1.rpt      2017-11-15         luna                  
P:\Application1.rpt      2017-11-16         sam








I need to get the resultset as shown below:



Program                       LastDateRun1   LastRunUser1  LastDateRun2    LastRunUser2  LastDateRun3   LastRunUser3
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------

P:\Application2.rpt      2017-11-10         john                    2017-11-11       sam                   2017-11-13         sam
P:\Application4.rpt      2017-11-12         john                    2017-11-14       sam                   2017-11-15         luna
P:\Application1.rpt      2017-11-14         john                    2017-11-15       luna                   2017-11-16         sam
0
I have two stored procedures in one report. My main stored procedure is procSSFTP_RPT_WorkAndRestDailyReport and 2nd stored procedure name is procSSFTP_RPT_GetCrewComments.

I want to display "Seafarer name" from my 1st stored procedure and "comments" from 2nd stored procedure.

I have multiple rows for the comments against the single seafarer name.

Instead of showing multiple rows of comments for single "seafarer name", I want to display one comment per "seafarer name".

Attached is the report for your reference

https://drive.google.com/open?id=1nb_DOgTVjFD1d-YdRR8jUX2omN5yO8KV
0
I have a report that shows sales by department. Within each department, it lists by group the top 5 stores.  I need to pass the store numbers to a subreport after they have all printed to do some other calculations using another table that won't link to this one.  How do I capture those top 5 store numbers? Or is it even possible to send them as a list to the subreport?
0
I am trying to create a report.  I want it to look like the attached:
What I have at the moment is attached:
The cross tab is built as attached:

The formula is:

//Current
if {F_TASKS.TA_STATUS} = 'Assigned'
and {F_TASKS.TA_EST_DATE} > CurrentDateTime
then "Current Open Tasks"
else
if {F_TASKS.TA_STATUS} = 'Assigned'
and {F_TASKS.TA_EST_DATE} < CurrentDateTime
then "Current Overdue Tasks"
else

//This Week
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS}= 'History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-7 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} < {F_TASKS.TA_EST_DATE}  
then "Tasks Completed On Time Last 7 Days"
else
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS} ='History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-7 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE}
then "Tasks Gone Overdue Last 7 Days"
else

//This Month
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS} ='History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-30 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} < {F_TASKS.TA_EST_DATE}
then "Task Completed On Time 7 - 30 Days"
else
if {F_TASKS.TA_STATUS} = 'Complete' or {F_TASKS.TA_STATUS} ='History'
then if {F_TASKS.TA_FINISH_DATE} in date (CurrentDateTime)-30 to CurrentDateTime
and {F_TASKS.TA_FINISH_DATE} > {F_TASKS.TA_EST_DATE}
then "Tasks Gone Overdue 7 - 30 Days"
else

// 6 weeks
if …
0
hi im new on crystal so please bear with me
for example this is my data

EMPID     COMPANY     DEPT
12345          100              22
23456           100             23
34567           200             33
45667           200              34
11111           200              35
11112           200               36
11113           200               37
11114            300              11
11115            300               12
11116            300               13
11117            300                14
11118            300                15

lets say I need to capture empID in company 100 and on 200 I only need dept 35,36 and on 300 I need depts 11,12,13
how will I be able to get that? lets say there are more data in it with lots of departments but I only need specific ones from specific companies
0
i got this msg when preview the report(cystal report 8.5) after i change the server n database SQL server 2012 express
0
Hi,

I want to increase the width of label border to 1 pt as for now it is only hairline.
The options available in the format section are single border, double, dashed and dotted.

I will be exporting this report to excel, so how to avoid the unwanted spacing of sections?

Attached is the report:
https://drive.google.com/open?id=1YTkq8UP5MtVJqMF_MvIlXkLVZm2DnDUe
0
I am having a hard time one last portion of a report I am writing, I haven't run into this scenario and would like to hear some input on this one. Also my first question on EE as I normally just read what others have been through.

So here's the situation, I have a field called {Arp} data within is like CM-2017 or M1-2017  etc.    I have another field call {ARC} it has data that is the first two digits. CM or M1  and I tried to use a parameter that has -2017 and combine that with the {ARC} to select records from {Arp}  
I don't even know if this is possible, I'm just not seeing a way to make this work.  

Any help greatly appreciated.
0
Free Tool: IP Lookup
LVL 11
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

How can I achieve the date in "DD MMM YYYY" format in formula field of Crystal report.

I have one formula, where I am concatenating the Country name with the Date.

It takes the system format when the report is generated.

How can I fix the format to "DD MMM YYYY"

Currently on my system is displaying "DD-MM-YY" and on my colleague's System is s displaying "mm/dd/yyyy"

Attached below is the image and the shareable link for the Crystal Report.
https://drive.google.com/open?id=1YHdKcGzXllrOV0-PHWZ7uxul0IELeBle

AnalysisError.jpg
0
Hi,

I want to replace the Column A with the adjacent Column B if column A data is NULL (dynamically shifting).

For more reference kindly find the attached image
Image1.jpg
0
Hello,

In the attached report, the group labeled "5 - Freight" keeps going to the next page even though page 4 has plenty of room.  Thanks for your help.

paging.rpt
0
I have a report where I need to specify a data range in a running total and not sure how to write.

Need to pull all data < currentdate  and also include currentdate items where entertime is less than 6:00am

Example:
Production pounds < currentdate = 20,000
currentdate records entered before 6:00am = 2000

I want to have a single statement that will capture the 22,000 total.
0
I have a formula named @G Qty.
The formula is:
if (({Glovia_.LOC BIN LOT} = previous ({Glovia_.LOC BIN LOT}) and {@Item Number} = previous ({@Item Number})))
then 0
else {Glovia_.Qty}
I need the sum of this formula at each change in the group 'Item Number'.
I have read examples of how to do this with whilereadingrecords but all it has done is confuse me.
0
Hi.  I've been trying to figure out this issue but I think I'm making it overly complex.  I want to select all records for a journal entry based on user input for a numeric field.  

The selection criteria I use currently only works for one or more journal numbers:
 {tglTransaction.JrnlNo} in {?JournalNo}.  

How do I make this work for "All records"?  I have no problem using wildcards and such for strings but can't make the leap in how to do it based on number fields.  I want the user to input one or more journal entry numbers, or something akin to "*" for all journals, and have the data set filter for that input.  

Thanks in advance for your help.
0
What would be the best way to compare two values a year apart?

Say I have
Date                            Used
October 4, 2016          3,334
November 5, 2016      4,999
December 12, 2016    4,698
etc...
October 7, 2017          3,999

What would be the best way to compare the two October dates?  And then next month compare the two November dates, and so on.  Basically each month we would compare current month minus same month last year.

Thanks.
0
Hi,
 
I have two Stored procedures in one crystal report. Both having same parameters.
But when One stored procedure data is NULL then other stored procedure data is not visible on report which has data in it.

If I do Browse Data for another stored procedure which has data then the data is clearly visible in Browse Data Dialogue box but not on  report.

For example, refer the attached report link : https://drive.google.com/open?id=0By-_z66pGEGrb3RtVHd6cTNPLXc
Purchasing_IssuePurchaseOrderReport.rpt
0
Please help me write the correct record selection formula that will display two names.

When I use the record selection formula shown below, the result is correct.

{Individuals.LastName} = "Doe"

However, when the record selection formula shown below is used, no records are displayed.

{Individuals.LastName} = "Doe" and
{Individuals.LastName} = "joe"
0
Keep up with what's happening at Experts Exchange!
LVL 11
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

totals.rptHi,

I'm trying to sum the field of @Cost per group.   For example, the sum of @Cost for  Heat Barrier Series Glazing Bead should be $320.92.

Thansk\ for your help....
0
I have a Crystal Report (2016) with multiple sub reports, I'm distributing the same report to multiple ODBC data sources (25). Is there an easier way to change the ODBC data source for each sub report rather than having to manually change each sub report ?
0
I have a custom report that I created several years ago using data from my ERP system (DBA/Evo~ERP).  Just recently, I have an anomaly that has surfaced.  I have manually stepped through the linked data files and the duplication does not exist in the data.  The odd thing is that it only seems to affect a single part number in our item master.  

I found a link to a whitepaper from Crystal Decisions titled "How to troubleshoot duplicate records from displaying on a report" that was written for Crystal Reports 9 but says it is applicable to earlier versions as well.  After reviewing, I am inclined to think that this is a data corruption problem.  Is there any way to detect such corruption and repair it?
0
I have a report where the primary file links to a secondary file to obtain some data. Only the matches will be printed on the report. I need to change the report, so that all primary records will be printed regardless of wheter they are a match. I will need to be able to label the non matches in the report. How do I do that?
0
Hi,

I want to achieve a row layout detail section and at the same time column layout detail section.

For example, I want my detail section a to detail section f as normal Row Layout detail section.
Similarly, detail section g should be Column layout detail section.
0
I have a field in my Group Header that already has a suppress formula on it and will need to add to it. I need to have this field only print on the last page of my report. It currently has this on the suppress formula already.

IsNull ({CrystalProc.Payer1}) or (Trim({CrystalProc.Payer1}) = "")
0

Crystal Reports

34K

Solutions

14K

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
>