Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Help - Passing multiple parameters and values through URL without exceeds..
Migrateduser
I have a concatenated string with the all parameters and all values to make the URL and create a birt report.<br />
<br />
I have many parameters with many values each.<br />
<br />
But, URL exceeds the length and break the process.<br />
<br />
Example of code who make URL string(PHP):<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
if ( $this->getVersaoBirt() ) {
$stBirt = "http://" . $http_host . ":".constant('BIRT_PORT')."/viewer_" . str_replace('.','',$this->getVersaoBirt()) . "/";
} else {
$stBirt = "http://" . $http_host . ":".constant('BIRT_PORT')."/viewer/";
}
$stBirt.= "run?";
// adiciona nome do rpt - (Add a name to rpt)
//$stBirt .= "reportLayout=" . $stReportLayout;
$stBirt.= "__report=" . realpath($stBirtLayoutsFolder . $stReportLayout);
// $stBirt .= "&" . sessao->id;
// conexao - (connection )
$stBirt.= "&db_driver=" . urlencode('org.postgresql.Driver') . "";
$stBirt.= "&db_host=" . urlencode($Con->stHost);
$stBirt.= "&db_port=" . urlencode($Con->inPort);
$stBirt.= "&db_user=" . urlencode($Con->stUser);
$stBirt.= "&db_password=" . urlencode($Con->stPassWord);
$stBirt.= "&cod_acao=" . Sessao::read('acao');
$stBirt.= "&exercicio=" . Sessao::getExercicio();
$stBirt.= "&db_conn_url=" . urlencode("jdbc:postgresql://" . $Con->stHost . ":" . $Con->inPort . "/" . $Con->stDbName . "");
// varre parametros - (scan parameters)
foreach($this->arParametros as $parametro) {
$stBirt.= "&" . $parametro[0] . "=" . urlencode($parametro[1]);
}
// formata??o num?rica para valores na moeda brasileira - (formatting to Brazilian currency )
$stBirt.= "&__locale=pt_BR";
// formato - (format)
$stBirtPdf.= $stBirt . "&__format=pdf";
$stBirtDoc.= $stBirt . "&__format=doc";
$stBirtXls.= $stBirt . "&__format=xls";
$stBirt.= "&__format=" . $this->getFormato();
</pre>
<br />
I'm using Birt 2.5 and Viewer 2.5.0.<br />
<br />
Anyone can help me to create another way to pass all these parameters to Birt without exceeds the URL or using another method?<br />
<br />
Thanks!
Find more posts tagged with
Comments
There are no comments yet