Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

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

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I love the structure of the site. You start at the top, and drill down to what you want. Maybe I've been using Unix too long... :-) "

Geography

Where in the world do Tek-Tips members come from?

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 / 68
Calculate Weeknumber - (ISO 8601) Weeks start on monday and week 1 is the one including January 4th  faq767-4940 poujor 19 Sep 06 7.0 / 5
Calculating the number of Business Days between two dates   faq767-4465 Reebo99 21 Nov 03 7.4 / 16
Common Formula Examples  faq767-995 kenhamady 19 Jul 08 6.3 / 104
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 4.7 / 6
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 10.0 / 1
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 8.0 / 1
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.0 / 53
 

SQL Expressions

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

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