I am working with a WebI report (XI r3) where I have created Input Controls to filter the Report based on a Unique Number, a Starting Date and Ending Date. The Input Controls are working as expected ~ No issue there. I want to use the Report Filter Function to Display what the User has chosen from the Input Controls within the Report Headers and Summary Boxes. The Report Filter only works if the Report Objects are hard coded (by dragging the object to the Filter Pane) OR it also works with Drill Drop Downs. The purpose of the report is allow the user to select from multiple unique numbers and date ranges (hence the reason for using Input Controls). This information needs to display correctly in the report header info and does not. Any solutions offered is appreciated. Thanks!
Have you checked what parts of the report the Input Control is filtering on?
If you’re trying to present the information in the header, you may have to use the ReportFilterSummary function and do a bit of text parsing with Pos and Substring because input controls don’t affect headers. So long as you’re using input controls that select only one value this should work fine.
Yes, already did try text parsing, but again, the Report Filter function does not even recognize the Input Control variables. Because it will be completely within the users control which Report Number and Date Ranges are selected, it has to be dynamic and ‘move’ as the user moves. Thanks for the reply and suggestion!
Here is the scenario to clarify the issue: The user at Report Run Time will be presented with a prompt that pulls data by Client ID. The user already knows what Client ID to enter at the Query Prompt and may enter as little as one to as many clients as they need to analyze ~ lets say for this example 3 Client IDs.
Inside the report, the user will select from the Input Controls for the following 3 Filters Choices: Client ID, Start Date, and End Date. Once selected the report filters the records accordingly. No problem yet. Now in the Header I want to show the following Verbiage: "PostMark Date Analysis by Day Date for Client ID: " + ReportFilter([Client ID]). This produces a #Multivalue error. If I go with something like ReportFilter(First([Client ID])), this only provides the First Client ID (out of the group), but does not change as the user changes the Input Control to the Next Client ID.
I did try using the ReportFilterSummary Function and it produced a #COMPUTATION error. If you have code you think I could convert and use, I would be very glad to try it out.
You want this to go as a report header. Do you want it in the report header or at the top of the report body because the formula will be different. Also, what are Postmark Date and Day Date?
Correct. Top of the report and separate from the report / table body headers. PostMark Date and Day Date are simply part of the Report Title and are not part of the equation for obtaining the Client ID. Basically the report body is designed to show Client Activity by Date between a Date Range. The user will select the date range they want from the Input Controls for Start and End Dates. Ideally, the code would actually a variable object I could add to the end of a Report Title, but not sure if it could work like that.
I was able to partially parse out the Info I needed using the ReportFilterSummary Function (figured out what I did wrong earlier) using the following code, BUT… when used in conjunction with the report title, it doesn’t work as a variable. This code works when in a separate cell inside the report: =Trim(Substr(ReportFilterSummary(“PM Analysis”);Pos(ReportFilterSummary(“PM Analysis”);"{")+2;7))
(BOB member since 2008-10-22)