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

Hello,

I have a field in which my boss wants two separate parameter prompts on the same field (I have always used a range parameter).

The two prompts would be 1.) |enter first number| and 2.) |e…

913 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.

Hello,

I am getting the above error when I run this formula:

{vw_reporting_biannualaudit.Drug Schedule}={?@Drug_Schedule}

and  

if  isnull({?@Drug_Schedule}) or not numerictext({?@Drug_Sch…

713 views

Hello,

I have a report footer that is just basic text boxes that I want to repeat 5 times.  Is there any way to do this?

Mike

69 views

Hello,

I have an 11 digit field that has to be separated with dashes.  For example, 11111111111 would need to change to 11111-1111-11.

Thanks for any help,

Mike

68 views

Hello,

 I have a field in which my boss wants two separate parameter prompts on the same field (I have always used a range parameter).

 The two prompts would be 1.) |enter first number| and 2.) …

1118 views

Previously when using VB6 and Crystal Reports I was able to specify the contents of an image at runtime.  This allowed the invoicing app to use the customers letterhead loaded from a jpg on their pc. …

825 views

Hi Experts;

I have a three part formula used to suppress a group header when all of that group's details are suppressed. I had to use a three part formula since the actual suppression condition is …

1010 views

I'm using Crystal Reports 2016 and want to ask if there is a way to add a Checkbox function in Crystal reports. i.e. when the report is run for example to have a 'Yes' and 'No' checkbox. The user view…

413 views

Hello,

I’m wanting to trim a field.

I have a product code like the following:
100003.BLK.SML
104+YEL+LRG
1005-GRE-XLG

I need to trim the code so it appears like below taking into account t…

713 views

I have the following code to export Crystal report to .pdf file ( VS 3.5):

public string Export(ExportFormatType exportformat, string[,] parname_value)
        {
            ReportDocument crRepo…

522 views
Cisco Complete Network Certification Training

If you’re an IT engineer or technician, it's time you take your career to the next level. This elite training bundle is brimming with all of the information you need to learn to sit for Cisco CNNA, CCNP, and CCENT certification exams.

Gurus,

I need a formula to concatenate and separate 6 Boolean fields together where one or more may be true.

For instance, Field 1 may be True or False.  If True then "Field 1" else ""

I need…

416 views

I have a Crystal report 2016 and want to show images, the image path is in sql and shown below

M2ENL1\Pack_12\11879\Event11879_7e4c5cd3-105b-4acc-a32f-ef76386926ee.jpg

Below Image is the actual …

320 views

Hello,
      I have a report that has several subreports in it. I have 2 parameter fields to define the

criteria for the report. The report runs ok and I like the results, however, with the way the re…

318 views

I'm writing a time card report to list attendance transactions for an employee based on a date range.  Some transactions will entered for a vacation day, sick, day, or holiday.  The field in the recor…

620 views

Crystal Reports IX
SQL 2014

I have a report with multiple parameter values.  There are four parameter's that check on single field.  I want to allow the report to ignore any of the second, third o…

2218 views

Hello,

We're in the process of moving our SQL server to another box again.  This means we will have to update all our Crystal reports data sources once more.  Before, we used rptInspector and that …

218 views

Crystal Reports XI
MS SQL 14

Thanks to everyone's help I have the dynamic images displaying properly.   I'm trying to make the reports look more polished if the search fails to return data.  I hav…

1128 views

Hello,

I have a Product Value Report as at date which I run on my SQL Database (via my accounting software) which gives me the location value of stock as at a date.  

One issue I have with the r…

527 views

Hello,

I have a data field in my Crystal report displaying the following:

COSS00385<XXXXXXXXXXXXXXX

How can I left and right trim this field so it only displays:

SS00385

Thank you

224 views
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

I have a cross-tab report that reports results of a quantity shipped and compares quarter over quarter (example: Q2 2015 to Q2 2016)
Is there a way to have the report take the value of each quarter a…

518 views

We have an EHR that uses SQL Server 2012 and we use a Topaz pad for signatures. The image is stored in a table as a varbinary (max) and I'm wondering is there a way to get this image to show up in Cry…

224 views

Using Crystal Reports IX
SQL 2014

I have developed reports where there is a department logo image currently embedded in each report header.  I would like to be able to dynamically change the depar…

1232 views

How to make normal cursor to Hand cursor while mouse pointing  over the group headings when viewed in the CR Viewer.  I am using using Crystal Reports 2011 that ships with Visual Studio 2010.

Thank…

436 views

Hi Experts,

I'm using Visual Studio 2013 Ultimate.
I'm using the Customers table of the Northwind SQL Server Database.
I'm using SQL Server 2012.

At this link it shows the different versions o…

429 views

Using Crystal Reports IX with SQL Server 2014

 I need to exclude a value based on the value stored in a table field where I lookup the value in another table.  Since this report would be run by mul…

629 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. DB Reporting Tools
    (7,991)
  2. .NET Programming
    (131,260)
  3. Visual Basic.NET
    (91,587)
  4. ASP.NET
    (122,818)
  5. Visual Basic Classic
    (163,435)
  6. MS SQL Server
    (156,039)
  7. MS SQL Server 2005
    (71,389)
  8. Databases
    (53,329)
  9. C#
    (90,857)
  10. Oracle Database
    (77,634)