Print Page | Close Window

What does this mean?????

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19952
Printed Date: 27 May 2024 at 2:09am


Topic: What does this mean?????
Posted By: hlb6
Subject: What does this mean?????
Date Posted: 26 Aug 2013 at 12:33pm
(Select {?p_Period} [5 to 6]
case "12" :
ToText((ToNumber(Left({?p_Period},4))),0,"","")
default :
ToText((ToNumber(Left({?p_Period},4))-1),0,"",""))
&
(select {?p_Period} [5 to 6]
case "12" :
"01"
case "10", "11" :
ToText((ToNumber(Right({?p_Period},2))+1),0)
default:
"0"&ToText((ToNumber(Right({?p_Period},2))+1),0))
 
I am fixing reports that have been developed and I am not sure on this logic.  I am trying to export my data out to excel and two records format way over to the right when they should be to the left with the other records ( They are in a group header)


Replies:
Posted By: lockwelle
Date Posted: 27 Aug 2013 at 4:28am
usually when Excel formats something to the right, it thinks it is a number...

Why Excel does this is anyone's guess.

From the code, one would expect all the values to be treated the same


Print Page | Close Window