Hi everyone,<br />
In my database i have 2 functions which takes arguments as resulting query columns and result some value.<br />
<br />
Examle<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>select col1, col2, col3, fun(col1,col2,col3), fun(col1,col2,col3) * fun2(col1,col2) from table1</pre>
<br />
I am calling these functions (<strong class='bbc'>fun,fun1</strong>) with in the query, unlike is there is any way to call these functions from birt instead of query. And how to store the function value to use it several times.<br />
<br />
How to call user defined database functions by passing the column values and display inside the report.<br />
<br />
My function is very big and takes some time to execute. If i call it twice for each row the performance may be decreased. So I want to call it once for each row and store them for next usage in the same row. How to do that?<br />
<br />
Pls help me. It is very urgent.<br />
<br />
How to attach rpttemplet file, What is the diff b/e rpttemplet and rptdesign<br />
<br />
Thanks in Advance
