How to Deploy the Extension
  1. Build the solution1
  2. Copy TOJO.ReportServerExtension.dll assembly to SSDT-BI's PrivateAssembly folder. Typically to: C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies
  3. Add RSReportDesigner.snippet.xml2 to RSReportDesigner.config file on SSDT-BI's PrivateAssembly folder. Configure <SpecificationFolder /> inner text to wherever you want to put your specification files
  4. Add RSPreviewPolicy.snippet.xml2 to RSPreviewPolicy.config file on SSDT-BI's PrivateAssembly folder. Modify the path of assembly configured on Url attribute of <IMembershipCondition /> element if needed
  5. Restart SSDT-BI if currently opened
1 The solution published on CodePlex is created using Visual Studio 2013, however the project itself is developed on all Visual Studio 2010 Professional Edition, Visual Studio 2012 Express for Windows Desktop, and Visual Studio 2013 Ultimate Edition
2 The content of the snippet illustrates the hierarchy of the element. You only need to copy-paste <CodeGroup /> element for RSPreviewPolicy.config, and <Extension /> element for RSReportDesigner.config


How to Specify DMF
  1. Create a new file with .dmf extension (e.g. DataSet1.dmf) on the specification folder (configured on RSReportDesigner.config earlier)
  2. Specify the format of the data that you intend to acquire based on DataModelFormat.xsd schema. Optionally, you could copy and paste <Fields /> element of any existing dataset on your .rdl file (schema version 2010, i.e. SQL Server 2008 R2 or above) and add the following attribute to root <Fields /> element of your specification: xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"

How to Consume the Data on SSRS Report
  1. Create a new report file
  2. Create a new datasource, set the type to "TOJO Data Source". Connection string and credentials are not required
  3. Create a new dataset, set the data source to the one you previously created
  4. Currently, this extension only supports query with the type of "Text". Therefore, set query type to: "Text"
  5. Set "--Name: {your DMF file name without .dmf extension}" as the query3. Using the example name of DMF file earlier, the query would be something like: "--Name: DataSet1" (without the surrounding quotes)
  6. Click "Refresh Fields" button
  7. If everything goes well, the specified field/column will be auto-generated on the fields tab of dataset properties
  8. Design and preview the behaviour of your report layout
3You can specify SQL query as you would on any dataset using SQL Server data source. This extension reads the first line prefixed with "--Name: " as its query. Any other queries are ignored. You can prepend the DMF query to your existing query (SQL Server will treat it as comment). Don't forget to change the datasource type to SQL Server before publishing the report

Last edited Dec 14, 2013 at 5:14 AM by fandi, version 4