on 05-12-2018 12:07 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.