Crystal Reports

35K

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

Need to have a pie chart in a Crystal Report reflect the FMV %. In other words, as the example attached, I need to show 21% of the pie chart out of 100%. I have already added the same field that FMV % is using but cannot figure out how to make it display in percentage within the Pie chart.

Any guidance will be greatly appreciated.
Capture.JPG
0
HTML5 and CSS3 Fundamentals
LVL 13
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I am using Visual Studio 2008 for developing a project in VB.NET .  I have built a report using crystal reports (in Visual Studio 2008) in the project which contains Barcode.  I had assigned code 128 AB Tall as the font but when I try to export it to PDF it generates ERROR.  I then tried the font Code 128, this time it got exported to PDF correctly but when I tried to read the barcode through barcode scanner, it won't get read.

I shall appreciate Insights to resolve the above situation.

P.S : I am attaching the snapshot the the error I am encountering during the export.

Thanks.Barcode-Error
0
I am trying to view Crystal Reports on a new web server. We are using classic ASP, and I get the following error message when trying to view report
Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/CleaningSvcsSG/reports/AlwaysRequiredSteps.asp, line 21

800401f3

Line 21 is
Set session("oApp") = Server.CreateObject("CrystalRuntime.Application")

Please help.
0
what is the name of the 'management console' which is used to manage security/permissions/users in sap business objects? And where does all the configuration data reside relating to the security configuration, e.g. does business objects come with a standard database for storing configuration information, and out of interest is that typically oracle/mysql/MSSQL.
0
My report has a sub-report for Freight Hours using a formula as a lookup.  I get the hours, but need a Shared NumberVar so I can use the hours (which all works fine) and multiply by it's Unit Cost.

My main report needs to summarize the detail lines in a Group Footer using sum (without showing the detail lines which also contains the sub-report for the Freight Hours).  Since CR won't let you use Running Totals on Shared Variable I had to use create Formula Fields using WhilePrintingRecords for summing Freight Cost for the Item, Customer & Company (adding these to details section b with reset Formula Fields setting the Variable to 0 in its respective Header)

The problem is, if I hide or suppress the detail lines, WhilePrintingRecords will not evaluate so my Group sums correctly the Qty, Sale Price, Cost of Goods Sold, but shows the Freight Cost (the Sub-Report) as 0.  Therefore the Profit/Loss does not deduct the Freight Cost.

If I show all the details a, b, c, the report runs perfectly (but they only want to see the summary not every detail line)

Is there a way to hide the detail lines, but let CR calculate the Fromulas based on WhilePrintingRecords (I don't want to shrink the detail lines as some Items might have 50 detail lines others 1, so even minimal detail height will still make the report's look inconsistent)

Other than creating another Sub-Report to bring in the summary line, with a the current Sub-Report for the Freight Hours is there another way of …
0
I am a newbie with VB6 and Crystal, so I apologize for my simple question.

I am trying to integrate VB6 and Crystal 11.5 and I can do everything I want if I use the Access db.  We are now switching to SQL db and I can get the reports to work fine on the Dev machine, but not on the Deployed Computers.
Is there a tool to use to tell me what control or dll is missing?

I am using RDC with ADO and I keep getting a 429 error Axtivex cannot create object.
I've registered all the dlls that I know of.


Dim crxApplication As New CRAXDRT.Application
Public Report As New CRAXDRT.Report

 ConnectionString = "Provider=SQLOLEDB.1;DSN=" & SQLServerName & ";" & "Password=" & SQLPassword & ";Persist Security Info=True;User ID=" & SQLUsername & ";Initial Catalog=LimitlessDailyTransactions;Data Source=" & SQLServerName
            ConnectionString2 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DB & ";Persist Security Info=False"
            Adodc1.ConnectionString = ConnectionString
            Adodc2.ConnectionString = ConnectionString2
           
            Adodc1.Refresh 'sql DailyTransactions
           
            Adodc2.Refresh  'xl.mdb
           
            Set Report = crxApplication.OpenReport(DatabaseFolderLocation & ReportName)
            Report.Database.Tables.Item(1).SetDataSource Adodc1.Recordset, 3
            If BolSingleTable = True Then
            Else
                Report.Database.Tables.Item(2).SetDataSource Adodc2.Recordset, 3
 …
0
dear all ,
How to use interactive sorting control in crystal report in visual studio as it is shown in the designer but hidden when the report is previewed?
0
I upgraded a .NET app from VS2008 to VS2012.  I had to upgrade crystal reports to version 13.  I deploy using ClickOnce.  The application installs and runs with no problem.  However, when I click on a report I get the attached error.

