I'm trying to use radio buttons on my prompt page that will pass the parm value to my SQL.
I have the 4 separate buttons each with their own parm. Each button is set up with a collection like this
Button 1 ...
Use Display
1 VA
Button 2 ...
Use Display
1 PHS
etc...
The SQL where clause looks like this
WHERE I.item_id = CM.cat_map_id
AND CM.cat_map_id = CMF.cat_map_id(+)
AND CMF.FLD_NAME (+) = 'lowDispUnitsPerPack'
AND I.realm_num = 1024
AND
( ( #prompt('VA', 'STRING','')# = '1' AND I.ELIG_VA = 1 )
OR
( #prompt('PHS', 'STRING','')# = '1' AND I.ELIG_PHS = 1 )
OR
( #prompt('ASP', 'STRING','')# = '1' AND I.ELIG_ASP = 1 )
OR
( #prompt('MEDCAID', 'STRING','' )# = '1' AND I.ELIG_MEDICAID = 1 )
)
All the button are set to Required "No"
The problem is that when I execute the report all the buttons are showing as required and if I select one I can't deselect it.
I want to be able to tell if the user selects any combination of buttons and interigate them in my SQL .
I'm using ReportNet 1.1
Thanks
Steve
I have the 4 separate buttons each with their own parm. Each button is set up with a collection like this
Button 1 ...
Use Display
1 VA
Button 2 ...
Use Display
1 PHS
etc...
The SQL where clause looks like this
WHERE I.item_id = CM.cat_map_id
AND CM.cat_map_id = CMF.cat_map_id(+)
AND CMF.FLD_NAME (+) = 'lowDispUnitsPerPack'
AND I.realm_num = 1024
AND
( ( #prompt('VA', 'STRING','')# = '1' AND I.ELIG_VA = 1 )
OR
( #prompt('PHS', 'STRING','')# = '1' AND I.ELIG_PHS = 1 )
OR
( #prompt('ASP', 'STRING','')# = '1' AND I.ELIG_ASP = 1 )
OR
( #prompt('MEDCAID', 'STRING','' )# = '1' AND I.ELIG_MEDICAID = 1 )
)
All the button are set to Required "No"
The problem is that when I execute the report all the buttons are showing as required and if I select one I can't deselect it.
I want to be able to tell if the user selects any combination of buttons and interigate them in my SQL .
I'm using ReportNet 1.1
Thanks
Steve