<div dir="ltr">Thanks you for your answers,<div><br></div><div>In fact, the text for my label is generated in a postgis query that group several features to be shown in the same page. My aim was too use string_agg() with '/n' delimiter, to group several text fields and show them in different lines in a text label in QGIS print composer.</div>
<div><br></div><div>Therefore my resulting field values was something like:</div><div>'CR02 - Cascais\nCR09 - Fontainhas'.</div><div><br></div><div>But when rendered by atlas, this does not create the breaklines.</div>
<div><br></div><div>The solution was to use '</br>' as delimiter in string_agg(), and render the label as HTML. Yet, I add to recreate the font style and position with HTML. Something like this:</div><div><br>
</div><div><p style="margin:0px"><span style="font-family:Verdana; font-size: 16 pt; font-weight: bold; position:absolute; top:20%;"></p>
<p style="margin:0px"> [%descricao%]</p>
<p style="margin:0px"></span></p></div><div><br></div><div><br></div><div>Best regards,</div><div><br></div><div>Alexandre</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br><div>
<br></div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Oct 22, 2013 at 10:52 PM, Carlos López PSIG <span dir="ltr"><<a href="mailto:carlos.lopez@psig.es" target="_blank">carlos.lopez@psig.es</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_default"><div class="gmail_default"><font face="georgia, serif">Hello Alexandre and everyone,</font></div>
<div class="gmail_default"><font face="georgia, serif">You can use "Expresion based label" in label properties...</font></div>
<div class="gmail_default"><font face="georgia, serif">For instance:</font></div><div class="gmail_default"><font face="georgia, serif"><br></font></div><div class="gmail_default"><font face="georgia, serif">CASE</font></div>
<div class="gmail_default"><font face="georgia, serif">WHEN "CRLFPOS1" = 0 THEN "TEXT_TOP"</font></div><div class="gmail_default"><font face="georgia, serif">WHEN "CRLFPOS1" > 0 AND "CRLFPOS2" = 0</font></div>
<div class="gmail_default"><font face="georgia, serif">THEN substr("TEXT_TOP",1,"CRLFPOS1"-1)||'\n'||substr("TEXT_TOP","CRLFPOS1"+1,length("TEXT_TOP")-"CRLFPOS1"+1)</font></div>
<div class="gmail_default"><font face="georgia, serif">WHEN "CRLFPOS1" > 0 AND "CRLFPOS2" > 0</font></div><div class="gmail_default"><font face="georgia, serif">THEN substr("TEXT_TOP",1,"CRLFPOS1"-1)||'\n'||substr("TEXT_TOP","CRLFPOS1"+1,"CRLFPOS2"-"CRLFPOS1")||'\n'||substr("TEXT_TOP","CRLFPOS2"+1,length("TEXT_TOP")-"CRLFPOS2"+1)</font></div>
<div class="gmail_default"><font face="georgia, serif">END</font></div><div class="gmail_default"><font face="georgia, serif"><br></font></div><div class="gmail_default"><font face="georgia, serif">Where "CRLFPOS1" is a numeric field with the position the first breakline</font></div>
<div class="gmail_default"><font face="georgia, serif">And "CRLFPOS2" is a numeric field with the position the second breakline</font></div><div class="gmail_default"><font face="georgia, serif"><br></font></div>
<div class="gmail_default"><font face="georgia, serif">"TEXT_TOP" is a string field that contain annotations.</font></div><div class="gmail_default"><font face="georgia, serif"><br></font></div><div class="gmail_default">
<font face="georgia, serif">I hope that my mail help you ...</font></div><div class="gmail_default"><font face="georgia, serif"><br></font></div><div class="gmail_default"><font face="georgia, serif">Regards,</font></div>
</div></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><font face="verdana, sans-serif"><font style="font-size:small"><b><img><br>
</b></font></font></div><div><font face="verdana, sans-serif"><font style="font-size:small"><b><br></b></font></font></div><div><font face="verdana, sans-serif"><font style="font-size:small"><b><br></b></font></font></div>
<font face="verdana, sans-serif"><font style="font-size:small"><b>Carlos López Quintanilla</b><br><br><br></font></font><font face="verdana, sans-serif" color="#38761d"><a href="http://www.psig.es/" style target="_blank">www.psig.es</a></font><div>
<a href="mailto:carlos.lopez@psig.es" style="font-family:verdana,sans-serif;font-size:small" target="_blank"><font color="#38761d">carlos.lopez@psig.es</font></a><font face="verdana, sans-serif"><font><br><font><a href="tel:%2B34%20699.680.261" value="+34699680261" target="_blank">+34 699.680.261</a></font></font><br style="font-size:small">
<br></font><div><br></div></div></div></div>
<br><br><div class="gmail_quote">2013/10/22 Lene Fischer <span dir="ltr"><<a href="mailto:lfi@life.ku.dk" target="_blank">lfi@life.ku.dk</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5">
<div>
<div style="direction:ltr;font-size:10pt;font-family:Tahoma">Hi
<div>The trick is:</div>
<div>expression/field || <font color="#339966">'\n'</font> || expression/field</div>
<div><br>
</div>
<div> || is the seperator between fields.</div>
<div><br>
</div>
<div>Regards</div><span><font color="#888888">
</font></span><div><span><font color="#888888">Lene Fischer<br>
</font></span><div style="font-size:16px;font-family:Times New Roman"><span><font color="#888888">
<hr>
<div style="direction:ltr"><font face="Tahoma" color="#000000"><b>Fra:</b> <a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a> [<a href="mailto:qgis-user-bounces@lists.osgeo.org" target="_blank">qgis-user-bounces@lists.osgeo.org</a>] pĺ vegne af Alexandre Neto [<a href="mailto:senhor.neto@gmail.com" target="_blank">senhor.neto@gmail.com</a>]<br>
<b>Sendt:</b> 22. oktober 2013 11:09<br>
<b>Til:</b> QGIS User<br>
<b>Emne:</b> [Qgis-user] Multiple lines label in QGIS 2.0 print composer using wrap on character?<br>
</font><br>
</div></font></span><div><div>
<div></div>
<div>
<div dir="ltr">Hello all,
<div><br>
</div>
<div>Is there a way to create multiple lines label using a wrap on character in QGIS 2.0 print composer? Or this must be done with html rendering?</div>
<div><br>
</div>
<div>I'm using atlas generation and the label source is attribute from my coverage layer.</div>
<div><br>
</div>
<div>Thanks,</div>
<div><br>
</div>
<div>Alexandre Neto</div>
</div>
</div>
</div></div></div>
</div>
</div>
<br clear="all">
</div>
<br></div></div>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>
</blockquote></div><br></div>