Database Reference
In-Depth Information
16. Click OK to close the Query Designer dialog window.
17. You will see the MDX code that was created when the Query Designer window
closes. Click Next to continue to the next page of the Report wizard.
18. The next page of the wizard, shown in Figure
2-65
, allows you to select between
two report formats. in this case, you use the Tabular format. So, verify that tabular is
selected, and click Next.
19. The next page allows you to group report data together. Click the Event field in the
Available Fields window pane on the left side of this dialog window. Then click the
group button to add the event field to the group window pane (Figure
2-65
).
20. Click the date field and then click the Details button to add this field to the Details
window pane. Continue adding MinTempF and the MaxTempF fields by selecting
each and clicking the Details button so that all three fields are seen in the Details
window pane (Figure
2-65
). Click Next to continue.
21. On this page, verify that the Stepped radio button is selected, and check the Enable
drilldown checkbox. This allows the report user to expand and contract the report
items much like the treeview in Solution Explorer. Click Next to continue
(Figure
2-65
).
22. On this page, you can choose between different table styles. These styles only affect the
visual look of the report and not its functionality. Because the look is not that important at
this time, choose one that you like and click Next to continue (Figure
2-66
).
Important:
if this is the first time a report has been created in a visual Studio solution, the wizard will
move to the Choose Deployment Location page. You can accept any default values and click Next to move
to the last screen of the wizard. (if you have not set up your Report Server, Chapter 16 walks you through
the process. until then, you will not be able actually to deploy the report, but that is not necessary in this
chapter.)
23. On this last page of the wizard, supply a name for your report and review the
choices you have made. Change the name to
WeatherEventsReport
, and click finish
to create the SSRS report file (Figure
2-66
).
24. when the Report wizard completes, you should see the
WeatherEventReport.rdl
file in Solution Explorer. You will also see the report in a report designer window
(Figure
2-67
).
25. Click the Preview tab to preview the report that you have made with the SSRS
Report wizard. Your report should look similar to Figure
2-68
.
At this point, the report has been created, but it may not look perfect. You can adjust the report by navigating
between the design and preview windows, changing the color scheme, column widths, and value formats
until you are satisfied with the look and feel of your report. This is covered more extensively in Chapters 16
and 17, so for now we leave the report looking as it is.
in this exercise, you created a report against the SSAS cube you created in Exercise 2-4. in future chapters,
we show you how to create more complex reports using Microsoft's Reporting Server and Excel.
