adding vb and visual C# to Visual Studio 2005 in reporting service

Hi,
Presently visual studio 2005 in SQL server 2005 reporting services has
business intelligence project templates.
I would like to know as to how to add Visual basic and Visual C# project
templates to Visual Studio 2005.
I am new to SQL Server 2005 reporting services.
I would highly appreciate this information.
Thanks for your help.
--
SamKYou have to install those projects. However, after doing this you might have
to re-install report designer. The reason is that SQL Server 2005 comes with
a version of visual studio that it installs if no VS is present. If VS is
present it integrates with it. I have found that if you install VS (for
instance installing VB.Net which installs a full version of Visual Studio)
that you need to re-install the report designer so it integrates with it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SamK" <SamK@.discussions.microsoft.com> wrote in message
news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> Hi,
> Presently visual studio 2005 in SQL server 2005 reporting services has
> business intelligence project templates.
> I would like to know as to how to add Visual basic and Visual C# project
> templates to Visual Studio 2005.
> I am new to SQL Server 2005 reporting services.
> I would highly appreciate this information.
> Thanks for your help.
> --
> SamK|||Bruce,
Thanks for your helpful suggestion. This is what I will do.
1) uninstall the Visual Studio 2005 that got installed along with SQL server
2005 reporting services
2) install the full version of Visual Studio 2005.
3) Reinstall the reporting services.
Is this correct?
Best Regards,
SamK
"Bruce L-C [MVP]" wrote:
> You have to install those projects. However, after doing this you might have
> to re-install report designer. The reason is that SQL Server 2005 comes with
> a version of visual studio that it installs if no VS is present. If VS is
> present it integrates with it. I have found that if you install VS (for
> instance installing VB.Net which installs a full version of Visual Studio)
> that you need to re-install the report designer so it integrates with it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> > Hi,
> >
> > Presently visual studio 2005 in SQL server 2005 reporting services has
> > business intelligence project templates.
> > I would like to know as to how to add Visual basic and Visual C# project
> > templates to Visual Studio 2005.
> >
> > I am new to SQL Server 2005 reporting services.
> >
> > I would highly appreciate this information.
> > Thanks for your help.
> > --
> > SamK
>
>|||Yes. That will do what you want.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SamK" <SamK@.discussions.microsoft.com> wrote in message
news:9BEB930B-CE75-4281-9C0B-A171CCD4D035@.microsoft.com...
> Bruce,
> Thanks for your helpful suggestion. This is what I will do.
> 1) uninstall the Visual Studio 2005 that got installed along with SQL
> server
> 2005 reporting services
> 2) install the full version of Visual Studio 2005.
> 3) Reinstall the reporting services.
> Is this correct?
> Best Regards,
> SamK
>
> "Bruce L-C [MVP]" wrote:
>> You have to install those projects. However, after doing this you might
>> have
>> to re-install report designer. The reason is that SQL Server 2005 comes
>> with
>> a version of visual studio that it installs if no VS is present. If VS is
>> present it integrates with it. I have found that if you install VS (for
>> instance installing VB.Net which installs a full version of Visual
>> Studio)
>> that you need to re-install the report designer so it integrates with it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "SamK" <SamK@.discussions.microsoft.com> wrote in message
>> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
>> > Hi,
>> >
>> > Presently visual studio 2005 in SQL server 2005 reporting services has
>> > business intelligence project templates.
>> > I would like to know as to how to add Visual basic and Visual C#
>> > project
>> > templates to Visual Studio 2005.
>> >
>> > I am new to SQL Server 2005 reporting services.
>> >
>> > I would highly appreciate this information.
>> > Thanks for your help.
>> > --
>> > SamK
>>|||Bruce,
After doing all this two more problems have come up.
1) For web service identity ASPNET is not assigned. the text box is
disabled and it is blank.
2) when I try to open the report manager (http://computername/reports the
application errors out with this message. I would request your help.
Server Error in '/Reports' Application.
----
Could not load file or assembly 'CppCodeProvider, Version=8.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.
The module was expected to contain an assembly manifest.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.BadImageFormatException: Could not load file or
assembly 'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The module was
expected to contain an assembly manifest.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine
why the assembly 'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' could not be loaded.
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value
[HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind
failure logging.
To turn this feature off, remove the registry value
[HKLM\Software\Microsoft\Fusion!EnableLog].
Stack Trace:
[BadImageFormatException: Could not load file or assembly 'CppCodeProvider,
Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of
its dependencies. The module was expected to contain an assembly manifest.]
System.RuntimeTypeHandle._GetTypeByName(String name, Boolean
throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark&
stackMark, Boolean loadTypeFromPartialName) +0
System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError,
Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +72
System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError,
Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) +58
System.Type.GetType(String typeName) +48
System.CodeDom.Compiler.CompilerInfo.get_IsCodeDomProviderTypeValid() +9
System.Web.Compilation.CompilationUtil.GetRecompilationHash(CompilationSection ps) +1800
System.Web.Configuration.CompilationSection.get_RecompilationHash() +68
System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate2(StandardDiskBuildResultCache diskCache) +741
System.Web.Compilation.BuildManager.CheckTopLevelFilesUpToDate(StandardDiskBuildResultCache diskCache) +46
System.Web.Compilation.BuildManager.RegularAppRuntimeModeInitialize() +419
System.Web.Compilation.BuildManager.Initialize() +235
System.Web.Compilation.BuildManager.InitializeBuildManager() +228
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags)
+310
[HttpException (0x80004005): Could not load file or assembly
'CppCodeProvider, Version=8.0.0.0, Culture=neutral,
PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The module was
expected to contain an assembly manifest.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3435007
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +252
----
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.210
--
SamK
"Bruce L-C [MVP]" wrote:
> Yes. That will do what you want.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> news:9BEB930B-CE75-4281-9C0B-A171CCD4D035@.microsoft.com...
> > Bruce,
> >
> > Thanks for your helpful suggestion. This is what I will do.
> > 1) uninstall the Visual Studio 2005 that got installed along with SQL
> > server
> > 2005 reporting services
> > 2) install the full version of Visual Studio 2005.
> > 3) Reinstall the reporting services.
> >
> > Is this correct?
> >
> > Best Regards,
> > SamK
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You have to install those projects. However, after doing this you might
> >> have
> >> to re-install report designer. The reason is that SQL Server 2005 comes
> >> with
> >> a version of visual studio that it installs if no VS is present. If VS is
> >> present it integrates with it. I have found that if you install VS (for
> >> instance installing VB.Net which installs a full version of Visual
> >> Studio)
> >> that you need to re-install the report designer so it integrates with it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "SamK" <SamK@.discussions.microsoft.com> wrote in message
> >> news:07A0FD1E-9C4A-4FCD-BF5E-65CF12A62AE6@.microsoft.com...
> >> > Hi,
> >> >
> >> > Presently visual studio 2005 in SQL server 2005 reporting services has
> >> > business intelligence project templates.
> >> > I would like to know as to how to add Visual basic and Visual C#
> >> > project
> >> > templates to Visual Studio 2005.
> >> >
> >> > I am new to SQL Server 2005 reporting services.
> >> >
> >> > I would highly appreciate this information.
> >> > Thanks for your help.
> >> > --
> >> > SamK
> >>
> >>
> >>
>
>

