Crystal Reports

34K

Solutions

5

Articles & Videos

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

Hi, I am creating a very simple Excel file for a user to populate with part numbers that I have attached to a Crystal report. We are on;ly using column A with no formulas or calculations. This is just a flat file for them to use to get data back just on the part numbers that they want to see. I have populated several cells for testing and found I have one rogue. When entering the data all of my entries justify to the left except this one number, it justifies to the right. This is no big deal except it tells me something must be different about this part number. If I go to the Crystal report that is using this file to look up the part numbers and I browse this data field I can see all the part numbers that I have entered except this one. This is an example of the list:

2722M69G01
4013770-389
5318216-01
5318217-01
5319098-01
7010102H03
704977-3
7083M57G02
7086M33G01
710181-2CSI
749059-1
763904
1725911

It is the last one in this list that is the trouble maker, 1725911. I have tried formatting the cells to number, text and general with the same frustrating results. Any help with this would be appreciated.

Thank you
0
Free Tool: SSL Checker
LVL 9
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Our company has thousands of different vendors in its ERP system.  Many of them we no longer use.  I'm trying to figure out the best way for me to create a report that will show me a distinct list of suppliers that we have used.  Or a way to show the last time something was purchased or received from a vendor.  I can use SQL, Crystal Reports or Excel to create this but would need the thought process of what to filter the report on.   My goal is to review vendors where we have not had usage from say the past three years and eliminate them from our database.
0
I need to display part of a field on a report.  An example of the field is:
SRC:Urine                  
Performed At: EDIWK, EDI Testing Lab
555 Anywhere Street, Anywhere, NC, 272150000
Testing, Pathologist, MD, Phone: 3365550001.

The only part I would like displayed is the text that starts with Performed at, suppressing anything that would be prior.

I am using the formula

Replace ({lab_results_obr_p.obr_comment},"^" ," " )

I hope this can be done.

Nancy
0
I am modifying an old report to add in a gross margin.  I have created the formula (profit), the variable and the display variable.  However, I am getting a running total in the group section and cannot figure out how to change it so it only totals the groups.  There are other such formulas in the report so I followed suite but cannot reset the running total on the profittotal formula.  Attached is the file.  Thanks for any help!
_QH_ship_cust_cost_with_margin.rpt
0
is there a way to truncate the labels on horizontal axis?  The labels represent YYYY-MM-DD ##.  I want to hide the last 2 characters and keep only the YYYY-MM-DD.
0
Hello Experts,
I am trying to refresh my report and i get the message "A string i required here" for the part in bold, i am not sure whats going on , any ideas would be appreciated.
Thank You.

{vwApptSchedAvail.Available_Date} in[b] date(2013,10,01) to date(2014,02,28)[/b] and
{vwApptSchedAvail.Activity_Type_Abbr} in ["SAME", "Same 20", "SAME15"] and
{vwApptSchedAvail.Sched_Loc_Abbr} in ["Catawba", "Bessemer", "Cherryvl", "Davidson", "Highland", "LincHHHC", "Main", "SCC", "States", "Third"]

Open in new window

0
Hi. I created an ODBC connection on my crystal reports server, which is also a SQL-Express server, to a database on a different SQL server on my network.  The connection tested successful in DSN config.  I created a new report in Crystal Reports though and my new connection wasn't visible in the ODBC connection type.  Both servers are running SQL 2012.  What am I missing?  Should I use OLE DB connection instead of ODBC?  I do have roughly 10 or 12 other local ODBC connections setup on my crystal server for reporting purposes if that makes any difference.  Crystal version is developer edition 11.5.  thanks
0
I have 50+ Views in SQL server and while connecting to the same server via Crystal Reports, I can only see top 12 Views (the top 12 that names start with letter "A").
How can I see all Views?
0
I have a report (attached) where I have field that I have extracted certain data from - this is the formula for operator.  I have also suppressed records based on whether the item field as the .MLD characters.  When I use a formula for the sum of the rejects I get all the records, not just the suppressed.  When I use the running total and change total on group I only get the first line item, not the total of the visible line items.  

In the example - the first column 320191-041917-903 I am pulling the data 903, which is the operator # and using that as my grouping.  Then suppressing for only the items with .MLD - I should get a total of 205 rejects (last column).  The formula gives me 433 which is all records, and the running total gives me 1.  

Please assist.  Thanks.
_01_Rejects_by_Operator.rpt
example.pdf
0
I have vb6 application thru which i am able send report  as PDF document as mail attachment. I want to include password for pdf file. Following is coding. How can i set password for PDF documents.

repSaleRegister  is report generated by crystal report designer in vb6 application.

Thanks
   
    repSaleRegister.ExportOptions.Reset
    repSaleRegister.ExportOptions.DestinationType = crEDTEMailMAPI
    repSaleRegister.ExportOptions.FormatType = crEFTPortableDocFormat
    repSaleRegister.ExportOptions.MailToList = adoTR_EMPAYDATRs.Fields!PMEMAIL
    repSaleRegister.ExportOptions.MailSubject = "Test Report"
    repSaleRegister.ExportOptions.PDFExportAllPages = True
    repSaleRegister.ExportOptions.FormatType = crEFTPortableDocFormat
    repSaleRegister.ExportOptions.MailMessage = "Dear  Please find attached report"
    repSaleRegister.Export False

Open in new window

0
On Demand Webinar - Networking for the Cloud Era
LVL 9
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

I have a multi select parameter for Product Name. To display the parameters the user chose, I have the formula:
join ({?Product Name},",")

However, when It displayed, it added a carriage return for some strange reason. I'm assuming the way the text is being stored in the view is causing this. Is there a way to strip out the carriage return (or maybe it's a blank field?) and then join the parameter values? I know this formula strips out the blank fields but I don't know how to incorporate it with my join formula.

