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.

Related Topics

  1. DB Reporting Tools
  2. .NET Programming
  3. Visual Basic.NET
  4. ASP.NET
  5. Visual Basic Classic
  6. Microsoft SQL Server
  7. Microsoft SQL Server 2005
  8. Databases
  9. C#
  10. Oracle Database
Refine results

I have a shared variable in a Report Header...I then have an ole object in the Report Footer..
My formula  ( X-2) for the Graphic after I have inserted the .pdf is

WhilePrintingRecords;
Shared …

318 views
Free Tool: Site Down Detector
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 am using crystal reports XI. The problem that I have is with a select statement....I think. Anyway, I am trying to select all PROVIDERS from the ORDERS table who have not received a specific order …

212 views

Why is the following formula giving me a division by zero error and how do I fix it?

EMSD.OnRoadLoaded}+{EMSD.OnRoadUnLoaded} / {EMSD.udNOofGallons

112 views

How can I get more than first page..

It is inserted in the Report Footer of the .rpt

616 views

I am using SAP Crystal Reports 2013 Developer Version

In chart expert there are already built-in charts available, but I want to add different chart type in it. How am I suppose to add different …

414 views

Good afternoon!  I have a 10 year fiscal evaluation report - I have created formulas for each year

if month ({?Current Fiscal Year Date To}) >= 7 then "FY"& totext ( year ({?Current Fiscal Year …

215 views

I am experiencing and odd issue with Crystal Reports that is difficult to explain at best.

The issue I believe may be the ID I am pulling through my Stored Procedure may not be evaluated until the…

311 views

Hi there,

I have a bar chart with custom colours for each riser some of the legend colours aren't changing with the custom riser colours.  I can't figure out why.  Any help would be appreciated!

916 views

I created a PeriodDateRange parameter that contains multiple start and end date ranges.
I need to create a formula that I can use to group the report by PeriodDateRange values.

QUESTION:
How do I…

626 views

Hello,

Can you please help me insert a page break on change of field on my crystal report?
I have a field called Products.Category. When the data changes I have to force a page break.

Attached …

217 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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 had this question after viewing Microsoft ODBC SQL Server Driver Synatx Error (https://www.experts-exchange.com/questions/27684531/Microsoft-ODBC-SQL-Server-Driver-Synatx-Error.html).

Why do I …

219 views

Hi,

I'm getting an error when trying to print an extremely simple Crystal report from asp.net
Method not found: 'Void …

7117 views

I am looking for Multiline chart

My data is below

Name  Week1 Week2 Week3 Week4 Week5
Cat1     1              2            3           4          5
Cat2     10           20         30        …

1436 views

I have a report in Crystal that displays the count of days between Today and when a client last had a service. It's very simple formula
TODAY() - {v_rpt_ClientActivities_Prg_Epi_LDOS.LDOS}  I call …

219 views

I'm using Crystal Reports 2008

I'm trying to pass information from my subreport to my main report so that it can be used in a formula.

Subreport:Corp QtyAvail is used to sum up all the inventory…

214 views

I am actually using I-net report, but they are interchangeable.   I-net uses JDBC connections where as Crystal uses ODBC connections.

I'm having an issue with my SQL statement for record selection.…

317 views

I am trying to convert a date field to Spanish and having issues with the cast of the time. I need the time to return as 9:00 AM and I am getting this:

3 de marzo, 2017 9.00:0.00

My formula:

415 views

I have three separate groups based on three formulas to select records for specific time ranges.  I then have running totals for each of the three groups that give me the totals for each of the three …

220 views

We have to transition to a 4-4-5 fiscal calendar.  The issue will be in relation to Crystal Reports.  The Date Range selection will be totally different from what we have been accustomed to with …

1454 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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 situation where I need to calculate a standard deviation for daily amounts. The data set I have can have multiple entries per day. If I use CR’s normal standard deviation formula it gives me …

220 views

I am a novice when it comes to Crystal Reports. We have an ASP.Net application which uses Crystal Reports. The application was updated from the 3.5 framework to 4.52 framework. Crystal Reports for …

464 views

I have the following

WhilePrintingRecords;
Shared Numbervar TimeInBay;
Shared Numbervar MatHandl;
Shared Stringvar Missing;


If {vwJobTimeFields.Op/WC} = '1' then {vwJobTimeFields.BayTime} =…

218 views

Hi Experts,
I am using Crystal Report with my C#.Net application.
My report prompts for multiple parameters.  I want Crystal Report to prompt for each parameter in it's own window (see images …

249 views

Hello Experts,

What kind of Crystal Reports license/software do I need to do:

1) Develop new reports
2) Publish Crystal Reports on the web so our users can run them by selecting different …

434 views

I have 2 report footers..a and b....and a page footer...The page n of m on the last page says 1 of 1...

Each Report footer is a full page.. can't change that..

How can I get the Page footer Page…

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

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.

Related Topics

  1. DB Reporting Tools
  2. .NET Programming
  3. Visual Basic.NET
  4. ASP.NET
  5. Visual Basic Classic
  6. Microsoft SQL Server
Top Experts In
Crystal Reports