Re: how to increase leading space in a character field using Report Builder 6i

Thanks Joost,
that is more or less what I did but it is also what I'd like to avoid! I actually padded the string with a blank inside the format trigger, so I don't have to tamper with my source query. I thought also of introducing a sort of gutter between each pair of columns, but this means wasting a lot of time moving around fields that came perfectly aligned from the report wizard. How can it be that Oracle didn't take into account the overlap between a border line and the first character of a field? For numeric fields at least there are some useful format masks where you can put blanks, zeros and so on, but for character fields there is absolutely nothing handy (unless I overlooked it...).

Bye,
Flavio

"Surfnet" <j.r.l.m.bataille#3#_at_uva.nl> wrote in message news:a8q7vq$2ru$1_at_news.surfnet.nl...
> Hello Flavio,
> relax...
> I'm not sure what you mean by 'manually inserting a blank at the source
> level'.
> I guess it's my first suggestion: change the query your report is based
on.
> 'select ' '||column_value from table' in stead of 'select column_value
from
> table'.
> My second suggestion would be to create a formula column that returns the
> column value with a couple of spaces added. Then change the source
property
> of your item to the formula column.
>
> I actually like playing with Reports a lot...
> Hope this helps, regards.
>
> Joost Bataille
> University of Amsterdam ICT centre
> www.ic.uva.nl
>
Received on Mon Apr 08 2002 - 10:37:12 CEST