I am developing an XLSX report that contains a URL hyperlink to an application and passing it a parameter when I get the Keyword has illegal value error.

Here is the code

TYPE=DATA,
COLUMN=N12,
URL=https://sugarcrm-ce.learningcaregroup.com/lcgschools/index.php?module=Leads&action=DetailView&record=( \
LEAD_ID=N12 \
),
$

If I alter the hyperlink to just the application it works just fine.
URL=https://sugarcrm-ce.learningcaregroup.com/lcgschools

I tried stepping through and received the error with this as well
https://sugarcrm-ce.learningca...dex.php?module=Leads

Any help would be appreciated.
Thanks

This message has been edited. Last edited by: <Emily McAllister>,

Its probably trying to evaluate &action and &record as amper variables

Use &|action and &|record

Also, I think your URL call is wrong.

Please check this documentation.

Linking to a URL

TABLE FILE CAR
PRINT
COUNTRY
CAR
MODEL
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N1, URL=https://sugarcrm-ce.learningcaregroup.com/lcgschools/index.php?( \
module = 'Leads' \
action = 'DetailView' \
record = 'BLAH' \
LEAD_ID = N1 \
), 
$
END

The generated link is:

https://sugarcrm-ce.learningcaregroup.com/lcgschools/index.php?module=Leads&action=DetailView&record=BLAH&LEAD_ID=FRANCE

Thank you! I started looking at the url and figured out that I could break it out in the manner you suggested.