[Solved]Can't Keep Text line in Report Builder from Wrapping

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved]Can't Keep Text line in Report Builder from Wrapping

Postby frank1v » Sat Jun 14, 2008 10:32 pm

I've OOo 2.4.1 and Report Builder 1.0.2 on a Windows Home XP. I have a simple list with several text fields. Some of the fields have data that exceed the width of the field on the report. These fields wrap into the next line. I can't seem to find anything on how to keep the text from wrapping if they exceed the field length on the report. The table definitions have enough length for the data but Idon't put the entire field length in the report. I also don't want to go through a 4,000 item data base and edit down the text to fit. Any thoughts?

Frank
Last edited by frank1v on Wed Jun 18, 2008 1:41 pm, edited 2 times in total.
frank1v
 
Posts: 21
Joined: Wed Nov 28, 2007 10:44 pm

Re: Can't Keep Text line in Report Builder from Wrapping

Postby zadneram » Mon Jun 16, 2008 12:54 pm

Having a look at Report Builder (1.04) it seems you can change the output format of the report to be a spreadsheet (File > Report Output Format > Spreadsheet Document). If a spreadsheet format is acceptable then I don't think it will wrap long text and that should solve your problem.

Hope that helps.
OOo 2.4.X on Ms Windows XP
zadneram
 
Posts: 1
Joined: Mon Jun 16, 2008 12:47 pm

Re: Can't Keep Text line in Report Builder from Wrapping

Postby frank1v » Mon Jun 16, 2008 1:48 pm

Thanks - that sounds like a good idea.

Frank
frank1v
 
Posts: 21
Joined: Wed Nov 28, 2007 10:44 pm

Re: Can't Keep Text line in Report Builder from Wrapping

Postby DrewJensen » Tue Jun 17, 2008 5:54 pm

The other option is to build your report against a query - actually that is a good practice in general.

In the query simply use the LEFT function to send only the amount of text you want to work with.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
User avatar
DrewJensen
Volunteer
 
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Can't Keep Text line in Report Builder from Wrapping

Postby frank1v » Wed Jun 18, 2008 4:42 am

I appreciate the advice - I'll give it a try.

Frank
frank1v
 
Posts: 21
Joined: Wed Nov 28, 2007 10:44 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest