SSRS Report Design Master report instances

SSRS Report Design Master Report Instance

Environment Description: vs2010 sql2012

Reporting requirements: 1. Obtain all information from the main order form (order_main) According to the contract number (contractno) .  

(the actual project cannot be this way, here is just an example)

2. But the contract number must be passed to the subreport as a parameter from the main report

For information on how to configure data sources and datasets, see

Http://wenku.baidu.com/view/1175f781856a561252d36fbf.html or

http://8071125.blog.51cto.com/8061125/1636666

This is not a detailed introduction

First, New main report

Right-click report--> Add - New Item

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/C0/wKioL1U2RQGyZ7ccAADjEPkviAg959.jpg "title=" Image002.jpg "alt=" Wkiol1u2rqgyz7ccaadjepkviag959.jpg "/>

on the left. configuration parameter Contractno in report Data

note in the figure Prompt is the way the field appears before the text box in the interface

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/C0/wKioL1U2RQ2QAYm_AADMz7Fg19I418.jpg "title=" Image004.jpg "alt=" Wkiol1u2rq2qaym_aadmz7fg19i418.jpg "/>

Second, New Subreport

the new subreport, named " report_ordermainsub1.rdl "

and then in ReportData Add the data source as in the previous article, or select the data source from the existing one.

Right-click Datasets-->adddataset (Note where You can also not write add parameters later)

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/C4/wKiom1U2Q77TfDWuAAEFhIB_NjM110.jpg "title=" Image006.jpg "alt=" Wkiom1u2q77tfdwuaaefhib_njm110.jpg "/>

Use the tool to drag a Table in the subreport, and then from the Report Data to drag into the required fields

Third, The main report inserts a subreport

transfer the main report to Design mode, right-click Insert--->subreport

Adjust the control to the size you want

Right-click subreport-->subreportproperties , select the sub-report that we just

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6B/C0/wKioL1U2RSfQEmiOAAC6AsRraIs168.jpg "title=" Image008.jpg "alt=" Wkiol1u2rsfqemioaac6asrrais168.jpg "/>

To pass a main report parameter to a subreport

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6B/C0/wKioL1U2RTPAB3cnAAC1cwelJMI733.jpg "title=" Image010.jpg "alt=" Wkiol1u2rtpab3cnaac1cweljmi733.jpg "/>

Insert success If there is no error, the name of the subreport you inserted is displayed in the control

Four, preview as

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6B/C0/wKioL1U2RUCBOMTUAADDDnJoO78099.jpg "title=" Image012.jpg "alt=" Wkiol1u2rucbomtuaadddnjoo78099.jpg "/>

This article is from the "8061125" blog, please be sure to keep this source http://8071125.blog.51cto.com/8061125/1636668

SSRS Report Design Master report instances