I want to set up filter: sale date < current date.
Should I set the filter at report level?
What is name of current date?
Can I edit the sql code to put sale date < current date on where clause?
How do I put sum of a colum on the group header/at section header?
Thanks!
tl12372 (BOB member since 2010-05-05)
Welcome to B:bob:B!
It kind of depends on what your report is supposed to do!
There is a function called CurrentDate() in WebI, but I think you are talking about the database ‘name’ of current date which varies.
Yes you can but you shouldn’t. Get an object created in your universe which is current date then create a condition in the query panel.
Nick Daniels 
(BOB member since 2002-08-15)
I asked for current date name in wi. You already answered my question.
What are facts that determine whether to set a filter at the report level or to create condition in query panel? What are the differences between them?
Do I need permission to create an object?
Thanks!
jl41514 (BOB member since 2010-04-08)
Let us say I have a filter at report level as Sales>1000 and I don’t want the rows with Sales<=1000, I’ll prefer having it as a condition in the query. It’s simple. Why should I fetch all the data and then apply a report filter when I have an option to bring only the filtered records?
Yes, you need to have rights on the universe.
Jansi 
(BOB member since 2008-05-12)