×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• 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.

# Business Objects: Crystal Reports 1 Formulas FAQ Index

 Forum Search FAQs Links MVPs

## FAQ Index

### Formula Help

FAQ Title Author Date Rating/#
An extra help file for creating formulas   faq767-758 emcevoy 25 May 01 6.4 / 50
Arrays (how do you accumulate values in an array?)   faq767-3203 pelajhia 18 Feb 03 1.7 / 7
Basics of totals  faq767-6524 Madawc 26 Jan 07 5.5 / 69
Calculate Weeknumber - (ISO 8601) Weeks start on monday and week 1 is the one including January 4th  faq767-4940 poujor 28 Oct 14 7.0 / 5
Calculating the number of Business Days between two dates   faq767-4465 Reebo99 21 Nov 03 7.1 / 17
Common Formula Examples  faq767-995 kenhamady 19 Jul 08 6.3 / 105
Converting a YYYYMMDD number to a date  faq767-3539 dgillz 30 Apr 05 3.3 / 7
Count the number of individual days in a date range  faq767-6141 GJParker 16 Dec 05 2.0 / 1
Creating data for dates not in the data set with SQL Server SQL to create a Periods Table  faq767-4532 synapsevampire 2 Nov 04 6.7 / 16
Creating Multiple Labels in Crystal   faq767-5071 HowardHammerman 23 Apr 04 5.4 / 7
Displaying a Random Sample   faq767-3260 IdoMillet 3 Mar 03 7.8 / 8
Displaying a time as HH:MM:SS or DD:HH:MM:SS  faq767-3543 synapsevampire 7 May 07 7.6 / 43
Displaying data from the details prior to the details section  faq767-6528 synapsevampire 28 Jan 07 4.5 / 2
Displaying Images or Photos in a Crystal Report prior to v11  faq767-1988 dgillz 30 Apr 05 5.7 / 25
Displaying parameters chosen using a formula   faq767-5684 synapsevampire 15 Feb 05 8.5 / 24
Duplicating Records based on a Quantity Field  faq767-3227 IdoMillet 19 Apr 10 6.6 / 8
Dynamic Images in a Crystal Report  faq767-3609 chelseatech 26 Apr 06 7.1 / 16
How do I accurately calculate age in years, months or years and months?  faq767-5876 rhinok 17 May 05 8.9 / 8
How do I calculate the number of hours between two dates?   faq767-6970 HowardHammerman 17 Jul 08 7.3 / 3
How do I determine the correct accounting month based on '4-4-5' accounting periods?  faq767-1960 rhinok 5 May 04 6.5 / 6
How do I show a range parameter in my report?   faq767-810 AyJayEL 8 Sep 03 7.8 / 24
How do I work out an exact age (in years & months) without CR rounding up?  faq767-4120 phil2k 14 Jul 06 6.0 / 2
How to calculate the amount of time of a problem minus holidays, weekends and working hours  faq767-5430 paverley 16 Sep 04 7.1 / 7
How to Display Parameter Values in your Crystal Report   faq767-7302 HowardHammerman 26 Jan 10 5.0 / 2
How to generate unique page numbering in a report   faq767-923 MsPepperMintUSA 19 Jul 01 7.3 / 7
How to print multiple discrete and range parameter values and date range parameters in Crystal Reports Version 8.5.   faq767-1206 ElenaT 25 Oct 01 7.8 / 24
How to print text vertically   faq767-1986 HowardHammerman 30 May 02 7.0 / 3
How to select X number of months based on 1 parm date  faq767-6396 bkrav 30 Aug 06 --
How to split a FullName field into FirstName and LastName fields  faq767-3164 Storyteller 1 Jun 05 7.7 / 6
Optimizing SQL Pass Through using the Record Selection Formula  faq767-3825 synapsevampire 4 May 05 7.2 / 37
Sort Report in the Order of Multi_Valued Parameters   faq767-4506 IdoMillet 26 Nov 03 10.0 / 2
Summary/Running Total Field Cannot be Created   faq767-2300 dgillz 28 Apr 03 4.5 / 11
The reason you can't create a summary field  faq767-2323 emcevoy 25 Nov 11 6.6 / 14
Two simple UFL functions to return username and machinename   faq767-1284 ScottWebb 20 Nov 01 4.5 / 2
u2lcaps.dll missing when running report in windows7 64Bit environment Crystal 11   faq767-7486 xicana 17 Jun 11 --
User Function Library Creates Duplicate Output   faq767-5204 chelseatech 13 Jun 04 1.0 / 1
Various date/time and formatting formulas  faq767-1973 BlurredVision 15 Nov 10 3.1 / 54

