948
Hi All,
I want to create a dropdown that would populate the job numbers for a user who have filled their timesheet in a specified time frame .
This I want to do in a request page of a report. Any idea how this could be achieved?
Gotcha. Perhaps the report needs to be based on a temporary table of the jobs table. OnInitReport trigger you then populate the table based on looping through timesheets for a chosen period of time with job numbers. You’ll need to do a IF GET with each loop to skip repeated jobs
Hi ,
Thank you for the reply. Actually there are many jobs in our organisation.Hence for the ease of the user if the dropdown populates only those that is relevant to him would make it easier for him to choose the job number which in turn would generate a excel template based report.
Regards,
Indira
So once the dates are filled in you want a procedure to determine what jobs have had timesheets posted to for that user? Procedure to return a filter string? Does it make sense to have it on the request page? If they want to override maybe have that as an option instead and then let the report otherwise calculate the filter when the user doesn’t override.
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
