Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Devaka Cooray
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
  • Paul Clapham
  • Knute Snortum
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Ron McLeod
  • Piet Souris
  • Stephan van Hulst
  • Carey Brown
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

Birt: Avoid executing dataset when the bound table in report is hidden

Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I am new to BIRT reports.

My report has 22 tables, each table being filled using a dataset.

Now, a user has an option from the UI through 22 checkboxes to select which table to show and which one to hide. He also has a 23rd checkbox to select all tables.

The requirement::

When the user hides any table, the dataset to which the table is binded, should not be executed.

Can i use beforeOpen method for this??? If yes, how???

This is important because each dataset has one stored proc call and each stored proc is having on an average 7 JOINs.

Please help because this is making my report generation time really long.

Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!