replace({BAX_V_CCMS_CHANGE_RECORD.PRODUCT_FAMILY_NAMES}, chr(10), "")

So, as a recap:
My select expert is set to:
{BAX_V_CCMS_CHANGE_RECORD.PRODUCT_FAMILY_NAMES} = {?Product Name}

Product Display formula: join ({?Product Name},",")

User selects from Dynamic Parameter:
BUMINATE
ADVATEADAMTS13 (when displayed, there is no space)

But my parameter display formula is displaying as:
BUMINATE, ADVATE
ADAMTS13

and what I want is:
BUMINATE, ADVATEADAMTS13
2017-06-06_10-30-23.jpg
0
I have a Crystal Reports 2013 Chart that has a LOT of data points.  So many,  that the horizontal data labels cannot be read!

Is there a way to reduce the numbers to [let's say] 5, 8, or whatever number I desire?  This way every 5th or 8th data point will have a label :)
0
Hello,

I have a Profit and Loss Report. (Please see example attached with save data)

I am wanting the 'Finance Expenses' to be moved and appear after the 'Net Profit(loss) section.

Can this be done?
ProfitLossTest.rpt
Untitled.png
0
Trying to build a line chart using Crystal Reports 2013.  I cannot get the horizontal data values to sort ascending.  How do I accomplish this?  See the attachment
CR2013.PNG
0
I have a report which has in the database fields
RequestDate
RequestTime
Investcompdate
investcomptime
From a report standpoint, I have created the follow:
Requested Date Time = CDateTime (Date({WO.REQUESTDATE}) & " " & Time({WO.REQUESTTIME}))
Investigated = CDateTime (Date({WO.INVESTCOMPDATE}) & " " & Time({WO.INVESTCOMPTIME}))
These two formula work fine
What I am looking for is a formula which will sow me the time elaped between the RequestDate/RequestTime and the Investcompdate/Investcomptime
as a decimal figure ie 15 mind would be 0.25
Gordon
0
I have a crystal report with a string that is seperated by & signs. I am wanting to seperate the string into diffrent fields so i can use in other functions.

Example:
String:  06/01-120&06/01-228&06/02-300&6/5-300

Expected output:
Value1 = 06/01-120
Value2 = 06/01-228
Value3 = 06/02-300
Value4 = 06/05-300
0
Have a crystal report where grouped by product ID and in the footer of that section I want to display all of the batch numbers and quanity in the details section.  Since we are exporting this to Excel, I would like all this data on one line.  I know this can be down there variables but not sure how to create.

Example:
Details section:  
batch 123456  qty 2
batch 569876  qty 5

Prod group footer:
Product 25687-41   batch 123456 qty 2   batch 569876 qty 5
Live-Label-Reorder-Report-v2.rpt
0
Dear all brother ans sister, i am working on VB.Net application with crystal report, when user input their finger print it store to tbl_att like that: (Let say they are day off for 3 days)

Emp_ID                 working_Date       checkin_time
    1                        2017-05-01            12:22:34
    1                        2017-05-02            12:21:45
    1                        2017-05-03            12:26:11
    1                        2017-05-07            12:12:54
    1                        2017-05-08            12:20:34

This mean if i bind that data to report it will in order like that too, as user No1 he day off for 3 days , so it missing date of 4,5, and 6 May. But i want it show all record with all day with blank checkin_time like that:

Emp_ID                 working_Date       checkin_time
    1                        2017-05-01            12:22:34
    1                        2017-05-02            12:21:45
    1                        2017-05-03            12:26:11
    1                        2017-05-04            NULL
    1                        2017-05-05            NULL
    1                        2017-05-06            NULL
    1                        2017-05-07            12:20:34
    1                        2017-05-08            12:20:34

Am i need to edit something with my database table or with Crystal report field or formula?

Thanks in advance.
0
Hi,

Is there a way from within visual studio to open a supreport in crystal reports,

I'm trying Report1.OpenSubreport(Report1.Subreports(5).Name)

But this doesnt work,

Any ideas?
0
Enroll in June's Course of the Month
LVL 9
Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Hello,

I am using SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer.

When I drag and drop the date field from my service it shows an incorrect date on the report.

As shown in the screen shot image


How to overcome this issue? Even if I enter different parameter it shows the same incorrect date. It doesn't display date in database.
IncorrectDate.jpg
0
When I write some code in formula with any database field and save it I got nothing error appear, but while run time when generating report I got this error message. (VB.Net) anyone help me please, thanks in advancenb.PNG
0
How can I modify this formula to concatenate but instead of using commas I just want to add a carriage return in between each value selected. It can be one or many
   
Join ({?Supplier},", ")  (I need to use the Join but don't want the commas)
+ Chr(10) +
0
I have a report whereby I would like to show the graph as a component make up for each stack
See attached
I can change the graph to show component for the major heading, but do not want this
Want to show each major heading as a component
Gordon
Would-like-to-show-the-tufting-sect.docx
0
I have this formula in my Crystal Reports 2008.  Usually it works fine, but if Sum ({@LY_MTDSum}, {@Line Items Grouping}) is a negative number, it doesn't calculate correctly .
If Sum ({@LY_MTDSum}, {@Line Items Grouping}) <> 0
then (Sum ({@CY_MTDSum}, {@Line Items Grouping})  
      -Sum ({@LY_MTDSum}, {@Line Items Grouping}))
       /Sum ({@LY_MTDSum}, {@Line Items Grouping})*100

else 0
Capture.JPG
The above shows the page with the weird results.
0
I have a report that contains a line chart.  The legend says Sum of Blah_Blah_Blah.

How can I change the legion to Blah_Blah_Blah?
0

Crystal Reports

34K

Solutions

5

Articles & Videos

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.