1. 

   -nth-, Member

   I've got a report that has a really long description field. I was hoping that if I used the dbr.pageview option it would word wrap the column (similar to what the documentation shows for the description field in the example in the Appearance section). But my result is that it continues as one horizontally long field until it eventually truncates. Is there a way I can achieve word wrap of a column using pageview (or other option)?

   Also just ran across a typo in the Report Wizard... at the bottom it says "Miscanellous settings" I'm thinking it should be "Miscellaneous settings"???

   Thanks,
   -nth-
2. 

   myDBR Team, Key Master

   To limit the pageview column width and make it wrap, just apply a column style to it.

   select 'dbr.colstyle', 3, '[width: 250px;]';

   Typo corrected, tnx.

   --
   myDBR Team
3. 

   -nth-, Member

   Ok, that did the trick for column width thanks!

   Is there a limitation the length of the column returned? This description column happens to be about 2000 characters long! Most records average 100 characters, but some get longer. It looks like mydbr cuts the column display off at 255 characters. Can that be adjusted?
4. 

   myDBR Team, Key Master

   There is no limitation on string length.

   You are using SQL Server? Which PHP db extension are you using, php_mssql or php_dblib?

   --
   myDBR Team
5. 

   -nth-, Member

   I'm using SQL Server with php_dblib.
6. 

   myDBR Team, Key Master

   Check the dataype you are selecting and also check the configuration variables for freetds / PHP for text size. As said, there is no limitation on string lengths in myDBR.

   --
   myDBR Team
7. 

   -nth-, Member

   My freetds.conf file was configured incorrectly. Once I bumped up the text size it worked! Thanks!

Reply

You must log in to post.