ligershark / sidewafflev2

Other
30 stars 11 forks source link

How to create template for SSRS Reporting Project #26

Open kdlarson opened 6 years ago

kdlarson commented 6 years ago

I'm able to generate a template from a Reporting Services Project, but I get the following error when it runs: "Value cannot be null. Parameter name: typeName"

I am specifying a ProjectType of "Database" in the template.vstemplate file. This places the template under the "SQL Server" section of the New dialog. I could not find the right ProjectType value to place it under the correct location of "Business Intelligence\Reporting Services".

Thanks for any help with either of these issues.

sayedihashimi commented 6 years ago

@kdlarson can you share a sample?

kdlarson commented 6 years ago

Sample Reporting Project.zip

The attached sample project shows the error. You will need the (SSRS) Microsoft Reporting Services Projects extension installed in order to use SSRS projects in VS.

In the template.vstemplate file, I had to specify "Database" as the ProjectType. I did this because I couldn't find the correct project type for Reporting Services projects anywhere (searched for hours and did a lot of trial and error, to no avail). So that's likely part of the problem. I'll be anxious to hear if you are able to identify the correct value for Reporting Services project type.

Thanks for looking at this.