×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Business Objects: Crystal Reports 4 Other topics FAQ Index

FAQ Index

Common Formulas

FAQ Title Author Date Rating/#
3 different fields to same row  faq149-309 CarolS 29 Nov 00 5.0 / 23
Calculating the number of Business Days between two dates   faq149-4466 Reebo99 21 Nov 03 6.0 / 6
Common formula examples  faq149-243 kenhamady 19 Jul 08 6.0 / 193
Crystal SQL and Date Parameters   faq149-1221 HowardHammerman 28 Oct 01 6.7 / 11
Data Types in Crystal Reports  faq149-732 kenhamady 5 Jun 04 6.1 / 30
Excluding null values when executing distinctcount   faq149-1489 dataprincess 23 Jan 02 4.2 / 5
How do I determine the correct accounting month based on '4-4-5' accounting periods?  faq149-1961 rhinok 5 May 04 5.8 / 6
How do I subtract one datetime field from another and display days, hours, minutes and seconds?   faq149-1215 HowardHammerman 27 Oct 01 6.9 / 18
How to setup printers + properties in VB   faq149-572 cturland 20 Mar 01 5.0 / 6
Two simple UFL functions to return username and machinename   faq149-1283 ScottWebb 20 Nov 01 6.5 / 8
What is a SQL Expression?  faq149-1376 rhinok 21 Jan 05 7.9 / 38
Working with rolling dates   faq149-1220 HowardHammerman 28 Oct 01 6.8 / 9
 

CR Printer Dialog Box

FAQ Title Author Date Rating/#
How to bypass CR Print API to select printer properties...  faq149-346 bburnell 21 Dec 00 8.0 / 7
Selecting a different tray to print from through CR and VB   faq149-2029 bburnell 13 Jun 02 6.5 / 4
 

Data Access

FAQ Title Author Date Rating/#
CHANGING DATASOURSE OF COMMAND OBJECT. (ADD COMMAND (SQL) ).   faq149-7096 Crystalboy1 29 Oct 08 --
Data Access for the Developer using Crystal Reports.   faq149-539 dcm 11 Mar 01 6.9 / 16
How to pass Database logon info to a Crystal Report at runtime in VB .NET or in C#   faq149-4870 essa2000 20 Feb 04 6.5 / 2
How to pass stored Procedure Parameters to the report?   faq149-562 emcevoy 17 Mar 01 4.8 / 18
Reporting off an ADO.net dataset using Visual Studio.net   faq149-5585 LikePork 23 Dec 04 1.0 / 1
Using Crystal Version 7 with MS Access 2000   faq149-1216 HowardHammerman 27 Oct 01 5.8 / 4
Why can't I report off of Access 2000?   faq149-552 emcevoy 14 Mar 01 8.6 / 7
 

Exporting issues

FAQ Title Author Date Rating/#
Special characters or extended font character sets not exporting correctly   faq149-3874 mrudolph 10 Jul 03 7.5 / 4
 

Headers and Footers

FAQ Title Author Date Rating/#
How to handle Orphaned Group Headers   faq149-4445 MRWARNER 17 Nov 03 1.0 / 1
 

Installations

FAQ Title Author Date Rating/#
Crystal 8.5 Installation Bug   faq149-1915 KLayton 13 May 02 9.7 / 12
Installing Crystal Reports 7 on Windows 10   faq149-7496 cq 23 Jan 18 --
Multiple versions of crystal reports or Info   faq149-651 emcevoy 16 Apr 01 7.5 / 20
 

Printer tray selection

FAQ Title Author Date Rating/#
How do I get Crystal to select a different printer tray from Visual Basis  faq149-119 mikemer 9 Jul 00 5.8 / 24
 

Printing Crystal Reports

FAQ Title Author Date Rating/#
How do I schedule a crystal report to run automatically?   faq149-1479 dgillz 14 Mar 02 7.3 / 56
Printing reports in Landscape using Crystal 8.5 Active X   faq149-4776 BigKahunna 27 Jan 04 2.0 / 1
Setting up new paper size / Setting up a printer to work with Continuous / Computer Held Stationery   faq149-984 JustineB 10 Aug 01 5.2 / 12
 

Questions should include:

FAQ Title Author Date Rating/#
Getting fast, accurate help   faq149-3762 synapsevampire 21 Jun 03 6.7 / 24
What information should I include in my question?  faq149-237 kenhamady 5 Jun 04 6.5 / 38
 

Report Application Server

FAQ Title Author Date Rating/#
Why don't my reports get cached?   faq149-3729 hhiebert 16 Jun 03 2.0 / 1
 

Report Development

