Skip to Content
0

Crystal Reports Naming Formula

Jul 12, 2017 at 01:06 PM

24

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Jul 12, 2017 at 03:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded