Title: Lbi And Back Office Reports
Description: Is any one distributing back office rpt
vc727 - February 20, 2007 02:48 PM (GMT)
Has any one used LBI to burst/Distribute any of these reports.
PR141 – Payroll Register.
PR195 – Accrual Program.
PR197 – Payroll Close.
cjmart - February 20, 2007 03:26 PM (GMT)
I've never tried, but the per the Reporting Services user guide, these programs are not compatible with bursting. If anybody has bursted reports that are not "compatible", I'd love to hear more about how you did it.
mnye - February 20, 2007 08:36 PM (GMT)
the only other way would be to use the OLE DB Provier for Lawson to link to the report file in Crystal and then publish the Crystal Report.
vc727 - February 20, 2007 08:39 PM (GMT)
Are you saying to rebuild the whole report in crystal or is there a way to view the report output in crystal.
arvin - February 20, 2007 08:46 PM (GMT)
These are non-burstable reports, you can publish these reports as URL, here are the steps:
1. From Lawson Portal select Go To > Reports to access the Jobs and Reports screen.
2. View the .txt version of the report that you want to publish, right click the report and selct Properties, and Copy the report's URL.
3. From Reporting Services Admin, click Pulish New Report, select URL in the "Type of Report" field. In the Address field paste the URL of the report that you copied from Lawson Portal. Click Publish and complete all the Options (i.e, Report Users, output options, etc.).
mnye - February 21, 2007 06:52 PM (GMT)
| QUOTE (vc727 @ Feb 20 2007, 12:39 PM) |
| Are you saying to rebuild the whole report in crystal or is there a way to view the report output in crystal. |
in short, yes. Basically you will create a data source in Crystal that links to the actual output report file on the lawson server. That file is then translated into fields, youll have to deteremine what fields hold what values. They can sometimes be pretty cryptic too, like PrimaryLevel1, PrimaryLevel2, etc.
If you dont want to go to the trouble of reverse engineering a canned report, its an easy (here the word "easy" used in context of interpreting a cobol program) way to get that same data in a content rich form (Crystal).
cjmart - March 22, 2007 04:27 AM (GMT)
Eric,
Check out the eBroadcasting guide where it talks about adding custom tags to backoffice reports to make them burstable (page 81 I think). I think this may be what you are looking for. It does involve modifying the PD and rpt of the Lawson program. Even though this documents the process for making them burstable in eBroadcasting, I recently heard that this will allow for bursting in RS 9 as well.
Chris