Crystal Reports

34K

Solutions

5

Articles & Videos

12K

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.

Refine results

Crystal Reports 2016

Is it possible to pass a value to be used in a stored procedure from crystal that does not use a parameter prompt?  I ask becuse I wish to use the same sp for various values an…

311 views
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Let me start by stating that I have never used Crystal Reports in the past.  I was recently asked to purchase and install Crystal Reports 2016 Server so that we can connect to a SQL database that hous…

57 views

Hi Experts

I have what I thought was going to be very simple but I can't seem to get any of my solutions to work.  I have a modified date as one field and I want to make sure that the query only re…

211 views

Is there a way to print duplex but having a page break between say the internal and customer copy of an invoice? Basically, avoid having the first page of the customer invoice print duplex on the last…

617 views

Gurus,

I created a series of reports that include "conditional count/sum" formulas like this:

if {TBL_HISTORYTYPE.NAME} = "Client Visit Completed" then 1 else 0

Unfortunately, I recently foun…

313 views

I Have a main report with 2 groups and 1 detail section.  The subreport is in the detail section as each record on the main report might/might not have a matching subreport record.  The records I need…

2451 views

Crystal Reports 2016

Can a CrossTab report display a value in one column and that percentage in another?

Example:

Agency               Count             Percentage
   1                      …

29 views

Is there a way to get Crystal Reports to default to using a left outer join when linking tables?  By default, it always uses an inner join.  I have to click on each link, select Link Options, and then…

312 views

I currently have several projects using CR2008 and I don't want to break them.
can I install without overwriting the CR2008 files?
Thanks!

411 views

I'm using Crystal Reports.

I have a sql server table that looks like this:



My Crystal Report layout looks like this:



When I run my Crystal Report it looks like this:



If you not…

119 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Not sure if this is possible or not ... if not, I need to think of an alternative way to handle the rest of my report.

I need one field to display in my Group 4 Header that is presently not there,…

612 views

I had this question after viewing Crystal reports subreports as total of main report (https://www.experts-exchange.com/questions/28978763/Crystal-reports-subreports-as-total-of-main-report.html).

W…

1035 views

Crystal Reports 2016

I have a formula where I want to sum a field based on a Datetime field called E911Data.EntryDateTime using a parameter value -1 to get the records from the previous year then t…

211 views

I had successfully built a project in VS2013 using vb.net.  I added the CRforVS_13_0_17.  I deployed in a clients server with no problems.
When I installed on the next server the client already has C…

1736 views

This relates to an earlier question I had previously accepted.

I have a medical claim form that has 22 line items on the form and a subtotal line that should produce a total for that page. My clie…

312 views

Is there a way to put a mask on the parameter to force the entry to be uppercase? BUT the string that will be entered is a combination of letters and numbers and no max length.

2832 views

hi there
i am on crystal reports in vs
if the column is empty i want to set n/a string
i need a formula

i try do this :
if({CocDet.GelemMet}="")
then
"N/A"



how can i set it ?

t…

214 views

In my report, I have to have 2 fields, one that's called previous department and the other is called new department for an employee.
 That database stores this value in a field called A_Value.
 Ex…

840 views

I need to get up to speed with crystal reports very quickly.  Is there a free program i could download to get started learning it? Any advise on where to go first to start learning?

737 views
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Hi Experts,

My reports are showing two types of pagination while generating. Is it because i have missed out something.

Attached screenshot:

Below is required format:


The issue happens o…

730 views

In my Stored Procedure, I have a field "TotalPagesPerClaim". Per my clients request, they would like to have the "EstimatedAmountDue" total printed on the last page only and not sub-total per page as …

834 views

The bank wants the check amount in format DDDDDDDDCC

52.34
17754.35

I want:
0000005234
0001775435

I tried
ToText({chck.chck_amnt},'0000000000',2,"","")

and the results are:
000000005…

122 views

How can I bold {@DisplayPersonQualifier} results within another formula.

Formula: DisplayPersonwithQualifier

{@DisplayPersonQualifier} & ' - ' & {@DisplayPerson}

423 views

I'm on BOE server 2011, and I'm having an interesting time managing user in-and-out of groups for security purposes, the most glaring example I'm dealing with now is my inability as an "Administrator"…

824 views

Hello to all. I am newbie so I need your help.
I have situation in crystal report x10.

Group header fields:

NAME OF PRODUCT (given by formula) and QTY (from the database)

SAMPLE 1           …

1338 views
Show more content
201506-LO-Top-001
Top Experts In
Crystal Reports
<
Monthly
>

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. DB Reporting Tools
    (8,005)
  2. .NET Programming
    (131,532)
  3. Visual Basic.NET
    (91,860)
  4. ASP.NET
    (123,019)
  5. Visual Basic Classic
    (163,556)
  6. MS SQL Server
    (156,654)
  7. MS SQL Server 2005
    (71,484)
  8. Databases
    (53,488)
  9. C#
    (91,122)
  10. Oracle Database
    (77,856)