I have a free hand sql DP (FH-DP) with folowing fragment in the WHERE clause.
…and (ca.config in @variable(‘Format (ALL):’)
or ‘ALL’ in @variable(‘Format (ALL):’))…
The Variable contains the user input.
The Query seems to work fine with single user selections, with multiple selection and with all “Formats” selected…
It also seems to work when “ALL” entered at the user Prompt (named ‘Format (ALL)’) although i get a “Data Provider delivers no data” message (translation form the german error mssg) during refresh.
Any workaround for that? Like an err. mssg. supression in this specific report?
BTW: I need to use the ‘ALL’ beacuse without, if there are more than 256 “Formats” in the LOV, the user can select max. 256 (or 255) different values and is unable to select all of them.
Or is there any option to set a default selection where all are selected. If the user does not enter anything, all values are selected by default. But it seems like Desktop Intelligence and Web Inteligence dont accept NULL inputs in user prompts at all.
prinzartus (BOB member since 2006-09-07)