Tuesday, April 03, 2012 2:05 AM
I am looking to create and edit SSRS projects and standalone report files with rdl and rdlc files in Visual Studio 2010.
I would like to be able to import MS Access reports as well.
Can I do this, if so how and where is the download.
Tuesday, April 03, 2012 5:07 AM
Tuesday, April 03, 2012 5:19 AM
But someone from the SSDT team has contradicted this (see the comments area):
I would be happy to be proved wrong, or if someone can point me to a download containing report editing features that would be great.
Tuesday, April 03, 2012 5:24 AM
Thanks for your post.
Visual Studio 2010 does not let you edit a BI project that is created by using BIDS in SQL Server 2005, in SQL Server 2008, or in SQL Server 2008 R2.
You will get more informations on below link hope this will help you.
Tuesday, April 03, 2012 6:04 AM
Thanks Suhas, I know this has been the case in the past, I have submitted many a connect suggestion about how poor this is.
However there seems to be lots of SQL 2012 documentation that references editing reports in a report designer and I find it hard to believe they mean Visual Studio 2008 or BIDS designer 2008.
"Use the information in this topic to design reports and related items for a single reporting project in a SQL Server Data Tools (SSDT) solution. For more information about solutions and multiple projects in SQL Server Data Tools (SSDT), see Reporting Services in SQL Server Data Tools (SSRS)."
I guess I am trying to find someone from Microsoft to clarify the story around this as everyone seems to be contracting themselves in the documenation.
SSDT is a 2012 concept not a 2008 concept, hence my confusion.
Wednesday, April 04, 2012 4:35 AM
You can find more discussion on the below link hope it will hepl you some how.
1) SQL Server 2012 installs "SQL Server Data Tools" under the "SQL Server 2012" Start Menu option - this includes BIDS but not Database Projects.
2) Database Projects installs "MICROSOFT SQL Server Data Tools" under the root of the Start Menu - this doesn't have BIDS functionality included if installed separately.
- Edited by Suhas Kudekar Wednesday, April 04, 2012 4:36 AM
Wednesday, April 04, 2012 4:51 AM
yes it took me all afternoon yesterday but I came up with a similar conclusion:
SSDT from the web platform installer is the new Database Design features with schema management etc.
SSDT from the SQL Server Reporting Services installation (eg SQL 2012 Express with Advanced tools) are report designer components.
So very confusingly there are 2 different components that are going by the same name. No wonder I am loosing hair and sleep.
By the way the report designer features seem to reference Office XP (!!) primary interop assemblies that are not included in the installation so trying to import Access reports fails.
Loving the whole experience of the BIDS team always being so far behind (Office 4 versions behind apparently and still stuck with VS2008 as the only working report designer).
Wednesday, April 04, 2012 7:01 AMModerator
Hi Simon Lampen,
Answers from one of my colleagues and a senior member:
TechNet Community Support
Please remember to mark the replies as answers if they help.
- Marked As Answer by Lola WangMicrosoft Contingent Staff, Moderator Thursday, April 12, 2012 6:13 AM