How to replace DB connection parameters at run time

Said

<p><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning /> <w:ValidateAgainstSchemas /> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables /> <w:SnapToGridInCell /> <w:WrapTextWithPunct /> <w:UseAsianBreakRules /> <w:DontGrowAutofit /> <w:UseFELayout /> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState=""false"" LatentStyleCount=""156""> </w:LatentStyles> </xml><![endif]--> <!-- /* Font Definitions */ @font-face {font-family:SimSun; panose-1:2 1 6 0 3 1 1 1 1 1; mso-font-alt:??; mso-font-charset:134; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:1 135135232 16 0 262144 0;} @font-face {font-family:""\@SimSun&quot;"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:134; mso-generic-font-family:auto; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:1 135135232 16 0 262144 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:""Times New Roman""; mso-fareast-font-family:SimSun;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> <!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:""Table Normal"";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"""";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:""Times New Roman"";
mso-fareast-font-family:""Times New Roman"";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New";"">1- create the report parameters.</span></p>
<p class=""MsoNormal""> </p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>        </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">scalar-parameter</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""URL""</span></em> <span style=""color: #7f007f;"">id</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""2""</span></em><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""hidden""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">true</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""valueType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">static</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""dataType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">string</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""paramType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">simple</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">text-property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""promptText""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">User</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">text-property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""isRequired""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">false</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""controlType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">text-box</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""distinct""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">true</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">structure</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""format""</span></em><span style=""color: teal;"">> </span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>                </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""category""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">Unformatted</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""></</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">structure</span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;"">></span><span style=""font-size: 10pt; font-family: "Courier New";""></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>        </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""></</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">scalar-parameter</span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;"">></span><span style=""font-size: 10pt; font-family: "Courier New";""></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>        </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">scalar-parameter</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""User""</span></em> <span style=""color: #7f007f;"">id</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""3""</span></em><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""hidden""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">true</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""valueType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">static</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""dataType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">string</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""paramType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">simple</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">text-property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""promptText""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">User</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">text-property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""isRequired""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">false</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""controlType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">text-box</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""distinct""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">true</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">structure</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""format""</span></em><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>                </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""category""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">Unformatted</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""></</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">structure</span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;"">></span><span style=""font-size: 10pt; font-family: "Courier New";""></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>        </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""></</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">scalar-parameter</span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;"">></span><span style=""font-size: 10pt; font-family: "Courier New";""></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>        </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">scalar-parameter</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""Password""</span></em> <span style=""color: #7f007f;"">id</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""4""</span></em><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""hidden""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">true</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""valueType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">static</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""dataType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">string</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""paramType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">simple</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">text-property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""promptText""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">User</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">text-property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""isRequired""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">false</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""controlType""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">text-box</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""distinct""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">true</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">structure</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""format""</span></em><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>                </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""><</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">property</span><span style=""font-size: 10pt; font-family: "Courier New";""> <span style=""color: #7f007f;"">name</span><span style=""color: black;"">=</span><em><span style=""color: #2a00ff;"">""category""</span></em><span style=""color: teal;"">></span><span style=""color: black;"">Unformatted</span><span style=""color: teal;""></</span><span style=""color: #3f7f7f;"">property</span><span style=""color: teal;"">></span></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>            </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""></</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">structure</span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;"">></span><span style=""font-size: 10pt; font-family: "Courier New";""></span></p>
<p class=""MsoNormal""><span style=""font-size: 10pt; font-family: "Courier New"; color: black;""><span>        </span></span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;""></</span><span style=""font-size: 10pt; font-family: "Courier New"; color: #3f7f7f;"">scalar-parameter</span><span style=""font-size: 10pt; font-family: "Courier New"; color: teal;"">></span></p>
<br /></p>
<p>2- Add to the beforeOpen of the dataSource the code:</p>
<p>url=reportContext.getParameterValue(""URL"");<br />u=reportContext.getParameterValue(""User"");<br />p=reportContext.getParameterValue(""Password"");<br /><br />this.setExtensionProperty(""odaURL"",url);<br />this.setExtensionProperty(""odaUser"",u);<br />this.setExtensionProperty(""odaPassword"",p);<br /><br /><br />3- set the values of the parametes</p>
<p>IRunAndRenderTask task = engine.createRunAndRenderTask(report);<br />task.setParameterValue(""URL"", ""url"");<br />task.setParameterValue(""User"", ""user"");<br />task.setParameterValue(""Password"", ""password"");</p>