Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Export a scheduled LBI report to excel DATA ONLY format
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5164
People Online:
Visitors:
241
Members:
0
Total:
241
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Export a scheduled LBI report to excel DATA ONLY format
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Kate Liamero
Veteran Member
Posts: 70
8/31/2009 4:07 PM
I have a crystal report that is scheduled in LBI , exported to excel and emailed as an attachment to users. The problem is that the excel file cannot be sorted by the users because of meged cells. I beleive that if I could export using the export to excel data only the file could then be sorted but I don't see that option in LBI. Is there a way to do this?
Thanks
Kate
mikeP
Veteran Member
Posts: 151
9/1/2009 11:11 AM
This response is based on LBI version 9-0-3-2-111 07.17.2009 16.19.03 CDT
In LBI, go to My Reports and click [Details] for the report. In the Report Options section in the left margin, click Output Options. The first control on the page is Default Output Type, set it to Microsoft Excel Data Only (XLD).
This works, with one hitch, the default name LBI offers for the workbook is (reportname).XLD. An XLD file is an Excel dialog, which I think this was the predecessor to VBA forms. My machine didn't have the file association set for them, once that's done, Excel will open it as if it's a normal workbook. It's not a big deal to set the file association, but the garden variety user may not know what to do. It might be better to have your automated process rename the file to an XLS if the report scheduling process permits it.
Kate Liamero
Veteran Member
Posts: 70
9/1/2009 4:49 PM
Thanks Mike. That will work if the report is run on demand but when you sschedule the report to run there is no XLD option for output only XLS which gives merged cells and the user can't sort the data.
Thanks
Kate
mikeP
Veteran Member
Posts: 151
9/1/2009 5:05 PM
OK, I had not scheduled a report before. I just looked at the available output choices for scheduling, and CSV is available. Have you tried that? Excel will normally open a CSV without the need to set a file association.
Ruma Malhotra
Veteran Member
Posts: 412
9/2/2009 2:55 PM
The csv option works on a scheduled report that is emailed. It allows you to format the rows and columns in your excel output.
On output options you would have to specify csv ?
You are not authorized to post a reply.