Oy!
CR XI Dev
SQL Server 2000
Visual Studio .Net
I wrote a Patient Statement report and it works fine in CR 11 Dev, however when the VB developer is trying to write an application around the report it's choking on instances where I used the ProperCase function.
Does VS . Net use Crystal Reports v.10 runtime? If so does v.10 not support ProperCase?
We also tried the following custom function with no joy:
Function PCase(s as string) as string
dim sarray() as string 'array to hold split string
dim astring as string 'value to return
dim bstring as string 'a working string
dim i 'index iterator
sarray = Split (s, " ") 'split incoming string into component words
for i = 1 to ubound(sarray)
bstring = uppercase(left(sarray(i),1)) + lowercase(mid(sarray(i),2)) 'save individual word into array
astring = astring + " " + bstring 'add individual word to return string
next
pcase = astring 'return propercased string w/o using ProperCase function
end function
Once we do get this ironed out how do I handle names like "John S. McMurry III"?
Is there a way I can do this on the DB?
Would it be better for the programmer to handle this and then pass the final dataset to the report?
Lots of questions I know but it's how you learn right? (
oops, 'nother question) :0)
)
CR XI Dev
SQL Server 2000
Visual Studio .Net
I wrote a Patient Statement report and it works fine in CR 11 Dev, however when the VB developer is trying to write an application around the report it's choking on instances where I used the ProperCase function.
Does VS . Net use Crystal Reports v.10 runtime? If so does v.10 not support ProperCase?
We also tried the following custom function with no joy:
Function PCase(s as string) as string
dim sarray() as string 'array to hold split string
dim astring as string 'value to return
dim bstring as string 'a working string
dim i 'index iterator
sarray = Split (s, " ") 'split incoming string into component words
for i = 1 to ubound(sarray)
bstring = uppercase(left(sarray(i),1)) + lowercase(mid(sarray(i),2)) 'save individual word into array
astring = astring + " " + bstring 'add individual word to return string
next
pcase = astring 'return propercased string w/o using ProperCase function
end function
Once we do get this ironed out how do I handle names like "John S. McMurry III"?
Is there a way I can do this on the DB?
Would it be better for the programmer to handle this and then pass the final dataset to the report?
Lots of questions I know but it's how you learn right? (
oops, 'nother question) :0)
)