Crystal Report hyperlink- GL90

Hi Carl, that's a really good question. To understand why it isn't working as you would expect requires understanding how Lawson forms are defined, and following the form definition from the Portal back to the underlying form. In this case, you might be trying to look at multiple periods, like this one, where the inquire is based on period 1 through period 3:


In this case, you'd *think* you'd pass in an HK variable in the URL looking like this:

&_HK=4321101%20%20%20%20%20%20%20%20%20%20%20%20011100000020060103

Broken apart, this means:

Co 4321
Acct Unit 101
Acct 011100
Sub Acct 0000
Fiscal Year 2006
From Period 01
To Period 03

However, as you've discovered, it doesn't work.

To understand why, you need to look at the underlying form definition, and specifically, at the _HK field:


As you can see, the field is defined with a size (sz) of 29. Calculating how the fields are defined, you can now see that it is stopping at Sub Account:

Field Length Cumulative Size
Company 4 4
Acct Unit 15 19
Account 6 25
Sub Acct 4 29
Fiscal Yr 4 33
From Pd 2 35
To Pd 2 37

Looking further into the screen definition for GL90.scr:


Part of the form definition is an "transaction edit code" for each field in the form. Company is "SK"; Acct Unit and Account is "SN", Sub Account is an "SL". But Fiscal Year and and from/to period are "SB". In other words, according to the Lawson documentation, they are not "key" fields:


So, that is why it doesn't work.

Thanks for the detailed information!  I had looked at the form definition and figured that this was probably the case, but I figured I would ask.

I guess I will just link the users to this form and they will have to update the Fiscal Year and Periods.