Skip to Content
avatar image
Former Member

Crystal Reports Naming Formula

I have a database where 0=Days, 1=Weeks, 2=Months, 3=Years... I need the formula to show their true names as text, so I can then link to a frequency period (numeric) as a text string. So I then have 1 Day, 2 Week, 4 Year, etc in all combinations as per data. Which Formula do I use? Again, the data I have is 0-3, but I want to trasnlate the numbers so 0=Days, 1=Weeks, 2=Months, 3=Years. Please help! Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 12, 2017 at 03:34 PM

    You need to give some examples

    How can 2 = Months when there are 12 months in a year, similarly for weeks how can a single digit represent up to 52 weeks

    Ian

    Add comment
    10|10000 characters needed characters exceeded