PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 11/20/2014 2:56 PM by  Jan
Report opens very slow
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jan
Private
Private
Veteran Member
(121 points)
Veteran Member
Posts:55


Send Message:

--
11/20/2014 2:22 PM
    Hello

    I have an employee roster report that is created on a schedule each everning and creates an Excel spreadsheet available as a link through our self service web page. Users have stopped using the report because it can take from 30 seconds to a minute to open the report - there are about 8,500 lines in the report.

    On my machine, I have a mapping to the server where this report resides. If I go directly to the server folder and open the spreadsheet, it opens in a couple of seconds.

    I realize when I open through LBI, various authentications are occuring, and the report is downloading from LBI rather than being opened directly from the server, but what could cause such a drastic difference in open times?

    I'm looking for some items to look for so I can talk to I.T. and try to figure out a way to speed access times up.

    thanks in advance for any help you can give me
    John Henley
    Private
    Private
    Senior Member
    (9752 points)
    Senior Member
    Posts:3268


    Send Message:

    --
    11/20/2014 2:50 PM
    What format is the report in when the users are opening it? Excel xlsx ?
    Thanks for using the LawsonGuru.com forums!
    John
    Jan
    Private
    Private
    Veteran Member
    (121 points)
    Veteran Member
    Posts:55


    Send Message:

    --
    11/20/2014 2:56 PM
    HI - the report is in .xls format
    You are not authorized to post a reply.