|
Mark
Thanks for your prompt reply.
We considered and rejected your
solution.
Processing of variable long strings from the
database into a variable number of separate print lines is a programming and
maintenance overhead that should not be incurred.
The wrap function is an important feature of
an advanced report programming tool.
An advance report programming tool should wrap text up to one
character less than the number of characters of a given point-size that fit the
defined page width.
Initially we thought that the problem arose from
appling the wrap function to a long varchar which is not
fully supported by Oracle.
We letter processed the long varchar from
Oracle.
We were able to play tunes using the
translate() and print functions but the wrap function forced a new line at 77
chars.
It appears that for a page width of 11.5 inches the
width of the wrap line is set at 77 chars, see details in my email I sent from work today.
Following further testing:
The problem is not due to the
long varchar string returned from the Oracle database.
We are certain that the
problem resides with the way the wrap function sets the wrap length to a fixed
number of char when the
page line width is
declared.
See also my email sent
earlier today.
The problem resides in the way the wrap function
works.
Interesting note
For an SQR file with no report page set-up
then wrap works correctly up to, if I remember correctly, 233 chars for a
long string defined in the program.
At 234 chars the wrap function puts in a new line
after the first wrapped line but not after the second wrapped line.
At 235 chars the wrap function puts in a new line
after the first and second wrapped line.
I speculate that the number of char set for the
wrap length is the maximum number of chars of the maximum point-size that
fit the
declared page width.
All I need is a way to override the number of chars
to which the wrap length is set on declaration of the page width.
We have an extremely high
work load.
I have to come off a 1** priority project to
address this issue.
Whilst wrapping text may be perceived as a minor
issue, it is causing the Company acute embarrassment.
It has already serious jeopardised an
extremely high workload of many priority 1 projects.
I cannot believe that there isn't a solution - I
need a quick fix however dirty.
Would, could MITI, Scribe or Brio
comment?
We hope that we are missing the
obvious.
We note the current
debate on alternative products with interest...
I am writing from home email account.
If anyone has a solution then please copy me on my
work email account: adrivers@atkins.co.uk
Andrew
----- Original Message -----
From: Manning, Shinta <ShintaManning@FINANCIAL.WELLSFARGO.COM>
To: <SQR-USERS@list.iex.net>
Sent: Wednesday, October 11, 2000 2:33
PM
Subject: Re: wrap function & proportional
fonts > what me and my collegue tried... so we ended up splitting the string and put > the other parts into other variables and print them separately... > > > -----Original Message----- > > From: Andrew Rivers [SMTP:andrew.rivers@CWCOM.NET] > > Sent: Wednesday, October 11, 2000 1:40 AM > > To: SQR-USERS@list.iex.net > > Subject: Re: wrap function & proportional fonts > > > > Mark > > Did you manage a fix for your problem. > > > > I am aware that wrap inserts a second line if the wrap line goes one char > > position over the length of the page width. > > > > However, I seem to have a similar problem to you in that my text is > > wrapping at about half way across the page. > > > > I suspect that it is possible to set wrap to a different length to the > > page width. > > The program is not mine so there may be some set-up in about 15 nested > > include files! > > > > If you have a solution or any possible suggestions I should be mots > > grateful. > > > > I am writing this at home - If you could also send any reply to my email > > work account at work adrivers@wsatkins.co.uk > > <mailto:adrivers@wsatkins.co.uk> then that would be great... > > > > Many thanks. > > > > Andrew > > > > ----- Original Message ----- > > From: Mark Polette < markpolette@YAHOO.COM <mailto:markpolette@YAHOO.COM>> > > To: < SQR-USERS@list.iex.net <mailto:SQR-USERS@list.iex.net>> > > Sent: Wednesday, January 19, 2000 8:08 PM > > Subject: wrap function & proportional fonts > > > > > SQR 4.3, Infomix 3.2, HP-Unix. > > > > > > Has anyone seen the wrap function of SQR mishandle > > > text when it is printed in non-proportional fonts such > > > as Times New Roman? Specifically it tends to insert > > > unwanted blank lines when wrapping some text lines. > > > (like when the text takes it very near the end of the > > > wrap length???) > > > > > > The command I am using is: > > > > > > print $text (+3,15,0) wrap 71 15 on=<10> > > > > > > I want to print a paragraph in a block 71 long by 15 > > > lines. > > > > > > The output I get for a certain text block is: > > > > > > line1 line1 line1....line1 > > > line_2 line_2........line_2 > > > > > > line 3 line3.........line 3 > > > > > > line 4 line4 line4. > > > > > > > > > It handles the first wrapped line correctly. However > > > it inserts unwanted lines randomly. If I change the > > > text it is printing (by removing a word, thus causing > > > it to reach near the end and wrap on a different word) > > > the problem doesn't happen. It seems to happen > > > randomly based on what text is printed and when it > > > reaches near the end of the line. If I change the > > > length of the wrap (from 71 to 60 for example) it will > > > wrap correctly (no blank lines.) > > > > > > I know I have seen the center function not work > > > properly with non-proportional fonts, and this leads > > > me to believe that it is the font which is causing SQR > > > to insert unnecessary lines when printing a wrapped > > > text block. I can change the font to courier and the > > > block wraps correctly. > > > > > > The SQR manual (page 232) mentions a problem with > > > implicit line feeds when your text gets to the right > > > edge of the page, however my text block is not near > > > the right edge. > > > > > > Any insight anyone would have is much appreciated as I > > > have tried just about everything to understand/fix > > > this little bugger. > > > > > > Thanks, > > > Mark Polette > > > EpicEdge > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Talk to your friends online with Yahoo! Messenger. > > > <http://im.yahoo.com> |