Jasper Ideas

Reference Topic in Ad Hoc View (instead of a hard coded query)

My typical reporting process is:

  1. Create a topic with specified fields from a database view

  2. Use the topic to create an ad hoc view then the report

Issue: Customer later comes and says they want a new field available (or a masking definition changed - e.g., more decimal places) for an ad hoc view.

I add the field/update to the topic but since the query is actually hard coded in the ad hoc view (not just a reference back to the topic), I now have to redo the ad hoc view as well - the topic change is not reflected or refreshed in the view.

If the ad hoc view just referenced the topic, I could make a simple change to add a field without having to redo the entire view as well (with filters, and sorts, etc.).

This situation occurs often where a specific customer wants something added due to processing needs. Would like an easier way to update queries/topics without having to redo the entire ad hoc view/report/

  • Guest
  • Dec 8 2021
  • Under consideration
Components JasperReports Server, AdHoc
  • Attach files
  • Guest commented
    15 Mar 05:34pm

    We really need this!

  • Martin Taal commented
    31 Oct, 2022 11:22am

    We also need this change, would save us a lot of trouble/extra work.

  • Admin
    Divya Chouhan commented
    4 Jan, 2022 07:51am

    Thank you for your idea! We will consider it as a future requirement.

  • Guest commented
    3 Jan, 2022 02:06pm

    This change would be really helpful for all the users/clients who are using the TOPIC as the underlying Data Source.

  • sujeesh lal commented
    3 Jan, 2022 02:06pm

    We are waiting for this feature to get implemented