I created a report that the end client wants to see in Excel format and not PDF. It has two tables and one of them should be hidden based on key values. I use a dynamic data key on the "Visible" property of the table but when I generate the report as Excel the table always displays and Report Module doesn't care about the key value. Maybe it is a bug or I missed something here, any workaround is appreciated.
The report module's Excel generation isn't very flexible. You should simply generate your Excel file with the Apache POI libraries directly. No report at all.
Yes, It is also cheaper, and easily saves report module costs.