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
