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

Hi Experts,

In my Web Application I need to show 'Gross Weight' in last row of group rows at every change.

For Example :
Output_Crystal.JPG
In above screenshot the Gross Weight is duplicated and it's not needed to show repeated values. I want the result as shown in Desired Output section.

Please help.

Regards,
D Patel
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

Hi,
I have a line chart that I use to show sales information.  I use it all year, but would like to highlight (via background shading) each quarter of the year.  I have had no luck so far.  Any suggestions?
Dan
0
Can the database password on the SAP Crystal Reports in SAP Business Objects Enterprise be updated using an API?

Is there an API .NET Framework available?

Where can the API be downloaded?

Does the API have to be installed on the both the client and server?
0
I have passed string from vb variable to crystalReport TextObject, and when i create a formula and browse for that TextObject to calculate ,it's not available to calculate, how can this done?

Thanks in advance.
0
Hi,
      I have a Crystal report that I would like to see all the items that I am asking details returned for regardless if there is any data to report on or not. For example, I am asking to see all the labor posted to some specific workcenters for a given date range. The report I wrote returns this information but only if there is labor posted for the days in that date range. What I would like to see is a list of the workcenters showing me not only the total amount of labor posted but when there isn't any labor posted as well. I have attached a copy of the report I am referring to. Any help with this would be great.

Thank you
Attended_MCTR_Labor.rpt
0
I have the attached report that shows by day the total qty, change overs, and pounds.  I would like to know if there is a way to show the average of the change overs in the total section.

I am not sure if this can be done since the change over is a running total that does a distinct count on productID.
Data-Review.rpt
0
Hello,

I have the attached Stock Qty Sold Product Report.
I am wanting to be able to GROUP the Product Code ('parent') together so it doesn't show it's 'child' entry and have a drill down feature.

When I run the report with a product code like:
1001.01.00
1001.02.00

I want to be able to group it so its:
1001

RPT file uploaded is saved with data.
GroupReport.png
12MonthProductSalesUnits.rpt
0
I have a cross tab that shows the data Ok
Cost Centre then sum of cost ok, these are data fields in the report
I can add a text box to show the group heading ok IE Labour
Am I able to add the text to each line
So that the table would show against each line
Cost Center (data) Labour (text) Sun of @Cost (formula)

Gordon
Hope this makes sense
0
All,
  I'm using VS 2015 Enterprise, specifically vb.net along with crystal reports.
I have a form1.vb that opens mysql database, asks user for start date & end date & lastly creates xml schema of requested data.

Imports MySql.Data.MySqlClient
Imports System.Text.RegularExpressions

Public Class Form1
    Dim myData As New DataSet
    Dim conn As New MySqlConnection
    Dim cmd As New MySqlCommand
    Dim myAdapter As New MySqlDataAdapter

    Public MySQLConnectionString As String = "server= www.automatedanswers.com;user id=russemi2_test;password=Passw0rd;database=russemi2_test"
    Dim connStr As String = MySQLConnectionString
    Dim sql As String
    Dim id As String
    Dim datetime, datetime2 As String

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim pattern As String = "^(20)\d\d[- /.](0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])$"
        Dim regex As New Regex(pattern)
        datetime = ""
        datetime = InputBox("Start Date - Use Format 'yyyy-mm-dd'")
        Do While Not regex.IsMatch(datetime)
            datetime = ""
            datetime = InputBox("Start Date - Use Format 'yyyy-mm-dd'")
        Loop


        datetime2 = InputBox("End Date - Use Format 'yyyy-mm-dd'",, datetime)
        Do While Not regex.IsMatch(datetime2)
            datetime2 = ""
            datetime2 = InputBox("End Date - Use Format 'yyyy-mm-dd'")
        Loop

        datetime2…
0
Hello:

In the latest version of Crystal Reports, we need to suppress a tracking number field's "header".  The header simply says "Tracking Number:".

When there is no tracking number, we simply don't want that header field to display.

So, we right-clicked on the header field and chose "Format Field".  Then, we clicked the "Suppress" checkbox and, afterward, the formula button.

For the formula, we typed "IsNull({tracking number field})".

Although the error-checking button produced no error when clicking it, having this formula made the entire report print blank!

What did we do wrong?

Thank you!

John
0
Free Tool: ZipGrep
LVL 9
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Hi
I am trying to use following code  to get date format in "dd-mm-yyyy"

like dtpicker1.value = 06-01-2017 (mm-dd-yyyy)
using following code getting desired result like 01-06-2017 in crystal report formula

        Dim DatfrmDate As Date
        DatfrmDate = DTPicker1.Value
        DatfrmDate = Format(DatfrmDate, "dd-MM-yyyy")        
        CrystalReport1.Formulas(1) = "FromDate = '" & DatfrmDate & "'"