Any ideas how to resolve?
CrystalDecisions-Error.jpg
0
I am receiving error "Unable to find the report in the manifest resources.  Please build the project and try again".

I am trying to remove or select a report from report source on the CrystalReport1Viewer1.
ReportSource.JPG
0
I have a number of Crystal reports from the same VB.net program that are not accepting / transferring / referencing the database details for the connection.  Attached is the screen shot of the error message and the code that is used to populate the connection.

Can someone please shed some light on the issue?
DBConnection.PNG
DBCode.PNG
0
Expert Spotlight: Joe Anderson (DatabaseMX)
LVL 13
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

I have developed an asp.net web app and  crystal report for reporting. It generates pdf/word/excel/rtf reports.
I need to get it working on a dot matrix printer. The printout is not clear at all.
0
Hi,

I have a proxy server which is windows 2012 server and I route to another webserver using reverse proxy. The webserver is windows 2003 and we have an asp.net application installed.
All the functionalities are working fine except when I try to generate excel thru crystal report I am getting bad gateway error.
IMG-20190117-WA0041.jpeg
IMG-20190117-WA0043.jpeg
IMG-20190118-WA0018.jpeg
0
Hi, Just dropping this question again with some more detail to see if i can get a work around.

I am in the process of converting a large number of Crystal Reports to SSRS. I have hit a snag with a number of Running Total issues. we have over 25 reports that need to been converted but they all have a running total as a grand total, typically evaluating on group, outside of the group. In some cases these running values are used in other calculations. It is a nightmare.

As you can imagine I can not get this to work as if I write a running value expression on group it is outside of the group scope and does not work, and if i set the scope to "dataset1" the value is not correct as it needs to evaluate on group.

I have read through many links but i can't see how they will work, but i might just have a skill gap, none of them cover where the running total evaluating on group are used as a total only.

I have attached an example of one of the reports that has a running total, it is only one of the possible layouts and ways the previous reports used the running totals. but does highlight the issue i am hitting. If possible i would rather do this within the ssrs report but i am at a loss on how to get it to work.

We are on SQL 2014 but are about to migrate to 2016

Any ideas on a way to get this to work?

Example-of-Running-total-in-Report.JPG
0
On a GH2b section..A sub report is inserted...The GH3b section is showing the shared variables....the problem I am having is that the last line of the GH3b data is repeating...
Example is enclosed...Not sure what I am doing wrongPreview of a reportScreen-Shot-2019-01-08-at-6.17.09-PM.png
0
I need to modify a Crystal report. Currently it shows a row for each entry in a table. I want to only show the first 5 rows, regardless of how many are in the table, as columns. Here is an example.

Current Result                              
                              
Record      Inspection Number      Inspection Value                  
1      20039      0.3                  
2      20039      0.4                  
3      20039      0.5                  
4      20039      0.3                  
5      20039      0.3                  
                              
                              
Desired Result                              
                              
Inspection Number      Inspection Value 1      Inspection Value 2      Inspection Value 3      Inspection Value 4      Inspection Value 5
20039                  0.3                  0.4                  0.5                  0.3                  0.3

I'm sorry that the columns don't line up but I'm sure you get the idea. How would I write this query and/or modify the report?

Thank you.
0
Want to print continuous crystal report using from range, below attaching image of what i want to achieve:

