A few weeks back, everyone helped me out with the following formula:
if Length ({?event}) > 6 then
({?event})
Else
IF Length ({?event}) = 6 then
(totext(year(currentdate)))+ totext({?event})
else
IF Length ({?event}) = 4 then
(totext(year(currentdate)))+(totext(Totext( currentdate - Date (Year(Currentdate),1,1) + 1 , "000")[1 to 2] + totext({?event}))
Else
(totext(year(currentdate)))+(totext(Totext( currentdate - Date (Year(Currentdate),1,1) + 1 , "000") + totext({?event}))
Now, this formula gives the ability for the user to enter a three digit number, a four digit number, a six digit or the full 10 digit event number to an incident (The incident number is based on the year, julian date and then a unique number.
This crystal report works fine on my machine with CR8, but it wouldn't work on the Crystal Reports server. So, I figured out that the report settings for the CR Server had 1.00 for decimal and the thousands comma separator, which I did not on my machine. I changed it to the correct setting and was able to run the same report within the Crystal Reports program on the Server and the report ran correctly. However, when anyone accesses this report via a web server (through Internet Explorer), you can still only enter all 10 digits to retrieve an incident.
This makes me think that the Crystal Report Viewer has some limitations, but I'm not sure.
Any ideas? TIA
if Length ({?event}) > 6 then
({?event})
Else
IF Length ({?event}) = 6 then
(totext(year(currentdate)))+ totext({?event})
else
IF Length ({?event}) = 4 then
(totext(year(currentdate)))+(totext(Totext( currentdate - Date (Year(Currentdate),1,1) + 1 , "000")[1 to 2] + totext({?event}))
Else
(totext(year(currentdate)))+(totext(Totext( currentdate - Date (Year(Currentdate),1,1) + 1 , "000") + totext({?event}))
Now, this formula gives the ability for the user to enter a three digit number, a four digit number, a six digit or the full 10 digit event number to an incident (The incident number is based on the year, julian date and then a unique number.
This crystal report works fine on my machine with CR8, but it wouldn't work on the Crystal Reports server. So, I figured out that the report settings for the CR Server had 1.00 for decimal and the thousands comma separator, which I did not on my machine. I changed it to the correct setting and was able to run the same report within the Crystal Reports program on the Server and the report ran correctly. However, when anyone accesses this report via a web server (through Internet Explorer), you can still only enter all 10 digits to retrieve an incident.
This makes me think that the Crystal Report Viewer has some limitations, but I'm not sure.
Any ideas? TIA