nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data set event problem

sunnypatel285

Hello,

In my report there are 6 datasets.

In all these datasets srored procedure is used.And one parameter is passed to that.

My question is how can i handle the dataset for null parameter?

Means, i dont want to load the stored procedure if the parameter was not passed.

Because sometimes i have only one parameter for dataset-1, and remaining have no parameter passed.

So at that time my report loads all datasets and took so much time.

So i want script for dataset that i dont call procedure if parameter is null.

Find more posts tagged with

Comments

Hans_vd

Hi Sunny,

There is a devshare article about removing tables based on report parameters here: http://www.birt-exchange.org/org/devshare/designing-birt-reports/1027-drop-a-table-based-on-a-report-parameter/

If the table is removed, the stored procedure will not be executed.

Regards
Hans

sunnypatel285

Hello,

Now i got the solution..

But the dataset is null (because the parameter is not passed to stored procedure) ,so the chart regarding to that procedure creates an error like below attached screen shot.

So how i handle this situation for chart when there is no data.

Hans_vd

What do you mean by "the dataset is null"?
The execution of the stored procedure leads to an error.

The link I provides is about removing a table, can you try removing a chart in the same way? The stored procedure will not be executed when you do that, and so you won't get any errors.

sunnypatel285

Thanks a lot