PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/10/2019 2:48 PM by  JonA
Preserve formatting upon LBI export
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(208 points)
Veteran Member
Posts:114


Send Message:

--
07/02/2019 12:49 PM
    We would like to be able to export existing LBI reports, (or set them to open directly as Excel (.xlsx)) so that the columns are sized according to the data in each column. The purpose of this is so that the end user does not have to spend the extra time re-sizing the columns to see all the data in each column of the Excel spreadsheet

    Is there a way to do this if the report is coming from Crystal? I have tried changing some settings in the Export options within the Crystal report, which works great when exporting directly from Crystal, but when I republish this to LBI, the export options do not seem to get retained.

    Any thoughts are appreciated!
    Donna
    Private
    Private
    Veteran Member
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

    --
    07/02/2019 2:58 PM
    We have had this issue since our upgrade to version 10. We can sometimes overcome it by reformatting the Crystal report but we often have to use the Excel data only export.
    JonA
    Private
    Private
    Veteran Member
    (3104 points)
    Veteran Member
    Posts:1094


    Send Message:

    --
    07/10/2019 2:48 PM
    Just a thought. Are they resizing each column individually? I can see where that may take time depending on the number of columns. But you can resize all columns at once by highlighting the entire worksheet and double-click the column separator.

    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Attachments
    You are not authorized to post a reply.