Monday, March 19, 2012

Newbie needs a hand with SQL2005 Reports

I'm trying to run some reports on SQL 2005, but can't even pass the first step of launching the report builder. I have SQL2005 on my local machine, but the report server is installed on a remote server. I launched SQL Business Intelligence Development Studio, which brings Visual studio, but i keep getting a prompt to enter a connection string. How do i get the connection string, or how do i set up my datasource?

Help!

To answer your question, try the following, but i think you need to configure 'iis', as well as 'reporting services configuration' before hand:

open sql server business intelligence studio
file
new
project
report server project
ok
view
solution explorer
right click reports
add
new item
data source
add
edit
<enter your database details here>

...and so on

look up the microsoft tutorial for creating a basic report in 'sql server business intelligence studio' help

No comments:

Post a Comment