This topic is locked

Print page truncates long text fields

7/31/2008 10:35:10 PM
PHPRunner General questions
P
pengas author

Hi there,
In the list page I setup long text field to show 10 characters while the rest are visible in a pop up when clicking on the 'more' link.
The problem occurs when I choose one or more records and then click on 'print selected'.
Those truncated text fields stay truncated with the 3 dots postfix.
For example, one field in the table is BUSINESS with the following text: SHERMAN OAKS.

In the list and print pages that record will show "SHERMAN OA ...".
Any ideas what is going on?
Thank you.

J
Jane 8/1/2008

Hi,
here is a workaround:

  1. edit SQL query on the Edit SQL query tab:
    select

    BUSINESS,

    BUSINESS as BUSINESS_export,

    ...

    from TableName



2. check off BUSINESS_export on the export page only on the Choose fields tab,

3. set up BUSINESS_export field as HTML on the "View as" settings dialog on the Visual Editor tab.

P
pengas author 8/4/2008

Hi,

here is a workaround:

  1. edit SQL query on the Edit SQL query tab:
  2. check off BUSINESS_export on the export page only on the Choose fields tab,
  3. set up BUSINESS_export field as HTML on the "View as" settings dialog on the Visual Editor tab.


That worked for one field but generated an SQL error with another.

Is there any other workaround that you guys found for this?
Thank you,

Pengas

J
Jane 8/4/2008

Hi,
It's difficult to tell you what's happening without seeing actual error message.

Post error message here or publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

P
pengas author 8/6/2008

Hi,

It's difficult to tell you what's happening without seeing actual error message.

Post error message here or publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.


thank you Jane, i was able to work this issue out per your suggestions above.