<p>Hi All,</p>
<p>i want to replace the whole query based on the Report Parameters.</p>
<p>below is my scenario.</p>
<p> </p>
<p>i have a report with parameter having Radio Button Options,see the attached for parameters section.</p>
<p>the parameter values are</p>
<p><strong> USA</strong></p>
<p><strong> All</strong></p>
<p> </p>
<p>when i have selected <strong>USA </strong>below query should be used in dataset.</p>
<p> </p>
<p><span style="color:rgb(147,26,104);font-family:Monaco;font-size:11px;">select</span><span style="font-family:Monaco;font-size:11px;color:rgb(0,0,0);"> </span><span style="color:rgb(147,26,104);font-family:Monaco;font-size:11px;">*</span><span style="font-family:Monaco;font-size:11px;color:rgb(0,0,0);"> </span></p>
<p style="font-size:11px;font-family:Monaco;"><span style="color:#931a68;">from</span> contacts</p>
<p style="font-size:11px;font-family:Monaco;"><span style="color:#931a68;">where</span> primary_address_country='USA'</p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;">when i have selected <strong>All ,</strong>below query should be used in dataset.</p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;"><span style="color:rgb(147,26,104);">select</span><span style="color:rgb(0,0,0);"> </span><span style="color:rgb(147,26,104);">*</span><span style="color:rgb(0,0,0);"> </span></p>
<p style="font-size:11px;font-family:Monaco;"><span style="color:#931a68;">from</span> contacts</p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;">please let me know your thoughts how to achieve this.</p>
<p style="font-size:11px;font-family:Monaco;">i am hoping that we can handle it by means of SQL itself without need of javascript.</p>
<p style="font-size:11px;font-family:Monaco;"> </p>
<p style="font-size:11px;font-family:Monaco;">if we need javascript please do let me know on how to achieve this with multiple alternatives.</p>
<div> </div>
<div> </div>
