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

I'm running into the below error when using the OLE DB (ADO) SQL Server Native Client 10. Server is running SQL Server 2008 R2. We are able to make a connection using Microsoft OLE DB Provider for SQL Server fine however the reports are putting out unreadable data. Thanks in advance.
Crystal reports error
0
On Demand Webinar: Networking for the Cloud Era
LVL 8
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Good Morning All;
We are creating a report which will show a distinct count of cartons which have specific total units.    For example we have 5 unique cartons that have a total of 3 units, we have 10 unique cartons that have a total of 4 units and we have 6 unique cartons that have a total of 10 units.    On the report we currently have each carton number and a sum showing the total units within each carton.  We need to create a Grouping that would show something like this:
Week #43     Total Cartons  10             Each Carton Contains 5 Units
We cannot do a distinct count of cartons because there are various totals for each carton so we thought a distinct count of the Units within a carton or sum of the units in a carton would do what is needed but we cannot do a distinct count against the sum.   We attempted to convert the sum to a text and then do a distinct count of the text but the text field is no available to select for a distinct count.       Is there a way to do this distinct count?

Appreciate any assistance.

Rosemary
0
I have Crystal Reports 7 (mr2). Its circa 2000 but is functional and fast, and it is used to support another program that is circa mid-80s. I add this point because there really is not a modern alternative and I am stuck with the 80's program.

I eventually coerced Crystal to run on Windows 7(64), to get away from the Windows XP box it is running on. It appears to work but for one problem. When running a report as an AD domain user the report fails with: "PEStartPrintJob : Error detected by database DLL." But if I log off and back on as the local Administrator, the report completes successfully.

The other point I would mention but might be nothing is that the startup file: "Seagate Info Startup" which launches: Sentinel, APS, Agent, and Analysis Server also fails to launch those programs as an AD user. I can launch the program manually and then it runs. Again its different behaviour as local Admin. The file launches from the StartMenu startup folder without a manual nudge.

Been scratching my head for the last 12+ hours or so. I doubt anyone out there is still using this antique but on the off-chance someone is, what's the trick? why doesn't CR7 like domain users?
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
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
I created a crystal report based on a command.  To speed up the query I have a date parameter in the command Parameter request 1.  This is OK, however I am prompted again for the same date parameters again once report is launched Parameter request 2.

Is there any way I can stop the report requesting the exact same parameters twice?

Thanks

David
0
latest version of crystal report
0
Good afternoon all,

I have a simple question.  I am trying to use a gauge on my report.  The report is a detail item report for a patient with all the cost associated with the case.  I think would like to see what the cost ration is so I take my total cost and divided them against the total charges,  I have created a Formula Field for this and I am getting the data as expected of 0.17 for this one case.  I want to place that value on the gauge to show how it falls in line.  I want to show that value on the gauge, but when I try and add the data field I created it wants to summarize it using Sum, Count, Average.  I do not need any of those as I have the value I want.  How can I get that value on the gauge?  I would also like to start the gauge color with green from 0 to 20 then change it to orange from 20 to 70 and then red for 70 to 100.

Thanks,
Rodger
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
Free Tool: Path Explorer
LVL 8
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

our crystal reports are working fine in development PC's in development environment (VS.NET). we are using ASP.NET and display reports in crystal reports viewer.

 But when i make the setup of install the application on deployment PC i get the error

"Invalid Table Number"

Deployment PC has .net framework, sql server but no report is working but the same code is running fine in development environment. Please let me know how can i remove the above error and display reports in browser. Also i found that sql 2008 is installed in the system i am installing my application. and if i install sql server 2005 it gets works, so is there any help that why sql 2005 is needed to be installed?
0
Hi,

I have fields License Number, Award Date, Drug Action Classification, International Birth Date in a 2*2 grid and all fields can grow. I have another field 'Name of the Product' which is next column of 2*2 grid but the 2 rows are merged. When I set the property fo the field to 'Can Grow' = true, then this layout breaks and below field is overlapped. I also tried putting fields in different sections, but then the layout of 'Name of the Product' all breaks and I am not able to have a layout as per client requirement. Kindly suggest a work around this problem.

Thanks in advance.

Rahul
0
Hi, I am unable to uninstall CR 2013 from my machine. I keep getting an Assertion Failure. Is there a tool or another way to uninstall the program? Thanks.
0
How  to get the list of parameter fields name from a crystal report  starting with sp_lbl
in asp.net web application.
0
I had this question after viewing 03 Feb 10 20 - Crystal Report Events in Asp.net.

I've posted the link above regarding an old post (7 years ago).  I"m utilizing VB.NET and I'm trying to access the Toolbar control to attach an event.  I want to override the CR Print button.  

When I use the above example to try to access the Controls, I only can see 2 objects.

MyReportViewer.Controls(0) = {CrystalDecisions.Reporting.WebControls.ParameterList}

MyReportViewer.Controls(1) = {CrystalDecisions.Web.CrystalReportPageViewer}

I'm unable to see anything past (1).  This is for a VB.NET website.
0
Hello,

I'm having trouble getting something to group.  Please see the note I made at the bottom of page two of the PDF.  I also attached the rpt file as well.

grouping.rpt

grouping.pdf

Thanks,
Joel
0
I have a report that has 3 sub reports, (old report which has declared values and adds them up on the main report)
I would like to get a combination of the cross tab(s) information summed into one cross tab if possible
so for example headings/Example
Cost Center     Description      Period A       Period B        Period C      YTD
12345               Text A               10                  25                   15                 50

