Database Reference
In-Depth Information
Figure 15-15. Accept the warning to make the change
This will not save your query changes in the .odc file, but it will allow you to change it for the moment.
if you want to make a more permanent change, navigate to a new worksheet and start the Connection wizard again.
You can also save your changes by clicking the Export Connection file button, as shown in figure 15-14 , if you
think you will want to reuse this connection and statement for a later report.
Note
Next is to design the report. Any fields that were common between the two views may still be in the pivot
table report, and they can easily be removed by dragging and dropping them back from the report and into the
field list. But, afterward, creating a new report is just as simple as creating the first. By dragging and dropping
the fields from the field list into the Pivot Table Report area or using the designer areas below the field list, you
can create a report that looks something like the one shown in Figure 15-16 , which now has the additional data
warehouse columns, such as TitleName, TitleType, and YearName.
Figure 15-16. A PivotTable report that uses the vAllTables view
 
 
Search WWH ::




Custom Search