Same code using for Dtpicker2.value  but not getting "dd-MM-yyyy format
like dtpicker2.value = 06-30-2017 (mm-dd-yyyy) then it supposed be 30-06-2017
but no luck please help

        Dim DatToDate As Date
        DatToDate = DTPicker2.Value
        DatToDate = Format(DatToDate, "dd-MM-yyyy")        
        CrystalReport1.Formulas(2) = "ToDate = '" & DatToDate & "'"
0
I have aa report with all the needed Declared formula but it does not work for some reason
Attached report with data
The focus is on 2017-P04APR period and 8305 120 cost center
The value of the budget in the database is 1000, but it shows 0 on the main report

Any ideas
Gordon
Commitments-to-Budgets-Report-V13.rpt
0
I have a description field in an SQL table. I use Crystal Reports to create reports for this data. There is one of the product descriptions that I would like to wrap the text at a certain point, but do not want to alter the crystal reports field length, which would alter how other descriptions printed. Is there anyway to add in a hard line break within a nvarchar field of SQL? Or another way to achieve this with Crystal?
0
I have a database table for my general ledger.

I want to create a report that will have a group for every day of the year and have a running total of my general ledger every day.  

The general ledger detail has a DataTime Field.  

Some days of the year there are no general ledger transaction but I still want a running total for every day, even if there is no detail.

I want to see this:
Date                 Ledger Account                            Running Total
03/01/2017     Sales                                               10
03/01/2017     COGS                                              -10

How can I create a group for every day of the year? How can I do this?
0
Have the attached report that simply shows sales by day.  I am wanting to add a Max line at the 150K to go across the page.  Does anyone know how to do this as the crystal graphs seems limited.
Shipping-Future-Orders.rpt
0
Hello,

I have a crystal report in which i have used crosstab control in subreport.

I basically want to break the column text word by word like shown below

this is how i want
But i'm currently getting it like this.

current what i get
Kindly advice - any help is much appreciated.

thanks in advance
0
Have the formula below where it ready shipdate-1 or shipdate-4.  However, I need it to exclude the weekdend.  

Example:
Shipdate = Monday 7/3
Value returned - Shoudl ready 6/27/17 or 6/30/17 depending on -1 or -4

if {@DropShipID}="Drop Ship" then {ORDER_HDR.Ship-Date}-1 else {ORDER_HDR.Ship-Date}-4
0
Hello!

I am trying to choose certain drivers and certain trailer combinations to determine the amount to pay the driver per stop. If a trailer is one type (number) they get $35, another type they get $40 per stop, and any other drivers only get $30 (regardless of trailer).  Here is my current code - it is throwing an error asking for Then at the end. I don't use this every day so I'm not seeing what the issue is. I am a little rusty I guess.

if (({Dispatch2012.DriverNo} in ['1', '212', '214', '215', '66']) and if ({Dispatch2012.Trailer} in ['361', '362', '363', '9385']) then ({Dispatch2012.Stops} * 35))
else if (({Dispatch2012.DriverNo} in ['1', '212', '214', '215', '66']) then ({Dispatch2012.Stops} * 40))
else ({Dispatch2012.Stops} * 30)

Any ideas??

TIA!
Di
0
Our database lists loan officers by  a number. I would like to write a crystal report and instead of having a number show up for each loan officer  I  would like to see their name instead


Example Bob Smith is loan officer 01

When I look at the report I see 01 for all the loans Bob sold

instead of seeing 01 come up I would like to see the name Bob Smith

Can you point me in the right direction
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.

I've written my report exactly the way I want it except for one issue.
I only want to show the GROUP1 if it is equal to B3.  Nothing that I do seems to work and not sure why?
I've tried "Section Expert" then "supress" and then {SARAATT.SARAATT_ATTS_CODE} <> "B3"
Also tried -  GroupName ({SARAATT.SARAATT_ATTS_CODE}) <> "B3"  and other things I can't remember :)

The field is a string.
cat3.docx
0
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
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 need to execute a formula to replace character u with greek mu (for micro)..   Currently the formula is checking a value in one field and return the value from other field.  I need to take the returned value and replace the value u with greek mu (for micro symbol).  

Right now I have
If {SampleReuslts.ComponetColumn} = 0 THEN {SampleResults.EnteredValue}

I need to add to Entered Value something along the lines REPLACE({SampleResults.EnteredValue,"u",???)  

where the ??? is representation for greek mu
0
I am trying to add a barcode to a crystal report but i am having no luck so far.
I have tried using barcode39 and barcode128.
I have created a formula field, chosen basic syntax and pasted in the formula. I have then edited the data field to link to the field in my table, like so: "TABLE_NAME.FIELD_NAME"
I have been using this font 'Code39AzaleaRegular1' when using the formula for barcode39.
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.