Adding many templates at once

I can’t find out how to put SQL 2000 templates that I’ve already created into SQL 2005, en masse. I don’t want to put them in one at a time. I’ve got 40 or 50 of them.

Can you please direct me to the location I can paste them in and have them show up.

I’ve tried this location, where the ones built-in exist:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbenchprojectitems\Sql

When I put my own folder in there with my custom templates, they don’t show up and there is no REFRESH button on the Template View.

When I saw that existing ones had the .sql extension, I renamed them from .tql to .sql, but that did not make any difference.

Thanks for any help.

I found that when I closed SSMS and then opened it, all my templates appeared as expected.

I suggest adding a refresh button to the templates.

Adding BI Templates to Visual Studio 2005 - 2008

After installing SQL Server (both 2005 and 2008) sometimes the BI Templates are missing from the new project dialog. Is there a way to find those templates and add them after a SQL Server install? I have searched the web and Microsoft MSDN, but found no information. Thank you if you can help me.

Hi,

From your description, do you mean the Business Intelligence project template disappear in the create project dialogue?

Based on my understanding, you can try to open "SQL Server Business Intelligence Development Studio" from SQLServer 2005 menu group instead of starting Visual Studio designer. If you still can't find the business intelligence project template. Please make sure that if you have choose the "SQLServer Reporting Service" to be installed while you installing the SQLServer2005.

Thanks.

|||

No, the problem is that they do not appear in VS/BIDS even if SSRS is installed. The templates must be available on the web somewhere and the correct folder location and configuration to add them to the VS/BIDS interface must exist somewhere.