INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

Business Objects: Crystal Reports 1 Formulas FAQ Index

FAQ Index

Formula Help

FAQ Title Author Date Rating/#
An extra help file for creating formulas   faq767-758 emcevoy 25 May 01 6.3 / 49
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
 

Resources

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