<p>EDIT: got this figured out
</p>
<p> </p>
<p>I am new to the forum so sorry if this is the wrong place.</p>
<p> </p>
<p>I am running into an issue where running varying parameters is not properly running. I have a shell script that is automating a report to run. This report any or may not have multiple varying parameters specific to the report.</p>
<p> </p>
<p>For example below i have a script '<em>birt.sh</em>' (below). I am using export to set the variables, I can get the <span> </span><strong><em>$START</em></strong><span> </span> and <strong><em>$END</em></strong> to run since those are specific dates and only has 1 input option for each. <span> </span></p>
<p> </p>
<p>The problem I run into is when I attempt to use <span> </span><span> </span><strong><em>$VAR1</em></strong><span> </span><span> </span>, <strong>$<span> </span><em>VAR2</em></strong><span> </span>, <strong>$<em>VAR3 </em></strong>for ex<span> </span>ample. I set those to query a mysql db,<span> </span> pull data since that information may vary at any give moment. It pulls the data but when it runs it only select the default option or 1st selection available, as if I ran the Report using the BIRT Viewer and not selection any parameters for <strong><em>$VAR1</em></strong>, <strong>$<em>VAR2</em></strong>, or <strong>$<em>VAR3</em></strong> as outlined in the BIRT rptdesign file.</p>
<p> </p>
<p>Question is how can I have it select all available options in the parameter when this runs or is this even possible with genScript.sh?</p>
<p> </p>
<p><strong>Example <em>birt.sh</em> Script:</strong></p>
<pre class="_prettyXprint">
#!/bin/bash
START=`date -d "yesterday" +"%F"`
END=`date +"%F"`
VAR1=`mysql dbname -s -N -e "SELECT name FROM table"`
VAR2=`mysql dbname -s -N -e "SELECT name FROM table"`
VAR3=`mysql dbname-s -N -e "SELECT name FROM table"`
sh BIRT_HOME(path)/ReportEngine/genReport.sh -m runrender -f PDF -p Start=$START -p End=$END -p parameter1=$VAR1 parameter2=$VAR2 -o /some/path/to/PDF/filename.pdf BIRT_HOME(path)/rptreports/SomeReport.rptdesign
sh BIRT_HOME(path)/ReportEngine/genReport.sh -m runrender -f PDF -p Start=$START -p End=$END -p parameter3=$VAR3 -o /some/path/to/PDF/filename.pdf BIRT_HOME(path)/rptreports/SomeOtherReport.rptdesign</pre>
