This topic is locked

Don not truncate in print view

5/7/2008 10:41:19 AM
ASPRunnerPro General questions
T
Tim author

Hello,
Is there a way to leave the truncated field on the list view but have it display all text in the print view? (obviously, in the print view we can't click "more...")
On a related note... it seems I can have the print view be "Vertical" without affecting the list view, but the records per row affects both. Is there a way to manage the records per row separately for print and list view?
Thanks, as always,

Tim

J
Jane 5/8/2008

Tim,
please see my answers below:

  1. to show non-truncated field on the print page edit your SQL query on the Edit SQL query tab.

    Here is a sample:
    select field1,

    field1 as field1_print,

    ...

    from TableName



Then check off field1_print on the print page only on the Choose fields tab and set up this field as HTML on the "View as" settings dialog on the Visual Editor tab.
2. to change number of records on the print page add following code to the Print page: Before process event on the Events tab:

SESSION(strTableName & "_pagesize") = 100

T
Tim author 5/8/2008

Thanks Jane,

1 - that's a great trick! thanks.


2 - not sure you got me on that on... I'm trying to change the records per row, not the total number of records on the page. (although I didn't try your code, but it looks like it's setting total per page... correct?)



Tim

J
Jane 5/8/2008

Tim,
yes. The above code changes ecord per page option.
Here are the tips how to change record per row for the print page:

  • create custom view on the Datasource tables tab,
  • set up another record per row value on the Fields order and totals tab for this view,
  • point link of usual print page to the print page of this view on the Visual Editor tab.

T
Tim author 5/8/2008

Got it! Thanks so much.
Tim