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.

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

Hello:

For sales invoices in Crystal Reports, we have a Tracking Number field.  This field can contain more than one record.  (In an invoice, you can have more than one tracking number.)

For …

210 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

I am currently using Crystal Reports V11. I am possibly looking at upgrading to 2016 if I can "beat" this problem. When I design a report and connect to a MSSQL database I select the Data Source Name …

918 views

I have two table
EQUIP and TASKEQ
How do I create a report that shows Equip records that are not in the TASKEQ table
Do I create a certain join or something else,(an SQL Statement)
Gordon

816 views

I have this formula in my Crystal Reports 2008.  Usually it works fine, but if Sum ({@LY_MTDSum}, {@Line Items Grouping}) is a negative number, it doesn't calculate correctly .
If Sum ({@LY_MTDSum}, …

312 views

I have a report that contains a line chart.  The legend says Sum of Blah_Blah_Blah.

How can I change the legion to Blah_Blah_Blah?

210 views

Hello Experts,

I am trying to create a crystal report as follows.

Each row consists of an item,say, with it's details and OnHand which I can retrieve from a table.  I also need two more column …

114 views

I'm an IT report developer with a few miles on my belt. Officially we are the Business Intelligence team. We use SAP Business Intelligence Suite 4.2, aka BusinessObjects. I remember James Martin back …

637 views

Hi


I have a chart in Crystal reports – I want to show the X Axis as Year and Week number like 2017-19, 2017-20  etc

I am using the following formula
Replace (ToText(DatePart ("yyyy", …

311 views

I'm having difficulty excluding records on my crystal report.   My objective is to find all records in Table A that do not have a Match in Table B.   I've tried several different Inner and Outer joins…

416 views

Dear brothers and sisters, I am using crystal report in VB.Net and i have DB field name "workingdate" to show on report, but i want it display Sunday if day of that data is Sunday like that:

235 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 report that wants to show a patients medications and their contraindications. Problem is if I put the one med in there with it's dose and start date etc. it adds multiple rows for each …

421 views

Hi Experts -
I have a report showing open orders, both past due and future - the ship date (a formula named @due_date) being Group#1.  I needed order lines past due to to display 'Past Due', rather …

227 views

How do you create a trendline on a bar chart using Crystal Reports 2013?

429 views

I have a report that I am using a sub form to retrieve a calculated value from a table. In the main form I have the correct value being retrieved for all the records in the column, but I need to …

543 views

Dear all brother or sister, i am working on VB.net application with crystal report and i have two field and want to put it on the same place and condition it if it zero or null it will …

243 views

In the web.config conection string is there a way to tell it to use windows autertication.

 <add name="MeatProductsConnectionString" connectionString="Data Source="";Initial Catalog=""  Integrated …

236 views

I need to pull the maximum score(s) for each test code,
Example S10 - Test score code  (What is the highest scores?)
                S11 - Same
                S12 - Same
Students can have more …

728 views

Hi.

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

Is it possible to freeze one column and show the rest detail section.

733 views

I am using crystal report to print a packing slip. I found a way to use a database view to do it. The question i have is i wan it to be able to have the program to have a variable to use in a where …

355 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 Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer

When I view report on Crystal Report Viewer, CTRL P keyboard functionality does …

743 views

I am using Crystal Version SAP BusinessObjects Crystal Reports 2013 Support Pack 4 Version 14.1.4.1327 CR Developer. Whenever we export report in PDF using crystal report viewer the font size get …

134 views

Hi,

We have a CRXI report with a watermark.  We want the watermark to show in all sections EXCEPT group footers which contain subreports.  The subreports should not show the watermark.  Is there a …

636 views

I need to modify an existing Crystal Report where the data is populated by a VB.Net helper class which calls a stored procedure and returns a dataset which is then passed to Crystal Reports via a …

358 views

I have a Crystal report with FIVE report footer sections - Report Footer a has the totals for the main report data.   Report Footers b, c, d & e each have cross-tabs summarizing the data in various …

536 views

Hi there
Up till now when I ran any of my crystal reports via the refresh button they would run all the way to the last page. I could hit the button and walk off and when I came back the report would…

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

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.

Related Topics

  1. DB Reporting Tools
  2. .NET Programming
  3. Visual Basic.NET
  4. ASP.NET
  5. Visual Basic Classic
  6. Microsoft SQL Server