Hi,

I need to use a link called "Back to summary" in the detail page so that it links back to the summary page.
While doing so it prompts me for paramter that i already pass

"(FOC295) A VALUE IS MISSING FOR:&HIDSTRNME" . This HIDSTRNME is a variable that i pass from my html page to summary and then detail.In both the pages i display this as a header. Example:

Summary pg:rrxsttrs

A snippet of the code below

 

-SET &&hidSTRNME        =&hidSTRNME;
TABLE FILE HLD1_TRS
SUM
     total     AS 'Total Transfers' OVER
     INCOMING  AS 'Incoming (Non Target Pharmacy)' OVER
     TINCOMING AS 'Incoming (Target Pharmacy)' OVER
     OUTGOING  AS 'Outgoing (Non Target Pharmacy)' OVER
     TOUTGOING AS 'Outgoing (Target Pharmacy)'
HEADING
"Transfer Rx Report - Summary Level          <+0>                                                                 RedRx"
"&&hidSTRNME"
"Date Range : &&calStartDate - &&calEndDate  <+19>																  Target Pharmacy"
"Report Run Date and Time :  <DATE <TMCOLON"
" "
"To view Transfer details click on one of the five links below"
" "
WHERE RECORDLIMIT EQ 10
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
	GRID=OFF,
	FONT='ARIAL',
	COLOR='BLACK',
	BACKCOLOR='NONE',
	STYLE=NORMAL,
	BOTTOMGAP=0.05,
$
TYPE=TITLE,
	FONT='ARIAL',
	SIZE=8,
	JUSTIFY=LEFT,
	COLUMN=N1,
	FOCEXEC=rrxsttrd(RPTDTID='0' TOTAL=N1 INCOMING=N2 OUTGOING=N4 TOUTGOING=N5 TINCOMING=N3 hidSTRNME),
    TARGET='_blank',
    WHEN=N1 GT 0,
$

TYPE=TITLE,
	FONT='ARIAL',
	SIZE=8,
	JUSTIFY=LEFT,
	COLUMN=N2,
	TARGET='_blank',
	FOCEXEC=rrxsttrd(RPTDTID='1' INCOMING=N2 hidSTRNME),
	WHEN=N2 GT 0,
$
 

This works fine .


Detail page:rrxsttrd.fex

Snippet of the code below:

  
-DEFAULT &hidSTRNME=&hidSTRNME;

TABLE FILE HLD_STR
BY CTR NOPRINT
BY PatientName NOPRINT
BY TRANS_S NOPRINT
HEADING
"&&hidSTRNME"
"Date Range : &&calStartDate - &&calEndDate"
"Report Rundate and Time :  <DATE <TIME"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
-*ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
  UNITS=IN,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=10,
     COLOR='BLACK',
     BACKCOLOR='NONE',
     STYLE=NORMAL,
     SQUEEZE=ON,
  GRID=OFF,
$
TYPE=HEADING,
     LINE=5,
     FONT='ARIAL',
   [B]  FOCEXEC=rrxsttrs(hidSTRNME),[/B]     SIZE=8,
     STYLE=BOLD,
     COLOR=RGB(155 155 155),
$

Here i pass it. But iget the FOC295 error.

I have serached in the forum as well http://forums.informationbuild...1057331/m/1371078331. Also i have tried using
&hidSTRNME and all others.Please let me know where am going wrong.

Apprecitae your help.

Thanks!
Janani

This message has been edited. Last edited by: Kerry,

Janani,

When you pass a parameter value in a drill-down, you have to use the syntax:
parameterName=parameterValue
This is not the case when you write:
FOCEXEC=rrxsttrs(hidSTRNME)
You probably should write:
FOCEXEC=rrxsttrs(hidSTRNME='&hidSTRNME')

Also, &&hidSTRNME is not the same as &hidSTRNME. One is global, the other is local. There are several discussions on the difference on the forum . As for the original problem, Danny has given the solution - variables passed via drilldown always occur with name and value coupled. If the variable passed is a field, you just specify the field as the value. If it is an &variable, you must specify the variable name including the '&'.

Thanks a lot !!! It helped!!!