Title: Drilling On Custom Table Fields
Description: is there a way to drill to custom tables
mmrobinette - April 28, 2008 11:49 PM (GMT)
All
Does anyone have a doc on how or if it's possible to drill from a .rpt (cobol rpt) to custom table data. Essentially we will be importing data from an outside sql table to a custom lawson table. then we want to run a report and be able to drill to that detail from summary accounts. this is budget data.
How can we do this or is it even possible. Thanks in advance.
Milo - April 30, 2008 05:01 PM (GMT)
Michael:
Yep, no problem. Define new key number(s), use key numbers in screen, define new Selects in .SR file(s), then define your drill-arounds using the .OR file(s). It's easy, if you don't mind the learning curve. Use the ADW Standards manual as your reference. Chapter 4 - Form Rules and Object Rules. (The bump on your forehead :banghead: is where you keep saying, "It's gotta be simpler than this!" but it never is.)
I've attached a small, simple diagram that shows how it works. I don't know if Rube Goldberg designed it, but I have heard rumors that he used to work for Lawson .... :rau:
Oh and BTW, make certain that updates from Lawson don't wipe out your .SR and .OR changes. That can happen. :bonk:
mmrobinette - May 2, 2008 04:13 PM (GMT)
Milo ... thank you so much. This will be a wonderful resource. I am getting myself in a bunch of situations where new skills are learned. It's fun but can be cumbersome too.
Many thanks.
mfrimel - September 16, 2008 08:17 PM (GMT)
Milo,
Nice flow chart. I did all the steps and unfortunately I still can't do selects (I don't need to drill around). I wrote a custom program to go after a custom file in LSF9. I can do all the functions (add, delete, inquiry, etc.) but I don't have the ability to look up data on the file (i.e. select). Any ideas? :banghead:
trezaei - September 17, 2008 04:08 AM (GMT)
| QUOTE (mfrimel @ Sep 16 2008, 12:17 PM) |
Milo,
Nice flow chart. I did all the steps and unfortunately I still can't do selects (I don't need to drill around). I wrote a custom program to go after a custom file in LSF9. I can do all the functions (add, delete, inquiry, etc.) but I don't have the ability to look up data on the file (i.e. select). Any ideas? :banghead: |
You're not using Lawson Security are you? Cause if you are ... :D
Anyway, the .or and .sr files are filled with hundreds of examples on selects (not sure which one off top of my head). Make sure you have setup your kndef and skndef correctly also.
T
mfrimel - September 24, 2008 02:36 PM (GMT)
I AM using LSF security. I changed security to allow access to the new file but it doesn;t seem to make a difference. Is there something else I need in security? Again, I can do add-ins against the file. :bonk:
Milo - October 2, 2008 02:36 PM (GMT)
to 'mfrimel' -- Have you fixed this yet or is still not working? You have to have -
.- KNDEF defined
.- SKNDEF defined
.- Select sections working in the .sr file
and...
you have to have the key number in the correct column in the .scr file ...
and...
you have to run srgen afterwards, to bring in the changes ...
If you've done all that & it still doesn't work, let me know!!