Is conditional access to a dataset possible?

Hi,

I have a report which has several web services datasets. I would like users to be able to select report params that will determine which datasets are accessed when the report is run.
I tried using conditional statements to determine the visibility of tables that are bound to particular datasets - this worked for hiding or showing data, but all of the datasets were still accessed even when the associated table's visibilty was false.

Is there a way to have a conditional statement so that particulat datasets are not accessed at all?

Find more posts tagged with

Comments

richardc

Just re-phrasing my question:

Is there an event which I can make conditional for connection to a web services dataset?

qiuyu0809

You can create several data set connected with different web service.
In beforeFactory of the report, write this:

reportContext.getReportRunnable.designHandle.getDesignHandle().findElement("mytable").setProperty("dataset",params["ds".value])

Hope it helps!

richardc

Hi qiuyu0809,

Thank you - that's quite helpful

I am now using (in v2.3.2):

if(hideTable){

mytable = reportContext.getDesignHandle().findElement("the_table");
mytable.dropAndClear();

}

which avoids a connection being made to the dataset of the table that it is bound to, if the boolean 'hideTable' is true.