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:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
505
Members:
0
Total:
505
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
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
jeff-lbi
Basic Member
Posts: 21
1/5/2012 3:25 PM
There are only options for CSV, xls, pdf, etc. I do not see an option for DATA ONLY excel.
How can this be accomplished on the scheduled LBI reports? (It IS an option on the on demand report configurations, but not scheduled. Why? And is there a work around?
Ruma Malhotra
Veteran Member
Posts: 412
1/5/2012 3:35 PM
I have had the same issue. From what I know there is no option for excel data import. The closes was export output in the form of csv.
Matthew Nye
Veteran Member
Posts: 514
1/5/2012 5:44 PM
if you go to Report Administration > Maintain Reports > History link for the offending report > Details link for one of the historical instances > Output Settings is Microsoft Excel Data Only (XLD) checked?
jeff-lbi
Basic Member
Posts: 21
1/25/2012 2:07 PM
Yes it is checked when I follow those steps.
But the default output in the drop down of the historical instance is the XLS.
To me what the historical instances say though doesn't matter does it? The real issue is when you view the Schedule details of the report in question, and go to Bursting and Distribution, there is a drop down for output type. In that drop down you only get RPT, XLS, PDF, DOC, CSV, but no Excel Data only option. (The main report itself has output settings for excel data only, and that works when the report is run on demand) Its only the delivery\scheduled version of the report that doesn't seem to have an option for excel data only.
Matthew Nye
Veteran Member
Posts: 514
1/25/2012 2:20 PM
Ah, I thought the issue was that the user was not seeing the option when trying to export from a historical instance via the Crystal Viewer. There is no way that I know of to modify the options for Output Source on the schedule Bursting screen.
vc727
Advanced Member
Posts: 44
2/8/2012 6:10 PM
I email spreadsheets from several reports in excel data only format, Are you sure that the xls data only option is selected as one of the allowed format types on the report itself as long as I have that format checked on the report it shows as an option in the bursting/delivery section of the schedule. Not the default type but just an allowed format.
jeff-lbi
Basic Member
Posts: 21
4/26/2012 4:51 PM
See the attachment.
It is the screen for a particular report we have.
When selecting from "Output Type" you will see the options in the drop down are limited to XLS, RPT, PDF, DOC, CSV
There is NO option for XLS (Data Only) as there are in the normal report configuration.
This is what I am referring to.
jeff-lbi
Basic Member
Posts: 21
4/26/2012 4:58 PM
"Are you sure that the xls data only option is selected as one of the allowed format types on the report itself "
Yes. It is selected on the Configuration of the report itself.
But not available in the drop down for Output Type in the Bursting and Distribution screen.
You are not authorized to post a reply.