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

RW100 for Crystal Report

 3 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
wintergreen
Veteran Member
Posts: 93
Veteran Member
4/28/2011 3:26 PM
    I'm trying to do a RW100 as a data source to Crystal Report for budget report.
    How do you define a RW report which includes all the account units? Currently we have one RW report for one account unit in RW100.  So we have 50+ RW100 reports for each account unit for its budget report.  Is it supposed to have all the account units in one RW when you want to use it as a data source for Cystal Report ?( Each account units have the same account number for salaries, beneifts,....etc)  Otherwise,  I need to have 50+ data souces? 
    Do I misunderstand any concept here?
    jrbledsoe001
    Veteran Member
    Posts: 91
    Veteran Member
    4/28/2011 3:42 PM
      Hi, I caught your post out of the corner of my eye. E-mail me and I'll send you screen shots how to use a lawson canned report as a crystal data source. joanna_bledsoe@dell.com
      Ruma Malhotra
      Veteran Member
      Posts: 412
      Veteran Member
      5/2/2011 6:51 PM
        To have 50+accounting units on a single RW100 data source for a crystal report is very easy. You will create an acct unit list in lawson in such a way that it includes all of the 50 + acct units. You then run the RW100 report at the posting level or the level which has the acct unit in you organization level. You can do this by ticking off the reporting option value at your levels on RW100.

        When you use this as a source for crystal the report will show the data for each accounting unit. So instead of 50+ reports you will have one report with 50+ accounting units separated.
        wintergreen
        Veteran Member
        Posts: 93
        Veteran Member
        5/26/2011 1:29 PM
          Joanna/Ruma, thanks for the information. But I have decided to create reports directly from database tables. It takes too much efforts to redesign the RW100.