David Thanks I agree However I stll whish for "Overflow fomat = '*****************''"
Gunnar Ekblad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: den 26 april 2005 20:29 To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Old problem needs new solution Gunnar Here's myh strategry for this - a bit time consuimg but it does work. For each form / report / field where I see size can be an issue, I determine OR CREATE the widest possible value that could be there (e.g, for a text 30 field, I'll create a value with 30 W's in it) and test the report / form until it can handle that value. Same with report totals - what's the biggest this value can get? Generate test rows to force that result and see if it fits David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, April 26, 2005 1:52 PM Subject: [RBG7-L] - RE: Old problem needs new solution > > Javier > Thanks Let me just add that is what I do as well. It is a neat trick and > it works fine. > BUT It does not give me a warning on the detail line. > Between you and me I was kind of hoping a response like: > " > What version are you using I am on 7,.zzzzzzz and the ***************** > are there. > " > Anyway Javier thanks for struggling with me! I can add I am only on > Front End Build: 7.5.4.30418 > > I believe for time being auto size might be best, when I have overtype > on 2 column that that is maybe the warning I am looking for. > An other subject I thought you where in the trucking business not inreal > estate > > > Gunnar Ekblad > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Javier > Valencia > Sent: den 26 april 2005 18:53 > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Old problem needs new solution > > Gunnar: > I have run into this problem when I have to report totals on the footer > of a > report with many columns and where real estate is at a premium. In most > cases the column width at the detail level is fine as the numbers are > not > necessarily big, but, when you have several thousand detail lines, the > totals can get pretty large and one of the options is to display less > columns and allocate more space for the column totals. Since this is not > always feasible what I do is display the totals in 2 lines, allocating > more > room for the totals; for example, total for column 1 is displayed on > line 1, > total for column 2 is displayed on line 2, total for columns 3 is again > displayed on line 1 and so on. The result looks like: > Col1 Col2 Col3 Col4 > Col1 Col2 Col3 Col4 > Col1 Col2 Col3 Col4 > ===== ===== ===== ===== > My_Total 1 My_Total 3 > My_Total 2 My_Total 4 > Hopefully the above will display correctly, but you get the idea...with > this > approach I can assign a much larger space to the totals... > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended > recipient > is prohibited. If you received this in error, please contact the sender > and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Gunnar > Ekblad > Sent: Tuesday, April 26, 2005 10:48 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - Old problem needs new solution > > I wonder how you all handle reporting of numeric values (Real, Double, > Currency, Numeric) in windows version of R:Base! > I old DOS style, If I had a value that was bigger than fitted the field > I got nicely ********** as resultat telling me I had a value to was > bigger than could represented in the allocated space. > I windows version If I have a value of say $10,563,952.53 that on a > report comes out as 563,952.53 since I did not allocate space enough, > has any body figured out how I can get a warning/error/format/?? so I > will be aware that something is wrong. The only thing I have come up > with is to allocate more then enough space. But sometimes that solution > takes up to much space that could be better used for other purposes. > I guess what I am asking for is right clicking a report field beside the > existing "Display format, Null Format" I would like to see "Overflow > format". In a way I can use autosize, but that leaves me out of the > control of the format and space allocated. > Or has anyone already solved this in nice and smart way? > > > Gunnar Ekblad > >
