News Headlines

Monday, February 23, 2009

Creating Tabular Report


Creating Simple Tabular Report


Data View




  1. Select <New Dataset>… from dropdown

  2. Name Dataset and either choose an existing shared Data source or create a new one

  3. Select Command type and click Ok

  4. Enter query into query designer and test by clicking on ! Icon


Tip: You can use toolbar btn to switch between graphical and generic query designer




Layout View


  1. Drag Table control from toolbox onto report body

  2. Drag and drop fields from Field list to cells in Detail row of table; SSRS will
    automatically add field name to table header row

  3. Select Report|Page Header or Report|Page Footer to display these sections

  4. Drop textboxes onto the header/footer if desired


Previewing reports


  1. Click on Preview tab to preview the report

No comments: