Auto report generation

RiaR

Hi All,

I have to create two reports. One as Master report, consider the output of that report is 'Manager ID'.
My 2nd Report is for Employee details. This report will be generated by getting the parameter 'Manager ID' from my first report. According to that parameter Employee details have to be generated.
How i can achieve this? and how i have to deploy this in iServer?

Please guide me with example

Ria

kclark

You can use drill through links in your master report. Then use a hidden parameter in the subreport. In the example I've attached I used this SQL query to get all managers from the DB<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>select CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER, CLASSICMODELS.EMPLOYEES.REPORTSTO, CLASSICMODELS.EMPLOYEES.LASTNAME, CLASSICMODELS.EMPLOYEES.FIRSTNAME, CLASSICMODELS.EMPLOYEES.JOBTITLE
from CLASSICMODELS.EMPLOYEES
where CLASSICMODELS.EMPLOYEES.JOBTITLE <> 'Sales Rep'</pre>
<br />
Then I created a drill through link on the employee number that passes the value of row["EMPLOYEENUMBER"] to the subreport.<br />
<br />
In the subreport I used this query to get all of the employees that report to that manager.<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>select CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER, CLASSICMODELS.EMPLOYEES.REPORTSTO, CLASSICMODELS.EMPLOYEES.LASTNAME, CLASSICMODELS.EMPLOYEES.FIRSTNAME, CLASSICMODELS.EMPLOYEES.JOBTITLE
from CLASSICMODELS.EMPLOYEES
where CLASSICMODELS.EMPLOYEES.REPORTSTO = ?</pre>
<br />
Then I was able to link the hidden parameter in the subreport to REPORTSTO in the parameters section of the edit data set UI.<br />
<br />
Let me know if you have any questions