alternative sql querys in datasource..

[user]

I hvae a big select query
And now it has always to return a data
I have modified it and it now looks
big-select..
union select..
it works and I have always some data..

Is there a more elegant way something like?

IIF BIG-SELECT IS NOT EMPTY
big-select...
ELSE
select...

[Alex K.]

Hello,

Unfortunately, it will not be possible to use the in the DataSource.
You can implement this feature from the application code, in which, for example, you use 2 datasets, and depending on the result, send in a report this or that dataset.

Thank you.