Skip to Content

Custom Input variable in webi report

Hi All,

I have a requirement as similar to below.

In webi report console, user will select the input date.

I want to display report for how many students have joined in a college in that particular date. show the results at 1hour frequency. say suppose,

i select 10th May. result should be x members at 9am, y members at 10am till 4pm for the selected date.

here i cannot use =,!=,<=,>=,<,>,<> conditions in query panel as the exact matching timing may not be available in database. so take a input from user then check in database for the display.

any idea to achieve this would be much appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 16 at 08:25 PM

    Hi,

    Create a prompt on Year and Month for the user to select.

    Use FormatDate([Date];"dd/MM/yyyy hh:mm:ss") to show date and time if your Date field doesn't bring Time.

    When the user selects Year and Month in the prompt, report will display only that particular Month and your Date time field will show Enrollment Date and Time in the report.

    Post sample data or mock up.

    Thanks

    Jothi

    Add comment
    10|10000 characters needed characters exceeded