Skip to Content
avatar image
Former Member

need a date prompt

Hi All,

I need to enter cut off date as prompt but this cut off date field is not existing in database. based on this cut off date we have some calculation in report.

-- How to create a date field with calender. which don't have any values in database (this field is not there in database) .

Thanks all

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • May 26, 2015 at 05:17 AM

    Follow the steps:

    1. Create a new query in the web-I report. Choose ANY object that is of the type date in result object and add the same object in the filter panel. (do not worry even if the required dates are not there in your table. this is just a placeholder.) - Figure 1
    2. Create a variable to read the user response and store it for further use. Figure 2
    3. Now you can use this cutoff date anywhere you want in the report
      1. The important point here is that since you are using the user response, it is no longer connect to any queries/data sources and so you can use if freely as a global variable across your report. (Figure 3)

    To suppress "No data to retrieve in query" warning, you can play around with selecting a dummy value.


    1.jpg (131.9 kB)
    2.jpg (43.8 kB)
    3.jpg (145.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2015 at 11:09 AM

    Hi Neeraj,

    you can refer the following link:

    Webi Tricks: Displaying table data in Calendar format

    Thanks

    Megha

    Add comment
    10|10000 characters needed characters exceeded