Method Not Supported Error When Trying To Create New Report Model
I'm trying to create a few report models in Visual Studio to demonstrate the Report Builder tool and I'm encountering an issue when I try to generate a Report Model. I get the error message "Specified Method Is Not Supported" when I click Finish on the Report Model wizard. The error detail is: =================================== Specified method is not supported. (Microsoft Visual Studio) ------------------------------Program Location: at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.CreateSqlDsvStatisticsProvider(IDbConnection connection) at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.BuildModel() Steps to reproduce: 1. Create a new Report Model project in Visual Studio 2005 against SQL Server 2005 2. Create a new data source. The data source was tested and works correctly 3. Create a new data source view. The data source view was also tested (clicked on Explore Data) and I was able to look at the data in the view 4. Right-click on Report Models and select "Add New Report Model" 5. Click next at the welcome screen 6. Select the data source view created in #3 7. Leave the selected options for report model generation rules for creating the data source view (Create Entities for all Tables, Create Count Aggregates, Create Attributes, Create Attributes for auto-increment columns, Create date variations, Create numeric aggregates, Create date aggregates, Create roles were all selected) 8. Click next 9. Select Update Model Statistics Before Generating (default option) 10. Click next 11. Click Run Once I click runit processes for approx 3 seconds and then returns the error above. If anyone could help me I'd appreciate it. Microsoft hasn't published any details on the namespace and I'm not sure why I'd be getting the error I am. Thanks in advane, Maurice
January 21st, 2008 6:07pm

hi Maurice, I am having the EXACT same problem while trying to create a Report Model. Have you ever figured out what the problem was? Thanks, -Ruth Specified method is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.CreateSqlDsvStatisticsProvider(IDbConnection connection) at Microsoft.ReportingServices.ModelDesigner.Wizards.ChooseSemanticModelName.BuildModel()
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2008 3:02am

This could happen if you had mismatched model designer and semantic query DLLs installed. Specifically you could check that the version numbers on the following two DLLs match: in C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies Microsoft.ReportingServices.ModelDesigner.dll Microsoft.ReportingServices.SemanticQueryEngine.dll If they don't match you should repair your installation and/or reapply SP2.
July 31st, 2008 8:56pm

I had the same problem. I checked the DLL's and the version numbers were the same. I fixedthe problemby changing the client used for the data source. I changed it from the SQL Native Client OLE DBto the .NET SQL Client Data Provider and I got rid of the error and was able to build the report model. HTH.
Free Windows Admin Tool Kit Click here and download it now
January 28th, 2009 9:21pm

Interesting. Yes, I can see how that could cause this. Report models only support the .NET providers for SQL Server, Oracle, and Teradata.
January 30th, 2009 8:18am

I just ran into the same problem, and followed your suggestion and it worked. Thanks.RS Newbie
Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2011 5:42pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics