Adding ranges from unbound parameters to a query
SSRS reports support using parameters that are not part of a dataset. This recipe will attempt to use the unbound parameters
FromDate
and ToDate
added to the report to set the ranges in the report query. These parameters are added to the report and are not connected to any dataset. The values in these controls will be received and set in the report query.
How to do it...
The first step is to create a contract and UI builder class and bind them together (assuming you have created the parameters as discussed in the first recipe Opening a report through a controller).
Add a
UIBuilder
class that extendsSRSReportDatacontractUIBuilder
as follows:public class PktRdlItemTransListUIBuilder extends SrsReportDataContractUIBuilder { }
Add a contract class that extends
SRSReportRdlDataContract
as shown in the following snippet:[ SrsReportNameAttribute(ssrsReportStr(PktRdlItemTransList, ItemTransList)), SysOperationContractProcessingAttribute(classstr...