1) Report Server receives a request, generally in Hypertext Transport Protocol for given report.
2) Report server validates the properties associated with the object request.
3) Report Server accesses the Sql Server catalog database
4) From the definition, Report server extracts the information related to data source.
5) Reporting Service connects to the data sources and execute the commands that retrieve the data.
6) After the data has been retrieved, the data is mixed with RDL definition and generates an intermediate format report.
7) The intermediate format report is rendered in the format that was requested by the client; that includes HTML, Excel, PDF, and so on.
This process implies the following:
1) Every time report is requested, the underlying queries each of the different datasets with in the report must be executed.
2) For every single request, the intermediate format is created.
3) Query parameters are enabled in this report, dictating the no of rows returned by the data provider and rendered in this report.
No comments :
Post a Comment