Page 1 of 1

alternative sql querys in datasource..

Posted: Sun Nov 21, 2010 10:17 am
by 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...

alternative sql querys in datasource..

Posted: Mon Nov 22, 2010 3:46 am
by 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.