OnClick event with filters

Options
hamaliomec
hamaliomec
edited February 11, 2022 in Analytics #1
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.

Comments

  • averma
    averma
    edited December 31, 1969 #2
    Options
    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-exchange.org/org/devshare/designing-birt-reports/518-sample-drill-down-birt-reports/
    Warning No formatter is installed for the format ipb
  • hamaliomec
    hamaliomec
    edited December 31, 1969 #3
    Options
    Thanks a bunch, averma!

    Follow-up question: Is there a way to create a grouped table that is collapse-able by the groupings?
  • averma
    averma
    edited December 31, 1969 #4
    Options
    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-exchange.org/org/devshare/designing-birt-reports/1126-collapse-groups-client-side/
    Warning No formatter is installed for the format ipb
  • hamaliomec
    hamaliomec
    edited December 31, 1969 #5
    Options
    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
    averma
    edited June 5, 2012 #6
    Options
    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-exchange.com/be/downloads/

    You could also use BIRT onDemand which is a turnkey managed Cloud BI solution:
    https://www.birtondemand.com
    Warning No formatter is installed for the format ipb
  • hamaliomec
    hamaliomec
    edited December 31, 1969 #7
    Options
    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
    averma
    edited December 31, 1969 #8
    Options
    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/
    Warning No formatter is installed for the format ipb

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs