Sunday, February 12, 2012

Business Intelligence option disappeared from Visual Studio

I am in the process of evaluating Reporting Services for my company. I
succesfully installed Reporting Services and began developing a simple
report. After closing Visual Studio to attend to another matter, I later
re-opened Visual Studio and was unable to edit my existing report project.
The error I received was "The selected file is not a valid Visual Studio
Solution file". Further, when I tried to create a new project, Business
Intelligence is no longer listed in the project types dialog. I have tried
uninstalling and reinstalling both Visual Studio and Reporting Services and I
still have the same problem. Can anyone suggest a solution? Thank you.Similar problem for me. I installed RS client side and also have no
visibility to BI in VS .NET 2003. A couple of differences though:
1) I -never- had visibility
2) I can open the sample solution file (with the AdventureWorks reports),
and can even deploy it the server. But trying to add new BI items (or create
a BI project to begin with) are impossible.
Can anyone help us?
"Dan Friauf" wrote:
> I am in the process of evaluating Reporting Services for my company. I
> succesfully installed Reporting Services and began developing a simple
> report. After closing Visual Studio to attend to another matter, I later
> re-opened Visual Studio and was unable to edit my existing report project.
> The error I received was "The selected file is not a valid Visual Studio
> Solution file". Further, when I tried to create a new project, Business
> Intelligence is no longer listed in the project types dialog. I have tried
> uninstalling and reinstalling both Visual Studio and Reporting Services and I
> still have the same problem. Can anyone suggest a solution? Thank you.|||Can you check that the folder %ProgramFiles%\Microsoft SQL
Server\80\Tools\Report Designer\Business Intelligence Projects exists? It
should contain 3 files. Next, check for the registry key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\NewProjectTemplates\T
emplateDirs\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\1. It should have 3
values:
(Default) = '#200'
SortPriorty = d '1'
TemplatesDir = 'C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\Business Intelligence Projects'
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Noble" <J Noble@.discussions.microsoft.com> wrote in message
news:F30A0356-D4E4-4AA9-A279-537D38E4C29E@.microsoft.com...
> Similar problem for me. I installed RS client side and also have no
> visibility to BI in VS .NET 2003. A couple of differences though:
> 1) I -never- had visibility
> 2) I can open the sample solution file (with the AdventureWorks reports),
> and can even deploy it the server. But trying to add new BI items (or
create
> a BI project to begin with) are impossible.
> Can anyone help us?
> "Dan Friauf" wrote:
> > I am in the process of evaluating Reporting Services for my company. I
> > succesfully installed Reporting Services and began developing a simple
> > report. After closing Visual Studio to attend to another matter, I
later
> > re-opened Visual Studio and was unable to edit my existing report
project.
> > The error I received was "The selected file is not a valid Visual Studio
> > Solution file". Further, when I tried to create a new project, Business
> > Intelligence is no longer listed in the project types dialog. I have
tried
> > uninstalling and reinstalling both Visual Studio and Reporting Services
and I
> > still have the same problem. Can anyone suggest a solution? Thank you.|||Yes to both items. I presume that means you think it ought to be working.
Any other thoughts?
Thank you for your assistance.
"Albert Yen [MSFT]" wrote:
> Can you check that the folder %ProgramFiles%\Microsoft SQL
> Server\80\Tools\Report Designer\Business Intelligence Projects exists? It
> should contain 3 files. Next, check for the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\NewProjectTemplates\T
> emplateDirs\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\1. It should have 3
> values:
> (Default) = '#200'
> SortPriorty = d '1'
> TemplatesDir = 'C:\Program Files\Microsoft SQL Server\80\Tools\Report
> Designer\Business Intelligence Projects'
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "J Noble" <J Noble@.discussions.microsoft.com> wrote in message
> news:F30A0356-D4E4-4AA9-A279-537D38E4C29E@.microsoft.com...
> > Similar problem for me. I installed RS client side and also have no
> > visibility to BI in VS .NET 2003. A couple of differences though:
> > 1) I -never- had visibility
> > 2) I can open the sample solution file (with the AdventureWorks reports),
> > and can even deploy it the server. But trying to add new BI items (or
> create
> > a BI project to begin with) are impossible.
> >
> > Can anyone help us?
> >
> > "Dan Friauf" wrote:
> >
> > > I am in the process of evaluating Reporting Services for my company. I
> > > succesfully installed Reporting Services and began developing a simple
> > > report. After closing Visual Studio to attend to another matter, I
> later
> > > re-opened Visual Studio and was unable to edit my existing report
> project.
> > > The error I received was "The selected file is not a valid Visual Studio
> > > Solution file". Further, when I tried to create a new project, Business
> > > Intelligence is no longer listed in the project types dialog. I have
> tried
> > > uninstalling and reinstalling both Visual Studio and Reporting Services
> and I
> > > still have the same problem. Can anyone suggest a solution? Thank you.
>
>|||The folder does exist and the registry values are as given. Although, the
SortPriority is show in hexadecimal rather than decimal. Where do we go from
here?
"Albert Yen [MSFT]" wrote:
> Can you check that the folder %ProgramFiles%\Microsoft SQL
> Server\80\Tools\Report Designer\Business Intelligence Projects exists? It
> should contain 3 files. Next, check for the registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\NewProjectTemplates\T
> emplateDirs\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\1. It should have 3
> values:
> (Default) = '#200'
> SortPriorty = d '1'
> TemplatesDir = 'C:\Program Files\Microsoft SQL Server\80\Tools\Report
> Designer\Business Intelligence Projects'
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "J Noble" <J Noble@.discussions.microsoft.com> wrote in message
> news:F30A0356-D4E4-4AA9-A279-537D38E4C29E@.microsoft.com...
> > Similar problem for me. I installed RS client side and also have no
> > visibility to BI in VS .NET 2003. A couple of differences though:
> > 1) I -never- had visibility
> > 2) I can open the sample solution file (with the AdventureWorks reports),
> > and can even deploy it the server. But trying to add new BI items (or
> create
> > a BI project to begin with) are impossible.
> >
> > Can anyone help us?
> >
> > "Dan Friauf" wrote:
> >
> > > I am in the process of evaluating Reporting Services for my company. I
> > > succesfully installed Reporting Services and began developing a simple
> > > report. After closing Visual Studio to attend to another matter, I
> later
> > > re-opened Visual Studio and was unable to edit my existing report
> project.
> > > The error I received was "The selected file is not a valid Visual Studio
> > > Solution file". Further, when I tried to create a new project, Business
> > > Intelligence is no longer listed in the project types dialog. I have
> tried
> > > uninstalling and reinstalling both Visual Studio and Reporting Services
> and I
> > > still have the same problem. Can anyone suggest a solution? Thank you.
>
>|||OK. I'm feeling real foolish here. When I upgraded to Visual Studio 2003
the upgrade did not remove the start menu option for the previous version. I
was starting "Microsoft Visual Studio .NET" and not "Microsoft Visual Studio
.NET 2003". When I open the right one, everything is there.
"Dan Friauf" wrote:
> The folder does exist and the registry values are as given. Although, the
> SortPriority is show in hexadecimal rather than decimal. Where do we go from
> here?
> "Albert Yen [MSFT]" wrote:
> > Can you check that the folder %ProgramFiles%\Microsoft SQL
> > Server\80\Tools\Report Designer\Business Intelligence Projects exists? It
> > should contain 3 files. Next, check for the registry key
> > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\NewProjectTemplates\T
> > emplateDirs\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\1. It should have 3
> > values:
> > (Default) = '#200'
> > SortPriorty = d '1'
> > TemplatesDir = 'C:\Program Files\Microsoft SQL Server\80\Tools\Report
> > Designer\Business Intelligence Projects'
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "J Noble" <J Noble@.discussions.microsoft.com> wrote in message
> > news:F30A0356-D4E4-4AA9-A279-537D38E4C29E@.microsoft.com...
> > > Similar problem for me. I installed RS client side and also have no
> > > visibility to BI in VS .NET 2003. A couple of differences though:
> > > 1) I -never- had visibility
> > > 2) I can open the sample solution file (with the AdventureWorks reports),
> > > and can even deploy it the server. But trying to add new BI items (or
> > create
> > > a BI project to begin with) are impossible.
> > >
> > > Can anyone help us?
> > >
> > > "Dan Friauf" wrote:
> > >
> > > > I am in the process of evaluating Reporting Services for my company. I
> > > > succesfully installed Reporting Services and began developing a simple
> > > > report. After closing Visual Studio to attend to another matter, I
> > later
> > > > re-opened Visual Studio and was unable to edit my existing report
> > project.
> > > > The error I received was "The selected file is not a valid Visual Studio
> > > > Solution file". Further, when I tried to create a new project, Business
> > > > Intelligence is no longer listed in the project types dialog. I have
> > tried
> > > > uninstalling and reinstalling both Visual Studio and Reporting Services
> > and I
> > > > still have the same problem. Can anyone suggest a solution? Thank you.
> >
> >
> >|||No, I don't have any ideas why you cannot see "Business Intelligence
Projects" in the New Project dialog. However, since you say you can open
existing projects, you can create a new one by coping the template file.
%ProgramFiles%\\Microsoft SQL Server\80\Tools\Report
Designer\ReportProjects\ReportProject.rptproj and opening that.
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Noble" <JNoble@.discussions.microsoft.com> wrote in message
news:650FBF6D-2F9E-4647-9CAD-C30D3F2D2B61@.microsoft.com...
> Yes to both items. I presume that means you think it ought to be working.
> Any other thoughts?
> Thank you for your assistance.
>
> "Albert Yen [MSFT]" wrote:
> > Can you check that the folder %ProgramFiles%\Microsoft SQL
> > Server\80\Tools\Report Designer\Business Intelligence Projects exists?
It
> > should contain 3 files. Next, check for the registry key
> >
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\7.1\NewProjectTemplates\T
> > emplateDirs\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\1. It should have 3
> > values:
> > (Default) = '#200'
> > SortPriorty = d '1'
> > TemplatesDir = 'C:\Program Files\Microsoft SQL Server\80\Tools\Report
> > Designer\Business Intelligence Projects'
> >
> > --
> > Albert Yen
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "J Noble" <J Noble@.discussions.microsoft.com> wrote in message
> > news:F30A0356-D4E4-4AA9-A279-537D38E4C29E@.microsoft.com...
> > > Similar problem for me. I installed RS client side and also have no
> > > visibility to BI in VS .NET 2003. A couple of differences though:
> > > 1) I -never- had visibility
> > > 2) I can open the sample solution file (with the AdventureWorks
reports),
> > > and can even deploy it the server. But trying to add new BI items (or
> > create
> > > a BI project to begin with) are impossible.
> > >
> > > Can anyone help us?
> > >
> > > "Dan Friauf" wrote:
> > >
> > > > I am in the process of evaluating Reporting Services for my company.
I
> > > > succesfully installed Reporting Services and began developing a
simple
> > > > report. After closing Visual Studio to attend to another matter, I
> > later
> > > > re-opened Visual Studio and was unable to edit my existing report
> > project.
> > > > The error I received was "The selected file is not a valid Visual
Studio
> > > > Solution file". Further, when I tried to create a new project,
Business
> > > > Intelligence is no longer listed in the project types dialog. I
have
> > tried
> > > > uninstalling and reinstalling both Visual Studio and Reporting
Services
> > and I
> > > > still have the same problem. Can anyone suggest a solution? Thank
you.
> >
> >
> >

No comments:

Post a Comment