Adhoc Reporting Using SSRS 2008 R2
10. To add
Report Model, right-click on the Report Models->Add New Report Model
Next , we will use the default rules for the model generation but you
can always select the required rules for model. To understand the rules in more
detail click help.
first option is recommended for the report model generation rather than
using the current statistics of the model. Click Next.
Run to generate the model.
the model is generated click Finish to complete the wizard.
16. Now to deploy the model to the ReportServer. Right-click on the Adhoc Reporting
solution and go to properties to set the ReportServer properties.
Click on the Solution and Click Deploy.
Internet explorer and type http://localhost/Reports to open the report manager.
Report Manager is the Web Application provided by Microsoft to manage the
deployed reports. You can see the Models and Data Sources
deployed on the report server. Click on the on the Report Builder link
to start the Report Builder.
Building An Adhoc Report
Report Builder will be downloaded on your machine after clicking run.
Report Builder 3.0 will open once it has downloaded. As you can see Report Builder 3.0 gives you four options to begin
report building. There is a table or matrix wizard, chart wizard, map
wizard and finally a blank report. Click on the blank report for this run-through.