Hidden table still execute sql question ?

Hakan

Hi!

I have just created a new report in which parts of the report needs to be hidden depending on the report parameters. One report item that needs to be hidden is a table that is bound to a specific data set.
But when this table is hidden, the sql query of the bound data set is still sent to the database.
Is there a way of preventing this behaviour ?

Thanks,
H?kan

johnw

Give your table a name in the Property Editor.

In the Script Editor for the report, in either the Initialize or Before Factor, use the following script:

if (params["hideMyTable"].value == true)
{
reportContext.getDesignHandle().findElement("TableToDelete").drop();
}

This will remove the table from the design at runtime, preventing it from executing its query.