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