Results 1 to 5 of 5

Thread: Going to L&L-25

  1. #1
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Going to L&L-25

    I'm working on moving from L&L-23 to L&L-25 and ran across one issue that bit us. We have a few L&L reports that only export to Excel and have quite a few columns. Prior to L&L-25 you could just define the columns, tell L&L not to "adjust" the widths so as to fit in the table and life would be good. I have one export for 55 columns.

    With L&L-25 a new rule was introduced which essentially says that all columns must fit inside the table so any that fell outside (off to the right) were simply truncated. Combit said to set option LL_OPTION_SUPPRESS_CELLCLIPPING_TO_REPORTCONTAINER to true to be backward compatible to LL-23 & before rules and that did work for this but unfortunately it also forced the column header names to show on almost every other line, go figure.

    Combit got back to me to say that I should set the following:

    While printing with "Export only Table Data" (Export.OnlyTableData) to the Excel format you can use the List & Label export option "Header and footer lines = Print once" (see screenshot attached). In your code you can set "XLS.IgnoreHeaderFooterLines" to the value "2" to get the same without user interaction.
    And the screen shot didn't really help. The problem is that I can't find anything in cListLabel.pkg that looks anything like that. How can I get the headers to print only once?

    TIA...
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  2. #2

    Default Re: Going to L&L-25

    Hi Bob

    I'm currently at work with no List & Label running here ;-) Export Options are set with LLPrintSetExportOptions (as far as i remember). I will take a look when i'm back home again this afternoon.

    Regards
    Bernhard

  3. #3
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: Going to L&L-25

    Thanks Bernhard
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

  4. #4

    Default Re: Going to L&L-25

    Hi Bob

    Much easier with Documentation and a running System :-)

    You can set the needed Export Options with

    Code:
    Get LLXSetParameter of hoLL LL_LLX_EXTENSIONTYPE_EXPORT "XLS" "Export.OnlyTableData" "1" to iRet
    Get LLXSetParameter of hoLL LL_LLX_EXTENSIONTYPE_EXPORT "XLS" "XLS.IgnoreHeaderFooterLines" "2" to iRet
    after your LLJobOpen Call or inside the OnJobAfterOpen Notification. For all possible Export Options look inside the Programmers Manual, Section "Export Modules"->"Excel Export"

    HTH
    Bernhard

  5. #5
    Join Date
    Feb 2009
    Location
    SW Connecticut/NY area
    Posts
    9,181

    Default Re: Going to L&L-25

    Hi Bernhard,
    I was thinking "option" so LLXSetParameter didn't occur to me. And you're right, the docs do help, I should take your advice...

    Thanks!
    Bob Worsley
    203-249-2633
    rlworsley at gmail.com

    Do or do not. There is no try. — Yoda

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •