Quote:
>How do I put code in to define work fields that are behind the scenes?
Not sure what you mean by this. Formula fields are fields that you can
define.
Quote:
>How do I create parms so that they come up when the report is run and the
>user enters the selection value?
Create a parameter field. Reference this field in your record selection
Quote:
>Also, when text info has trailing blanks, how do I drop them?
Trim({table.myfield})
Quote:
>For example, the first name field is 20 character long in SQL. When I
>display the first name, middle initial, and last name, I only want a single
>space between the 3 parts of the name.
Trim({t.first_name}) + " " + Trim({t.middle_name}) + " " +
Trim({t.last_name})
Sincerely,
Craig Buchanan, President
Cogniza, Inc.
Seagate Software Partner
http://www.cogniza.com
+1.612.824.5858
Quote:
>Any help appreciated.
>Francis