Formatting Reports
Hello,
I output an Excel report of all open issues to discuss with our developers on a fortnightly basis. It works fine but I'd like to be able to format the report so it's easier to read, etc. Currently, it is inserting additional rows when it finds an 'end of line' character found in the Description field. So if I want to use borders in Excel to separate individual issues I end up with mulitple rows appearing in the one issue description. The last couple of times I've been getting rid of the additional rows manually to tidy up the report fairly labour intensive.
The end of line Chars are caused by using the Enter key when initially entering a description of the issue. The New Paragraph feature in the RAD Editor will only drop you down 1 line even if you press it multiple times. When I want a blank line between paragraphs I have to use the Enter key, twice.
I was trying to find out if I could customise the Excel output but haven't been successful. Is there a CSS or XLS stylesheet I can modify or is this done in a compiled procedure somewhere?
Hope that makes sense for you...
Many thanks,
|
Groins_NZ
· 1 |
|
| Thursday, August 31, 2006, 6:20:01 AM | |




