[hamaliomec]

Hey, I'm trying to create an interactive report that starts with a list of companies and redirects to a list of employees in the company after clicking on a particular company. I have already created the dataset from an excel file and created the table. How would I go about creating this on-click event handler? I only know the basic syntax of java and javascript and do not know how to approach creating the subreport that is filtered by the user's click. Any help would be fully appreciated.

[averma]

Hi hamaliomec,
The concept is called drill down reporting and you don't need any programming knowledge to do this. Just select the report element for which you want to provide a drill down and go to property editor -> Hyperlink. Here you can sepecify a link to URI, bookmark or drill through to a different BIRT report. Here is an example of a drill down report:
http://www.birt-exch...n-birt-reports/

[hamaliomec]

Thanks a bunch, averma!

Follow-up question: Is there a way to create a grouped table that is collapse-able by the groupings?

[averma]

If you right click on the table detail row you will see the option to create groups. Here is a finished example:
http://www.birt-exch...ps-client-side/

[hamaliomec]

Oh, I see. Thanks.
Another follow-up question: How did you upload your demos as live reports such that I could interact with them on the web? I'm trying to put my report up onto a website so end users can directly interact with it online. Your help would be fully appreciated

[averma]

I am using a hosted copy of BIRT iServer on BIRT Exchange demo server. You can download your own evaluation copy of BIRT iServer from the link below and install it on a server available to your users:
http://www.birt-exch...m/be/downloads/

You could also use BIRT onDemand which is a turnkey managed Cloud BI solution:
https://www.birtondemand.com

[hamaliomec]

Thanks for the help! It works fine for most reports, but gives me an error when I try to open my report that uses an Oracle databse:

3301: Cannot get report parameters for the specified file.

[averma]

Are you using a oracle database driver other than what comes out of box? If so you will need to provide that driver to BIRT iServer (assuming you are getting this error on BIRT iServer). The directory where it expects jdbc driver is:
[Install Dir]/Jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_<version>/drivers/