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

I've converted HTML text with the Crystal formatting feature text interpretation, but some of the tags remain.  Example file is attached.  Is there anyway to remove these characters from the text in Crystal?  I've considered a replace formula, but I don't know how to get Crystal to recognize the dagger and double dagger.  Any help is very much appreciated.
Using Crystal Reports 2013.
76228--Progress-Note--12202016__exp.docx
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

Hello,

In the attached report, is there a way to suppress group header 1a if 1b is suppressed?

Thanks.

hardware-EE.rpt
0
0
Hello,

I need to sort the records after all the group headers.  So the end result of the attached would be:

I-14960
  999806
  141
     Record
     Record

I-314
  999824
   312
     Record
     Record
     Record
     Record
     Record
     Record
     Record
     Record


Thank you,
Joel

GlassTest3.rpt
0
Hi,

I am migrating an old Crystal Report to an alternative Dashboard application.
My crystal report (which works very well, shame I have to migrate) reads from a table of monthly stock sales history.

e.g.

STOCK CODE   MONTH1UNITS   MONTH2UNITS   MONTH3UNITS   MONTH4UNITS   MONTH6UNITS   MONTH7UNITS
ABC123            100                         87                          69                          93                          108                        111
ETC
ETC

My Crystal Report had a parameter to prompt the user for number of months to report on.
A calculated field in the report registered all 60 of the month columns into an array and then looped through the correct number of months based on the user parameter for number of months to aggregate for each stock record in the report.
This solution was simple, elegant and worked very well.

I don't have the facility of arrays in the alternative Dashboard app.
Can anyone suggest an alternative way of achieving similar through SQL in Stored Procedure?  I'm struggling...

Hope i've explained clearly enough?

Thanks in anticipation...
0
I am creating a crystal report, which is new to me.  It is a Bill of Lading report.  The top of the report is filling in OK, it's when I get to the rows in the detail section, so for example if I am shipping 3 items, I get the main report without any detail, the I get three pages of the grid one page per item shipped.  I have attached the first page and one page that follows, I would have 3 other pages each page is filled with each items data.Page1.JPGOtherPages.JPG
Here is my code.

cry.Load(Server.MapPath("~/Reports/BOL.rpt"));
SqlDataAdapter da = new SqlDataAdapter("PrintBOL", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add("@BOL", SqlDbType.Int).Value = B;
da.SelectCommand.Parameters.Add("@Supplier", SqlDbType.Int).Value = C;
da.SelectCommand.Parameters.Add("@Carrier", SqlDbType.Int).Value = S;

var dt = new DataTable();
da.Fill(dt);
cry.SetDataSource(dt);
//crv.ReportSource = cry;
cry.PrintToPrinter(1, false, 0, 0);
0
Hello, I have created a simple report and created some basic parameters but when I run the report is blank
0
I am using Crystal report 2013,and visual studio 2017. but how to deploy on client machine.For Data Source in crystal report I using ODBC. i Already create proper ODBC ,and i download report distribution package from sap and install but still report not working.
and mypc project path shows as my attached image show. sir please help...... because your help save my reputation.thanks advance.
errr---Copy.png
0
Hello,

I've been playing around with the Always_on technology in SQL Server 2014 Enterprise.  I've got a production database and I've created a secondary database using this technology to use as a "Real Time" reporting database.  I've got the databases setup using Always_on and I am using Crystal Reports XI to try to connect to the "Synchronized" database but I am unable to connect.  In fact when I try to create an ADO connection to the database I put in the "sa" user and password and the database doesn't even show up in the database dropdown.  I've got the secondary database set to "Readable"

Any help would be greatly appreciated.
0
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
New feature and membership benefit!
LVL 9
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

If there is any insight that you could give me on this situation, I would appreciate it. I feel like I am really close to an answer after days of progress.

My challenge is that I want to display data from one column in two different places:

Here is what I am shooting for:

Diagram 1: Pipeline Shipments for 'TK101':
 
      
Tank     Product            Max             Net Product             Pipeline Receipts
                                                            
                                                            
TK101 #CRUDE            209,003.15            95,555                  3,045.00                  
                                                            
The 'PipelineReceipts' is a sum of transfers that feed into TK101.

This is the equation that I am using to get the “PipelineReceipts”:

Diagram 2: “PipelineReceipts” Formula in Crystal Reports:

 If {spRecShipInv;1.RecShipID} = "PipelineReceipts"
then
{spRecShipInv;1.MeasLiqVol}
Else 0

The equation produces the following:

Diagram 3: Results from Equation:

 Transfer-63786            RECOVERED SLOP OIL            0260            0.00            0.00                        2,601.00      
                                                                                                                                                                                    
Transfer-63787            RECOVERED SLOP OIL            0260            0.00            0.00                           444.00      

The two results from the transfers give me the total that I need.

Here is a copy of the relevant tables from the data source ‘spRecShipInv’

Diagram 4: spRecShipInv Table for ‘Transfers’:

      FlowID               FlowMeter      FlowType   RecShipID                 InService      MeasLiqVol      RecShipSrc           RecShipDest
Transfer-63786      Transfer-63786      R          PipelineReceipts      IS                 2601              PipelineReceipts      TK101
Transfer 63787      Transfer 63787      R          …
0
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 want to copy some data in row or column in crystal report when viewing and pass it data to MS Excel and keep the right format as when view in crystal report like that:

Crystal report data (I selected login Time column data and press Ctrl + C to copy)
cx.PNG
and i want to paste that selected data into excel like that:
bbb.PNG
Is this possible?
Thanks in advance for help.
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 created a dbf file and appended it with data from a CSV file. I thought I could simply create a dfb file with data in it without setting up an entire database and then create a connection to it in crystal reports to pull in the data. Is it not that simple?

The reason I did this is b/c my original data file that is csv format (or even if I convert it to xls or xlsx) treats one of my columns as a number field even though I format it to be a text field. The field contains bank insurance numbers like 12345, 22334, 52643, etc. I am trying to format it as text or string b/c in my report I am using my company database and trying to connect it to the csv file, but the Cert field in my database is a String field and the Cert field in the CSV (or xls,xlsx) file is always seen as a Number field, thus crystal reports won't let me join the two tables. This Cert field is the only field that I can use to join the two.

I thought by creating a dbf file I could change the field to be a string field and that would solve my problem. Any thoughts, is there a way around so that crystal reports will see the field in my csv or excel as a string field and not a number field?
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
Free Tool: Site Down Detector
LVL 9
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 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
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

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