default value as a comment(*/)

[yoniw]

Hey All:)
We have a report that contains a HUGE sql (we are using union of 7 tables).
The report is a son report (drill) from a lot of other reports we have.
we created a trick that "activates" only certain tables - we are using a token with a remark as default value (and passing space if we want to activate. it looks kind of like this:

#prompt('yoni1','token','/*')#
select * from yoni
union
#prompt('yoni2','token','*/')#

#prompt('michael1','token','/*')#
select * from michael
union
#prompt('michael2','token','*/')#

#prompt('shachar2','token','/*')#
select * from shachar
#prompt('shachar2','token','*/')#

union
select * from dual_table

the dual table is not so interesting, it is good if we have only one table we want to display (it contains nulls only).


We have a problem, we would like instead of passing /* and */ to all the tables we don't want to see, we want to make as default the /* and just pass in the drill through "space" to the tables we want.

Cognos for a reason cannot have as a default value this : */ (in the prompt control in the prompt page only! not in the sql, the sql works great!)

maybe a default value cannot start with *? or something else?

any ideas will be very helpful to me...

Regards,
Yoni

[yoniw]

already got it,
Thanks anyway.