Using BO XI R2 SP3.6 - WebIntelligence Reports delivery to users, though willing to author in Deski if it can be converted for web delivery:
Data is for requests sent by particular offices, and reporting is by time, office and status of request.
I need to dynamically suppress rows and columns based on user parameters collected in a web application, then call the report object, pass the parameters to run the report.
The user might select output parameters that require reporting by day, month, week or year, and if by month, display of the month in report header is necessary. Additionally, the user may select offices of interest, or all requests. The request status may be specified, or totals of current requests may be displayed, totalled into columns by status:
(status)
V
Week Office Submitted Received
3/2-9/09 Wash, DC 12 18
3/2-9/09 San Antonio 4 2
Or
Week Submitted Received
3/2-9/09 16 20 (Office column suppressed)
Or
User selects three offices, but one has no data
Week Office Submitted Received
3/2-9/09 Wash, DC 12 18
3/2-9/09 San Antonio 4 2
(Austin TX not shown though selected)
Finally, Office selected, date given, Submitted and Received selected, but there are not items with 'Received' status for that date, only Submitted so 'Received' status column is suppressed:
Day Office Submitted
3/2/09 Chicago 4 ('Received' status suppressed due to lack of data)
If none were submitted OR the submitted tick box on the sending interface is not checked, the 'Submitted' column will be suppressed - same for 'Received.'
If an office in a group of offices selected has no items to print, its row is suppressed.
If the user does not want offices at all, then the office column is to be suppressed.
Is this possible? I suspect the row suppression will not be difficult, but the column part is what is making this difficult. The requirements call for only one report object.
Thank you.
Edited by: Yasar Kuyuk on Mar 5, 2009 11:53 PM