BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Configure report header as per query script


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
SamEK
Forum Member
Forum Member



Joined: 08 Jun 2019

Posts: 1



PostPosted: Sat Jun 08, 2019 2:50 am 
Post subject: Configure report header as per query script

i have a report which generates based on a custom query. Basically the dates are set as between sysdate and sysdate +2.

i had the report header set to the UserReponse prompt formula

Quote:

="Departure Dates "+FormatDate(ToDate(UserResponse("Enter value(s) for Departure Date (Start)");"");"dd-Mmm-yyyy") +" till "+ FormatDate(ToDate(UserResponse("Enter value(s) for Departure Date (End)");"");"dd-Mmm-yyyy")


but now since that is changed and there is no userreponse hence getting and error in the header.

my custom query for the dates is
Quote:

TKT_OWNR.BO_VW_TKT_FLIGHT_COUPON.DEPARTURE_DATE BETWEEN sysdate AND sysdate +2


will be grateful to any assistance
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14227
Location: England


flag
PostPosted: Sun Jun 09, 2019 2:28 am 
Post subject: Re: Configure report header as per query script

Leverage the CurrentDate() and RelativeDate() functions.
Back to top
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11386
Location: Manchester, UK


flag
PostPosted: Mon Jun 10, 2019 5:45 am 
Post subject: Re: Configure report header as per query script

sysdate in Oracle is =CurrentDate() in Webi formula
sysdate +2 in Oracle is =RelativeDate(CurrentDate();2) in Webi formula

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0272 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo