The next step for the developer is to create the layout of the report itself. Clicking
on the Layout tab opens the empty report in the designer, allowing the developer
the freedom to place controls on the report as necessary. Unlike the earlier report
that used the matrix control, this particular report will use a table??”perhaps the most
Figure 10-15 The query designer after graphically creating the query. Changes can be
made in the diagram at the top or by changing the text at the bottom.
C h a p t e r 1 0 : S Q L S e r v e r R e p o r t i n g S e r v i c e s 339
common way to show data in Reporting Services. This table automatically repeats
all of the rows in a dataset and is often used in cases where businesses need a simple
way to view the data. It??™s also very useful for allowing users to export the data to
Excel for further analysis.
By default the table comes with just three columns, but right-clicking on any
column selector allows developers to insert extra columns or delete the existing
column, among other functions. In this particular example, the developer simply adds
columns to the table and places all the fields in the table by dragging each field and
then placing it in a detail cell in each column. The developer started by turning on the
grid line, which was done by setting the BorderStyle property to Solid for all of the
cells. Next, the developer applied some basic formatting by resizing columns, setting
a background color to the header, and changing some of the text in header cells.
Pages:
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430