Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

LBI 10.6 Sorting by Instance Name

 1 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
dcaiani
Veteran Member
Posts: 52
Veteran Member
11/12/2019 10:12 PM
    We recently upgraded to LBI 10.6 from 10.4. In each version up until 10.6 you could sort reports via the Instance Name, now in 10.6 you cannot.

    So we publish about 15 RW100 reports each month and keep the historical instances on LBI for 24 months. Each month the instance name is renamed in this format "fiscal year period number actual month & year" (for example FY19 Period 04 January 2019). That way we could sort descending by instance number and it keeps the most current version on top of the list in its dashboard. Each report is in its own report list (under my reports) and that's where the each dashboard model gets the report links from.

    Now for some reason we can have Instance Name as a column, but we cannot sort by the instance name. Has anyone else run into this? Does anyone have a solution or thoughts? I opened a case with Infor and they acknowledged the issue and said they'd consider it for future modifications, but of course that doesn't help me out now!
    Greg Dey
    Advanced Member
    Posts: 23
    Advanced Member
    11/12/2019 11:49 PM
      We also recently completed the same upgrade to 10.6 and I can sort historical instances by instance name. I'm guessing I must be doing it in a different spot? I am navigating to a dashboard with My Reports, selecting the report [History] link and it displays the historical instances with column headers of Instance Name, Created Date, Output Type and Created By. I am able to sort all of these columns. If I navigate to the "new" My Reports without first going to a dashboard, I am also able to sort the columns.