FAQ Title Author Date Rating/#
Can I still use compiled reports with Version 8 or 8.5?  faq149-277 kenhamady 19 Jul 08 8.6 / 50
CR 8.5 Logonserver not working for password protected databases   faq149-4202 Harshu 20 Sep 03 7.0 / 3
Creating a manual cross tab report   faq149-1219 HowardHammerman 27 Oct 01 8.7 / 39
Date Tables and Mock-Crosstabs   faq149-7525 Madawc 21 Nov 11 --
Dealing with Virtual pages in a crosstab   faq149-4496 Stoffel24 1 Dec 03 7.0 / 2
Displaying a Random Sample (number or proportion)   faq149-3261 IdoMillet 3 Mar 03 7.8 / 6
Generating Reports using Stored Procedures for Visual Basic Front Ends  faq149-260 AaronA 19 Oct 00 5.4 / 12
How can I pass a Recordset from Visual Foxpro to Crystal Reports using a Stored Procedure for the SQL query?  faq149-465 LeonelSanchezJr 7 Feb 01 7.3 / 3
How can I use Memo fields, very long fields or VarChars in v8.x?  faq149-276 kenhamady 5 Jun 04 6.9 / 23
How do Duplicate Records based on a Quantity Field?  faq149-3226 IdoMillet 19 Apr 10 8.1 / 8
How do I improve report processing performance?  faq149-489 emcevoy 13 Feb 01 7.8 / 35
How do I pass date parameters to sub reports and use them in the selection criteria?   faq149-1329 BFAGG 6 Dec 01 6.9 / 34
How to Apply a TopN Sort to a CrossTab  faq149-4922 IdoMillet 9 Mar 04 10.0 / 1
How to create a page total   faq149-1295 HowardHammerman 23 Nov 01 8.6 / 5
How to open crystal reports from ASP  faq149-1396 menazbk 25 Dec 01 4.2 / 13
How to schedule a report from Outlook Public Folders  faq149-311 troyu 29 Nov 00 4.0 / 3
Manual Crosstabs Revisited   faq149-1639 Roadkill150 14 Mar 02 10.0 / 3
Page numbers for multi-page Crosstab report.   faq149-1575 PKG 4 Mar 02 6.1 / 7
Selecting Blank Values   faq149-1217 HowardHammerman 27 Oct 01 7.6 / 14
Sort Report in the Order of Multi_Valued Parameters   faq149-4505 IdoMillet 26 Nov 03 3.8 / 4
Using Crystal Do Loops for Repeating Groups   faq149-1916 KLayton 13 May 02 4.5 / 8
Using non standard text characters   faq149-1127 FoxG 28 Sep 01 3.5 / 4
When I export (Crystal Ver 9) to Excel, I cannot place borders around my report. See my answer on how to..   faq149-4675 minnasa 7 Jan 04 8.0 / 1
Why Aren't Parameter Fields' Default Values Dynamic?   faq149-1485 dgillz 22 Jan 02 7.4 / 13
Work Around to use Memo Fields in Formulas   faq149-951 MsPepperMintUSA 30 Jul 01 4.0 / 1
 

Running Totals

FAQ Title Author Date Rating/#
Conditional Running Totals   faq149-1218 HowardHammerman 27 Oct 01 6.1 / 18
What are the different ways to do running totals?  faq149-182 MalcolmW 15 Aug 00 7.1 / 56
 

Seagate Documents

FAQ Title Author Date Rating/#
Can I search the Business Objects Knowledge Base?  faq149-250 kenhamady 19 Jul 08 6.2 / 18
How to suppress a section containing a blank subreport  faq149-270 MalcolmW 9 Nov 00 6.9 / 8
Links to Key Seagate Development Documents  faq149-213 FowlerConsulting 4 Sep 00 5.1 / 10
Report Parameters - Number of default values limit   faq149-811 FoxG 8 Jun 01 7.5 / 8
What are the differences between Crystal versions?   faq149-570 emcevoy 19 Mar 01 7.4 / 5
 

Subreports

FAQ Title Author Date Rating/#
Adding subreports cause my report to open/run slowly.  faq149-5356 caimoss 5 Aug 04 4.5 / 2
How do I get page headers in a subreport?  faq149-5353 hilfy 8 Sep 04 9.5 / 4
How to include OnDemand Subreports in an exported file   faq149-6475 sayden 22 Nov 06 --
 

Types of Variables

FAQ Title Author Date Rating/#
What are the different types of variables, and what are the differences?  faq149-272 MalcolmW 10 Nov 00 6.9 / 29
 

Common Formulas

Title :
Author :
Date :
29 Nov 00
Rating/# :
5.0 / 23

Title :
Author :
Date :
21 Nov 03
Rating/# :
6.0 / 6

Title :
Author :
Date :
19 Jul 08
Rating/# :
6.0 / 193

Title :
Author :
Date :
28 Oct 01
Rating/# :
6.7 / 11

Title :
Author :
Date :
5 Jun 04
Rating/# :
6.1 / 30

Title :
Author :
Date :
23 Jan 02
Rating/# :
4.2 / 5



Title :
Author :
Date :
20 Mar 01
Rating/# :
5.0 / 6

Title :
Author :
Date :
20 Nov 01
Rating/# :
6.5 / 8

