Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports 8.0 web server problem

Status
Not open for further replies.

TheStone

Technical User
Oct 23, 2000
6
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top