system
June 28, 2007, 3:31am
#1
I have a report with lots of prompts but my report requirement is that if I type “ALL” or something else that report show all the values with out using macros or VB script how could I do with easiest way…cheers!
srinivasdq (BOB member since 2006-11-22)
system
June 28, 2007, 4:28am
#2
Hi,
This topic has been discussed earlier…you can visit the Designer FAQ page
the first 2 topics there could help you.
Regards
raovala (BOB member since 2004-11-01)
system
June 28, 2007, 5:03am
#3
Heres one link
Hi,
I am trying to add an all object to my LOVs. I have been through many of the posts and I did find one that referred to SQL Server, but I cannot make it work.
I have added the following to my LOV
UNION
SELECT ‘ALL’
When I select my LOV I can see ALL being displayed, but when using ALL in a condition it returns nothing when it should return everyting. Can someone please tell me what I am doing wrong.
Thanks
Anna
lustigb (BOB member since 2007-01-29)
Cheers
haider (BOB member since 2005-07-18)