How can i print continuous crystal report?
Also i'm using this code to print single report
public void GetInvoiceRpt(string strReportName, string strVno)
        {
            try
            {
                int compcode = Convert.ToInt32(Application.Current.Properties["CompId"]);

                ReportDocument cryRpt = new ReportDocument();
                TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
                TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
                ConnectionInfo crConnectionInfo = new ConnectionInfo();
                Tables CrTables;


                cryRpt.Load(strReportName);

                crConnectionInfo.ServerName = clsconnection.SQLServerName();
                crConnectionInfo.DatabaseName = "MyApplication" + clsconnection.getCompanyCode(compcode);
                crConnectionInfo.UserID = clsconnection.SQLLoginID();
                crConnectionInfo.Password = clsconnection.SQLPW();
                CrTables = cryRpt.Database.Tables;
                foreach (Table CrTable in CrTables)
                {
                    crtableLogoninfo = CrTable.LogOnInfo;
                    crtableLogoninfo.ConnectionInfo = crConnectionInfo;
                    CrTable.ApplyLogOnInfo(crtableLogoninfo);
                }
                cryRpt.Refresh();

                cryRpt.SetParameterValue("@voucherno", strVno);

    

Open in new window

0
I created a click-once install for a .NET app.  Crystal reports is downloading and installing.  The problem is that the download location is wrong.

An error occurred downloading the following resource:
http://xxxxxx.com/downloads/CrystalReports10_5/CRRedist2008_x64.msi

Should be

https://xxxxxx.com/xxxxxx/CrystalReports10_5/CRRedist2008_x64.msi

How can I set the correct location?  It should be https and xxxxx not downloads.
0
​Hi there! I need to get a runtime for my Crystal Reports 11.5.0.313. My users can't get to print the reports in my software.


Many thanks in advance!
0
Crystal Reports 101 Question
Setting a schedule for a Crystal Report:
I login to CMC,
Navigate to the report using the directory tree
Rt-Click on report and select properties
Hit the drop down for Schedule and select Recurrence.
Set the START and END appropriately
Save by clicking the Schedule button
When I open the schedule again, I can't tell where it was set.    Is this a permissions problem?  Have a look at the screen shot attached in the file.Login-to-CMC-Crystal-Management-Con.docxLogin-to-CMC-Crystal-Management-Con.docx

Moreover, how can I tell if my permissions are lacking for running the schedule correctly?  Please help!
0
Become a CompTIA Certified Healthcare IT Tech
LVL 13
Become a CompTIA Certified Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

I want to be able to create a crystal reports cross tab week comparison from last years order sales to this year order sales for a specific month.
Eventually I want to compare more then 2 years but for now I want just two. The schema should look something like this.

                           MONTH OF SEPTEMBER COMPARISON
            1st week                2nd week      3rdweek                 4th Week
2017     $3,000                  $3,200                $3,000                    $4,000                
2018     $4,000                  $3,500                $3,500                    $4,100
0
BarCodes in Crystal reports:
I am trying to make my barcodes wider when using Crystal to print them.   I tried messing with the Character Spacing Exactly but anything other than 0 makes them smaller.  
My Font is an IDAutomationC128M

I am not a Crystal person and have been looking around on how to make them wider?
Any ideas would be appreciated.
Thanks
0
I have an issue with the link between VB.net and Crystal reports.

I want to produce an invoice for a customer.  I have produced the invoice on crystal reports and I have produced all data needed on VB.net but how do I send information from VB.net to Crystal reports.  Obviously I need to pass data per invoice number and client using the software. example companycode ="XC029" invref = "1500"

       Dim directory As String = My.Application.Info.DirectoryPath.Replace("\bin\Debug", "").TrimEnd()
        Dim cryRpt As ReportDocument = New ReportDocument()
        Dim InvRef As String
        Dim showMsg As Boolean

        cryRpt.Load(directory & "\rptSalesInv.rpt")
        InvRef = txtSIInvRef.Text
        cryRpt.RecordSelectionFormula = "{vwSalesInvDistinct.InvRef} = '" & invRef & "'"

        Dim crtableLogoninfos As New TableLogOnInfos
        Dim crtableLogoninfo As New TableLogOnInfo

        Dim CrTables As Tables
        Dim CrTable As Table
        Dim s As String = ConnstringSQL

        Dim parts As String() = s.Split(New Char() {";"c})

        Dim crConnectionInfo As New ConnectionInfo()
        With crConnectionInfo
            .ServerName = parts(1).Split(New Char() {"="c})(1)
            .DatabaseName = parts(2).Split(New Char() {"="c})(1)
            .UserID = parts(3).Split(New Char() {"="c})(1)
            .Password = parts(4).Split(New Char() {"="c})(1)
            .IntegratedSecurity = False
        End With

        CrTables = …
0
I'm trying to create a new report using Crystal Reports 2008.
The issue I'm having is that the main link in an oracle db is string format and the other db has the field I need as a number.
Is there a way I can use the cast command to link the 2 fields?
If there is a different way, I'm open to suggestions.
0
We have created a cross-tab report in Crystal Reports 14.1 pulling sales data from our Epicor P21 data, summarized annual sales by customer.  It currently sorts by total overall sales after displaying columns of annual data.  This results in a report which looks like this:

                        Year      Year     Total
Customer      Data      Data     Greatest
Customer      Data      Data     ...
Customer      Data      Data     Least

We would like to sort on the current year rather than the total.  We can't seem to find a way to do that.
0
I have to prepare a report, in which it contains nested subreports...i know that nested subreports is not possible in Crystal Reports. can some body tell me how to proceed with this issue.
I have Main Report which contains a subreports, which internally contains a subreport in it.
please help me with this!!
0

Crystal Reports

35K

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.