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

Drill Around question

 6 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
George Graham
Veteran Member
Posts: 201
Veteran Member
6/9/2011 5:05 PM
    I know in Crystal Reports I can create a hyperlink using drill.jsp. And I can use query builder to get the specific drill strings.

    However, is there a way to do a full drill around similar to what pulls up in portal?

    I.E., when I'm on the Employee field in HR11 and select drill I the menu of all drill arounds.

    I've tried capturing the calls from within portal but those calls are simply generating the drill lists and I assume the servlet is then building the form displayed....
    Fernando Labrada
    Basic Member
    Posts: 14
    Basic Member
    6/13/2011 6:09 PM
      Are you referring to something like:

      "Drill.jsp?_TYP=DT&_SYS=HR&HCU=&Hlw=&01="+cstr({table.COMPANY},0,'')+"&H07="+cstr({table.EMPLOYEE},0,'')+"&_KNB=H07"

      George Graham
      Veteran Member
      Posts: 201
      Veteran Member
      6/14/2011 12:01 PM
        That's perfect - thanks Fernando! Can you tell me how you found that? I have not been able to find a lot of documentation on drill.jsp.
        Fernando Labrada
        Basic Member
        Posts: 14
        Basic Member
        6/14/2011 12:42 PM
          It is a bit of a science project which involves going "behind" the drill-around screen and looking at the IDA call. Then thru a series of trial and error, you get the appropriate string. It ain't pretty but it works. 

          Although some of the stuff at the end is a bit dated, Lawson KB article 100618 "How can I find the Drill Around IDA syntax for a form to use in a Crystal Report?" is a good start. Just ignore step 9 and look at the drill string in my previous post instead.

          One tip: while you are doing the detective work in the browser, you will need the product line section of the command (i.e. &_PDL=PROD), however you wont need that section in the Crystal hyperlink.

          Once you do a few, you get a feel for what's important and you'll be knocking these things out in no time.



          How can I find the Drill Around IDA syntax for a form to use in a Crystal Report?
          How can I find the Drill Around IDA syntax for a form to use in a Crystal Report?
          How can I find the Drill Around IDA syntax for a form to use in a Crystal Report?
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
          6/14/2011 8:12 PM
            I've found that the Fiddler tool is invaluable for security-related issues. Perhaps it can capture the exact call that the browser is making in this instance as well?

            Just my 2 cents.
            Ruma Malhotra
            Veteran Member
            Posts: 412
            Veteran Member
            6/14/2011 8:33 PM
              LAL or the Lawson application linker is what Lawson uses to drill into a transaction like in the applications. There are different ways of constructing a drill string using ags, ida or LAL. There is lot of information in the rs admin guide on all this. If you put each parameter of the drill string together you should be able to construct a drill string that works like the drill around in Lawson. I have often constructed drill strings using the syntax in the rs guide.
              Fernando Labrada
              Basic Member
              Posts: 14
              Basic Member
              6/14/2011 8:53 PM
                Ruma is right, this is covered in Chapter 7 of the RS Admin Guide. The most valuable piece is probably the few sample drill strings they include. I still find that looking at the IDA call behind the specific screen that you want to drill to is the best place to start in constructing the drill string.

                Greg, I have used Fiddler quite a bit for debugging self-service and security but never for this. Will have to take a crack at it.