The period costs would be a comination of Labour Parts and Purchases from the sub report cross tabs

Have attached the report for information
Is it possible?
Gordon
test-Work-Order-Costs-V3.rpt
0
Hello,

I'm creating a Job Bag for production where I need to calculate the number of sheets to be printed by the digital machines. I'm struggling when the Job contains several parts within the job. It seems to be adding all the part values instead of just the single part with several versions. (yes, it can become very complicated!!!)

So the following works for single part - single version jobs:

IF {rep_v_Impress_jobBag_Printing.EstimateId} = {MainJobDetails.EstimateID} THEN
IF ISNULL({rep_v_Impress_jobBag_Printing.versionLineNo}) THEN
{rep_v_Impress_jobBag_Printing.totalSheets}
ELSE (SUM ({rep_v_Impress_jobBag_Printing.totalSheets}))
ELSE 0


See attached more detail....

Any help would be appreciated.

PS: I only started creating Crystal Reports and followed only the basic course, so still new to all of this!!

Thanks,
GVD
Crytal-Job-Bag-issue.docx
0
Crystal Reports 2016
Beginner to Intermediate

Hello,

I created a normal report where I have Table A pulling from my database. I added some of its fields to my design and previewed it. Everything looked great, but Table A does not have all the data fields I need. So I then went to the Database Expert and added Table B from the same database. Several links were displayed between Table A and B. I located the field I wanted to add from Table B and dragged it into my report design (in the details section with Table A fields). I then clicked the preview tab and there was no data - from either Table.

Everything works perfectly, until I add a field from Table B - then all data in preview is gone.  

I would greatly appreciate some help! Thanks.
-Sara
0
Free Tool: SSL Checker
LVL 8
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 have a report that I need to alternate the color of each row.
I'm using the formula
select GroupNumber mod 2
case 0: crWhite
case 1: color(222,222,222)

but the problem is, I have a suppress statement on the row. So, the groupnumbers are 2, 3, 4,, 6, 7, 9 etc, So the alternate color is off since it's highlighting the odd numbers. Is there anything else I can use besides groupnumber?

2017-06-07_10-13-29.jpg
0
When connected via RemoteApp (on server 2016) to our application, users click print icon and get the print dialog. The dialog chooses the correct printer but add the checkmark in "No printer", which the user then has to remove to enable printing. Doing so for 100 prints is a bother.

How do I remove the checkmark? In CR I've removed the "no printer" checkmark. I've used a dummy printer that doesn't exist on either my system or remote host, to force CR to use the proper default printer. I've also tried setting the "no printer" checkmark, just as a test.

Is there something going on when RemoteApp server assigns printers? We had some trouble where local default printer wasn't transferred to server, so it defaulted to Windows PDF Writer instead...

Was using older version of CR, but making changes on the trial version: SAP Crystal Reports 2016 SP 4.

Any help?
0
I have set up the 2 reports. My requirement is to setup an alert for the first report when the report is blank(no data).

For this, i am taking a field which never be a null value and putting the condition as {@relevantRecord}=if isnull(commad.field1) in the alert condition.But when the condition is correct also, i am not able to get the alert message.

Please advice how to get notified if there is no data in the report
0
I have a report where user asked to select the date range in start date and end date.

Start date is 05/01/2014(mm/dd/yyyy) where i can restricted it should not go below the 04/30/2014(mm/dd/yyyy) - This is working.

where my question is End date should allow the calendar current date like 6/6/2017(mm/dd/yyyy). It should not enable 6/7/2017(mm/dd/yyyy) in Crystal reports.

Please help me on this.
0
We have vb.net 2010 applications that have Crystal Reports.

We have the latest version of Crystal reports for Visual Studio installed.

They work fine on windows 10 machines.

However, we started getting calls from some clients with Windows 10 Machines that they were getting an error.

I had a windows 10 laptop, so I tried it on that machine, and I got the error.

I do have Visual Studio 2010 on that laptop, but it didn’t have Crustal Reports for Visual studio installed, so I did that, and the application works fine.

I recompiled it and deployed the new executable, but app still getting errors on Windows 10 machines  that DO NOT have Visual Studio along with the Crystal reports for Visual Studio installed.

I thought when you build the executable, in brings along everything needed to run the app on other machines, no matter what they do or don’t; have installed?

What am I missing? How do I get this to work on Windows 10 Client machines?  Like I said, it works perfectly on Window 7 and < machines?
0
I am doing a project and there is a section for reporting, when I implement this I get all the values drom db but instead of this I need only to group the data based on status and for each group I need to get the total sum for a field in table called Total Amount. I have created a view in sql because the date is taken from two separate table in a db. From this view the data is retrieved and and downloading the page as report

controller

 public ActionResult ExportCustomers()
        {
           
            ReportDocument rd = new ReportDocument();
            rd.Load(Path.Combine(Server.MapPath("~/CrystalReports/Report.rpt")));

            var old = db.vw_Admin_Get_Booking_Det.ToList();
            rd.SetDataSource(old.Select(p => new
            {
                name = p.Name,
                mobno = p.MobNo,
                status = p.Status,
                bookingtime = p.Bookingtime,
                totalamount = p.TotalAmount,
                totalweight = p.TotalWeight,
                location = p.Location,
                post = p.Post,
                postalcode = p.PostalCode
            }).ToList());

            Response.Buffer = false;
            Response.ClearContent();
            Response.ClearHeaders();


            Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
            stream.Seek(0, SeekOrigin.Begin);
            return File(stream, "application/pdf", …
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.