Title :
Author :
Date :
21 Jan 05
Rating/# :
7.9 / 38

Title :
Author :
Date :
28 Oct 01
Rating/# :
6.8 / 9

 

CR Printer Dialog Box

Title :
Author :
Date :
21 Dec 00
Rating/# :
8.0 / 7

Title :
Author :
Date :
13 Jun 02
Rating/# :
6.5 / 4

 

Data Access

Title :
Author :
Date :
29 Oct 08
Rating/# :
--

Title :
Author :
Date :
11 Mar 01
Rating/# :
6.9 / 16


Title :
Author :
Date :
17 Mar 01
Rating/# :
4.8 / 18

Title :
Author :
Date :
23 Dec 04
Rating/# :
1.0 / 1

Title :
Author :
Date :
27 Oct 01
Rating/# :
5.8 / 4

Title :
Author :
Date :
14 Mar 01
Rating/# :
8.6 / 7

 

Exporting issues


 

Headers and Footers

Title :
Author :
Date :
17 Nov 03
Rating/# :
1.0 / 1

 

Installations

Title :
Author :
Date :
13 May 02
Rating/# :
9.7 / 12

Title :
Author :
Date :
23 Jan 18
Rating/# :
--

Title :
Author :
Date :
16 Apr 01
Rating/# :
7.5 / 20

 

Printer tray selection

Title :
Author :
Date :
9 Jul 00
Rating/# :
5.8 / 24

 

Printing Crystal Reports

Title :
Author :
Date :
14 Mar 02
Rating/# :
7.3 / 56

Title :
Author :
Date :
27 Jan 04
Rating/# :
2.0 / 1


 

Questions should include:

Title :
Author :
Date :
21 Jun 03
Rating/# :
6.7 / 24

Title :
Author :
Date :
5 Jun 04
Rating/# :
6.5 / 38

 

Report Application Server

Title :
Author :
Date :
16 Jun 03
Rating/# :
2.0 / 1

 

Report Development

Title :
Author :
Date :
19 Jul 08
Rating/# :
8.6 / 50

Title :
Author :
Date :
20 Sep 03
Rating/# :
7.0 / 3

Title :
Author :
Date :
27 Oct 01
Rating/# :
8.7 / 39

Title :
Author :
Date :
21 Nov 11
Rating/# :
--

Title :
Author :
Date :
1 Dec 03
Rating/# :
7.0 / 2

Title :
Author :
Date :
3 Mar 03
Rating/# :
7.8 / 6

Title :
Author :
Date :
19 Oct 00
Rating/# :
5.4 / 12


Title :
Author :
Date :
5 Jun 04
Rating/# :
6.9 / 23

Title :
Author :
Date :
19 Apr 10
Rating/# :
8.1 / 8

Title :
Author :
Date :
13 Feb 01
Rating/# :
7.8 / 35


Title :
Author :
Date :
9 Mar 04
Rating/# :
10.0 / 1

Title :
Author :
Date :
23 Nov 01
Rating/# :
8.6 / 5

Title :
Author :
Date :
25 Dec 01
Rating/# :
4.2 / 13

Title :
Author :
Date :
29 Nov 00
Rating/# :
4.0 / 3

Title :
Author :
Date :
14 Mar 02
Rating/# :
10.0 / 3

Title :
Author :
Date :
4 Mar 02
Rating/# :
6.1 / 7

Title :
Author :
Date :
27 Oct 01
Rating/# :
7.6 / 14

Title :
Author :
Date :
26 Nov 03
Rating/# :
3.8 / 4

Title :
Author :
Date :
13 May 02
Rating/# :
4.5 / 8

Title :
Author :
Date :
28 Sep 01
Rating/# :
3.5 / 4


Title :
Author :
Date :
22 Jan 02
Rating/# :
7.4 / 13

Title :
Author :
Date :
30 Jul 01
Rating/# :
4.0 / 1

 

Running Totals

Title :
Author :
Date :
27 Oct 01
Rating/# :
6.1 / 18

Title :
Author :
Date :
15 Aug 00
Rating/# :
7.1 / 56

 

Seagate Documents

Title :
Author :
Date :
19 Jul 08
Rating/# :
6.2 / 18

Title :
Author :
Date :
9 Nov 00
Rating/# :
6.9 / 8

Title :
Author :
Date :
4 Sep 00
Rating/# :
5.1 / 10

Title :
Author :
Date :
8 Jun 01
Rating/# :
7.5 / 8

Title :
Author :
Date :
19 Mar 01
Rating/# :
7.4 / 5

 

Subreports

Title :
Author :
Date :
5 Aug 04
Rating/# :
4.5 / 2

Title :
Author :
Date :
8 Sep 04
Rating/# :
9.5 / 4

Title :
Author :
Date :
22 Nov 06
Rating/# :
--

 

Types of Variables

Title :
Author :
Date :
10 Nov 00
Rating/# :
6.9 / 29

 
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close