[reportlab-users] Building Paragraph From Database Record

[Robin Becker]

Rich Shepard wrote:

>   I use pysqlite to retrieve records from database tables and put them in a

> list of tuples. I would like to display these values (by row) as a 

> paragraph

> within a table cell with the parameter name (in bold) and the parameter

> value, and each pair separated by a semi-colon.

> 

>   For example, a column named 'Variables' would have a cell with contents

> like this:

> 

>     Name: 'Soil depth'; Description: 'Surface through C horizon';

>     Component: 'Slope stability'; Sub-component: 'None'; Data

>     source: 'External'; Scale: '0-50'; Method: 'Centroid';

> etc.

> 

>   Can I do this with code similar to this;

> 

>   style = styleSheet['BodyText']

>   for i in len(range(self.data)):

>     story.append(Paragraph(label[i], + '; ' +self.data[i]))

> 

> if I have the lables also in a list?

> 

>   In a similar situation, can I use the newline, '\n,' in a single 

> paragraph

> combining labels and their values? What I now have is this:

.........

In the latest paragraph you can use a <br/> tag to force a newline into the 
outcome. Normally Paragraphs treat all space characters the same ie as places 
for splitting or separating words. You shold be able to do

Paragraph('<b>Head1</b>: text1<br/><b>Head2</b>: text2.....',style) etc and have 
the text laid out as you suggest. A typical way So I suspect you might want to 
do this like

text = '<br/>.join(['<b>%s</b>: %s' % (label,self.data(aname))
             for label, aname in [
                 ("Project name",'model_name'),
                     ("Project description",'model_desc'),
                 ("Project type", 'model_type'),
                 ("Project owner", 'proj_owner'),
                 ("Project location, 'proj_location'),
                 ("Project state/province", 'proj_state'),
                 ("Lead agency", 'lead_agency'),
                 ("Knowledge engineers", 'keName'),
                 ]
             ])
	
If you want a fixed space you should use &nbsp;
-- 
Robin Becker