Multiple user inputs report [message #645157] |
Sat, 28 November 2015 00:23  |
snsiddiqui
Messages: 168 Registered: December 2008
|
Senior Member |
|
|
Dear All,
I want to create a report with department, employee and month parameters but I want to give option to user to select any single department or all departments or select more than one department.
Kindly advise me, how?
|
|
|
Re: Multiple user inputs report [message #645187 is a reply to message #645157] |
Sat, 28 November 2015 05:16  |
 |
Littlefoot
Messages: 21759 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Reports' Parameter Form can't do that, so you'll have to develop your own solution.
If you, for example, call that report from Forms, you could create a data block based on the "departments" table and let users mark (with a checkbox) departments they are interested in. Report would then look at that table and display only values that are checked.
Or, if you call the report from an Apex application, a shuttle item might be a good idea. Its output is a colon-delimited string (so you'd have to parse it in report in order to display desired values).
|
|
|