Kalaine General User

Joined: 22 Feb 2009 Posts: 10
|
Posted: Mon Mar 02, 2009 5:08 pm Post subject: Dynamic report or form? |
|
|
I am trying to create a form or report that has dynamic fields - where a name like John Smith can fit into a space with the same amount of before and after spaces (one) that a name lke Sylvester Vandepinbos. Barring that, I would like to have an underlined space that can accomodate the larger number of characters without making the smaller number look alien - because it is an underlined space.
I've tried to accomplish both or either in forms and reports (I have the sun microsystem report extension and it works wonderfull off of a very large query - I just don't have many formatting options).
My final solution was to create a table with all of the provisions that I need (16 multi-line as it is a contractor contract) as the default values in fields, breaking them up at the variable insertion points (Field default: 'contract on this' New Field= Date as day (DD) Field', etc.) with a query that CONCATs the fields into their sequences.
This is cumbersome and will create a table that is unsustainable in the long term.
Is there another option? (I've decided that I cannot use my solution).
Kalaine |
|