(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Imported text format
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Imported text format (Read 701 times)
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Imported text format
Nov 23rd, 2005 at 10:58pm
Print Post Print Post  
I imported lowercase text data into records with uppercase form fields.
The records show uppercase but when I print a report they all print as lowercase.
I tried to change the format to uppercase in the reports but it does not do anything.
I understand the reports are printing the format in which the text was introduced but there should be a way of changing it when designing the reports.
Is there a way?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Imported text format
Reply #1 - Nov 23rd, 2005 at 11:21pm
Print Post Print Post  
Did you set the LE format to "Custom Format" and then the "Text Format" to uppercase in the Property Editor in SDesigner's report writer for the elements that you want in uppercase?

Did you remember to Save before you previewed?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Re: Imported text format
Reply #2 - Nov 23rd, 2005 at 11:44pm
Print Post Print Post  
Yes I did.
And I saved it.
And I reconciled it
And still I get lowercase.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Imported text format
Reply #3 - Nov 23rd, 2005 at 11:51pm
Print Post Print Post  
I tried it here with Customers.db - no problem. Does it work for you in Customers.db? Does it work from preview mode from the .dsr?
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Re: Imported text format
Reply #4 - Nov 24th, 2005 at 2:43am
Print Post Print Post  
I think I know where the problem is.
My field is a Keyword field.
The change to uppercase and lowercase in reports works perfectly with text fields.
But it behaves different for Keyword fields.
Any ideas?
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Imported text format
Reply #5 - Nov 24th, 2005 at 3:46am
Print Post Print Post  
Ah Customers.db tricked me. The keyword field (Hobbies) is already all upper case.

If you can't wait for the release with the fix (probably going have to be 1.1.4, since 1.1.3 has been packed and sent to marketing), you can affect this in SBasic:

Element LE3 (for example) On Print Event
Code
Select All
LE3 = ToUpper(LE3)


As you said, only necessary for keyword fields.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
etejeira
Junior Member
**
Offline


No personal text

Posts: 60
Joined: Aug 6th, 2005
Re: Imported text format
Reply #6 - Nov 24th, 2005 at 4:19pm
Print Post Print Post  
Thanks.
It worked perfectly.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge