To develop reports we need BIDS (Business Intelligence Development Studio). It is free and available as part of SQL Server Express editions. The BIDS is available for SQL Server 2005 and SQL Server 2008.
Here is more detail about BIDS
http://msdn.microsoft.com/en-us/library/ms173767.aspx#Accessibility
Microsoft SQL Server 2005 Express Edition Toolkit
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=19413
Microsoft® SQL Server® 2008 Express with Tools
http://www.microsoft.com/en-us/download/details.aspx?id=1842
Hi, my visual studio 2010 missing business intelligence development studio how could I get the installer standalone?? I can't preview my SSRS report
ReplyDeleteDiscount Coupon Codes
Yung Fei,
ReplyDeleteLooks like you need to install the SQL 2012 Management Tools (+ Report services bits) to get VS2010 BI projects. If you open "SQL Server Data Tools" from your start menu, it will open VS2010 and offer reporting options.
Hi Adhi,
ReplyDeleteI tried installing BIDS 2008 from the link you have mentioned above but I couldn't get the option to select BIDS in Features Selection during installation.
I tried installing Microsoft® SQL Server® 2008 Express with Advanced Services from the below link:
http://www.microsoft.com/en-us/download/details.aspx?id=1842
It helped.
Thanks Bharkavi for posting the update
DeleteHi Adhi,Do we need to download sql2012 to get the SQL 2012 Management Tools or just any standalone installer?
ReplyDeletePlease guide..
Neeraj Lohumi
Neeraj,
DeleteYou can even download "Microsoft SQL Server 2012 Express" to get the "SQL Server Management Studio Express”
http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx
Regards,
Adhi