BusinessObjects 4.1.2
I’ve been able to return results from BOQuery but want to only return DISTINCT rows, not all of them.
I haven’t seen anything in the Report Script manual.
Is this possible? If so, how?
Thank you in advance.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Listserv Archives (BOB member since 2002-06-25)
I haven’t seen anything either.
I had a similar problem but was creating my own LOV for a dynamic report and resolved the dups by sorting the values then looping through to match the current row against the previous one. If it matched, skip and go on to the next value. Simple but effective.
The above may not be of any help in your situation, but it’s an option to consider.
But it does seem odd that there is no way to add a distinct clause using BOQuery in SBL. Maybe it will be an enhancement in version 5,
who knows.
Jim Droppa
Source Consulting
On Mon, 26 Oct 1998 07:41:05 PST, Thomas Gateway wrote:
BusinessObjects 4.1.2
I’ve been able to return results from BOQuery but want to only return DISTINCT rows, not all of them.
I haven’t seen anything in the Report Script manual.
Is this possible? If so, how?
Thank you in advance.
_______________________________________________________ Get your free, private e-mail at http://mail.excite.com/
Listserv Archives (BOB member since 2002-06-25)