### SQL Expressions

FAQ Title Author Date Rating/#
What is a SQL Expression?   faq767-1377 rhinok 20 Dec 01 7.3 / 61

Title :
Author :
Date :
25 May 01
Rating/# :
6.4 / 50

Title :
Author :
Date :
18 Feb 03
Rating/# :
1.7 / 7

Title :
Author :
Date :
26 Jan 07
Rating/# :
5.5 / 69

Title :
Author :
Date :
28 Oct 14
Rating/# :
7.0 / 5

Title :
Author :
Date :
21 Nov 03
Rating/# :
7.1 / 17

Title :
Author :
Date :
19 Jul 08
Rating/# :
6.3 / 105

Title :
Author :
Date :
30 Apr 05
Rating/# :
3.3 / 7

Title :
Author :
Date :
16 Dec 05
Rating/# :
2.0 / 1

Title :
Author :
Date :
2 Nov 04
Rating/# :
6.7 / 16

Title :
Author :
Date :
23 Apr 04
Rating/# :
5.4 / 7

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

Title :
Author :
Date :
7 May 07
Rating/# :
7.6 / 43

Title :
Author :
Date :
28 Jan 07
Rating/# :
4.5 / 2

Title :
Author :
Date :
30 Apr 05
Rating/# :
5.7 / 25

Title :
Author :
Date :
15 Feb 05
Rating/# :
8.5 / 24

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

Title :
Author :
Date :
26 Apr 06
Rating/# :
7.1 / 16

Title :
Author :
Date :
17 May 05
Rating/# :
8.9 / 8

Title :
Author :
Date :
17 Jul 08
Rating/# :
7.3 / 3

Title :
Author :
Date :
5 May 04
Rating/# :
6.5 / 6

Title :
Author :
Date :
8 Sep 03
Rating/# :
7.8 / 24

Title :
Author :
Date :
14 Jul 06
Rating/# :
6.0 / 2

Title :
Author :
Date :
16 Sep 04
Rating/# :
7.1 / 7

Title :
Author :
Date :
26 Jan 10
Rating/# :
5.0 / 2

Title :
Author :
Date :
19 Jul 01
Rating/# :
7.3 / 7

Title :
Author :
Date :
25 Oct 01
Rating/# :
7.8 / 24

Title :
Author :
Date :
30 May 02
Rating/# :
7.0 / 3

Title :
Author :
Date :
30 Aug 06
Rating/# :
--

Title :
Author :
Date :
1 Jun 05
Rating/# :
7.7 / 6

Title :
Author :
Date :
4 May 05
Rating/# :
7.2 / 37

Title :
Author :
Date :
26 Nov 03
Rating/# :
10.0 / 2

Title :
Author :
Date :
28 Apr 03
Rating/# :
4.5 / 11

Title :
Author :
Date :
25 Nov 11
Rating/# :
6.6 / 14

Title :
Author :
Date :
20 Nov 01
Rating/# :
4.5 / 2

Title :
Author :
Date :
17 Jun 11
Rating/# :
--

Title :
Author :
Date :
13 Jun 04
Rating/# :
1.0 / 1

Title :
Author :
Date :
15 Nov 10
Rating/# :
3.1 / 54

Title :
Author :
Date :
20 Dec 01
Rating/# :
7.3 / 61

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!