Embedded Files
This are the steps for creating report in SQL Server:
Create a report server project. after you open the Business Intelligence Development Studio, On the File menu, press on New, and then click Project. In the Project Types list, click Business Intelligence Projects. In the Templates list, click Report Server Project. In Name, type MyProject or any other name you want. finish the first procces by click OK.
Create a new report definition file. In Solution Explorer, under MyProject server project, right-click on the directory Reports, choose Add, and click New Item. In the Add New Item dialog box, under Templates, press on Report. In Name, type MyReport.rdl and then click Add. Report Designer opens and displays the new .rdl file in Design view. the design view contain two views.the first one is the Design view, which Responsible for design the layout and when it's active the Report Data pane, where you define your data, is also active. the second view is the Preview view, where you can test the report you've just created.
Define a data source. The data source is a set of connection information the report uses to access data from either a relational database, multidimensional database, or other resource. To set up a connection, click New In the Report Data pane, and then click Data Source. In Name, type the name of the Data Base you would like to connect. Make sure Embedded connection is selected and choose the type of the data source to be set, for example Microsoft SQL Server. then use the Edit button to create the connection properties. Click OK. A new data source is added to the Report Data pane.
Defining a Dataset. data that you use in reports is contained in a dataset. A dataset includes a pointer to a data source and a query to be used by the report, as well as calculated fields and variables. To define a Transact-SQL query for report data click New in the Report Data pane, and choose Dataset. The Dataset Properties dialog box opens.In the Name box, type yourDataSetName. Click the Use a dataset embedded in my report radio button. Make sure the name of your data source, is in the Data source text box, and that the Query type is Text, in case you want to write the query in the dataset properties window, or Table , in case you Prefer to enter the name of the table that you want to use as a dataset or choose the Stored Procedure option in order to use a query has already been prepared. If you use the text option, you can be helped with the Query Designer button to create Graphically, your query. finally, define the Time out (in seconds). The default is 30 seconds- if it's 0. If it is empty, the query does not time out.
Defining the report layout. You create a report layout by dragging and dropping data regions, text boxes, images, and other items that you want to include in your report to the design surface, like in the following picture.
To add a Table data region and fields to a report layout you should click Table in the Toolbox and then click on the design surface. Drag the first field you like to the first column in the table. As you can see, the field was added to the header and to the data known as the field expression in brackets. Continue to add fields by the same way. To preview a report, Click the Preview tab. Report Designer runs the report and displays it in Preview view.Formatting a Report. After you've created a report, you can format the date and currency fields and the column headers. Click the Design tab. Right-click the cell with the [Date] field expression and then click Text Box Properties. Click Number, and then in the Category field
Formatting Date fileds. Select Date. In the Type box, select the suitable format.
Formatting Currency. Select Currency. Select Use 1000 separator (,) and choose the Compatible symbol
finally click OK.
To format header rows and table columns,Select the row containing column header labels and from the Format menu choose the wanted design.
Adding Grouping and Totals.
To group data in a report. From the Report Data pane, drag the requiered fields to be grouped to the Row Groups pane. Place it above the row called Details. Note that the row handle now has a brackets in it same as the number of grouping fields. Delete the original columns (by selecting the columns, right click and click Delete Columns) so that only the groups values will be displayed. In order to check the changes, switch to the Preview tab to preview the report. To add totals to a report
To add totals to report. Right-click the data region cell that contains the field to be calculated as total, and click Add Total. This adds a sum of the quantity for each collection of rows within the data group that this field belongs, to the totals row. When you Add Total to a grouping fields you can choose to add total before or after the grouping data and by this action you can define different levels of totals.
Adding Parameters to a Report. http://msdn.microsoft.com/en-us/library/aa337401.aspx
Page updated
Google Sites
Report abuse