Can't find properties

This is the first time I've used SSRS. I've created a report and in preparation for deploying it I am trying to find where I set the properties. In Visual Studio 2005, in the Solution Explorer I right click on my .rdl file and select properties. The only properties listed are File Name (which is changeable) and File Path (which is not changeable). The property pages icon in the same dialog box is greyed out. Am I missing someghing? Any help would be greatly appreciated.

Thanks.

Go to the layout tab and try clicking on an area outside of the white area where you place your report objects. This should give you the report properties. Is that what you're looking for?

There is also a report properties dialog that will let you set most of the report properties. Go to the Report menu and select Report Properties. You have to have a report open in the designer for the Report menu to even be there.

|||

Thank you very much for the tip, I can see a number of properties of the report. However I still cannot find where to set the following properties

OverWriteDataSources:

TargetDataSourceFolder:

TargetRootFolder:

TargetServerURL:

I couldn't see these deployment properties where you pointed. Am I still missing something? Sorry if I seem kind of slow.

|||

These are properties of the report solution:

After you opened a report project, go to the VS Solution Explorer window. Right-click your report solution and select "Properties". The popup-dialog will contain the four properties you are looking for.

-- Robert

|||

Robert,

Thank you for the feed back. I've tried this many times now and I keep getting the same thing i.e. Open my project report, go to the VS Solution Explorer window under Reports I highlight the name of my report (Report1.rdl) right click on that report and I get a property window which only has two properties File Name: (which is editable) and File Path: (which is uneditable).

Do I possibly not have SSRS installed properly? This seems a simple thing but it is driving me crazy. Thanks for your help.

Bill

|||

Right-click on the root of the tree shown in the VS Solution Explorer. The root of the tree represents the entire report project - do not select a particular report.

-- Robert

|||

Robert,

Thank you so very much, I tried every level in the VS Solution Explorer BUT the root. Who would have thought! All of the documentation and tutorials were not as clear as your last note. Thank you again.

Bill

can't deploy, SSRS 2K5

Hi kids:
I'm sure this is an easy one, sorry for posting a knob question...
Whenever I attempt to deploy a report, I get prompted for a login. I
don't remember setting SSRS to run as anyting except Local System, and
the configuration tool bears that out. When I click "deploy" on my
(very simple) report, it prompts me for a username & password. If I
click cancel, it declares the deployment a failure and stops. I have
tried entering my domain\user & password, user & password, sa &
password, but all fail.
Suggestions?
Thanks;
DuncanIs RS on your machine or a different one? It doesn't matter what RS uses to
run, it implements security and you have to have the correct rights to
deploy.
First, even without a report deployed you need to be able to see Report
Manager (the portal that ships with RS). Does that work for you?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Duncan A. McRae" <google.com@.mcrae.ca> wrote in message
news:1187288669.801335.68890@.q3g2000prf.googlegroups.com...
> Hi kids:
> I'm sure this is an easy one, sorry for posting a knob question...
> Whenever I attempt to deploy a report, I get prompted for a login. I
> don't remember setting SSRS to run as anyting except Local System, and
> the configuration tool bears that out. When I click "deploy" on my
> (very simple) report, it prompts me for a username & password. If I
> click cancel, it declares the deployment a failure and stops. I have
> tried entering my domain\user & password, user & password, sa &
> password, but all fail.
> Suggestions?
> Thanks;
> Duncan
>

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!

can''t create reports via VS 2005 Standard

From what I read about the versions, VS 2005 Standard allows for SSRS development.

If I create a new project, I don't see the option to create anything from the BI section to create a report project.

I have SQL Server Express on my machine, and am able to run the SSRS configuartion management tool.

Do I have to run an .exe file or something?

Thanks!

When you installed SQL, did you expand all of the components and specify that you WANT them to be installed? For some reason they all default to do NOT intall.

I believe there is a component in client components (business intelligence studio) or something like that which actually installs the SQL server report project to Visual Studio.

Yes, Visual Studio comes with a menu in the create project wizard for Business Intelligence Projects. However, there are most likely no project types in that section for you, because the proper components were not installed when SQL was installed.

|||You have to install the SQL Server 2005 workstation tools including the Business Intelligence Studio AFTER VS 2005 is installed, and several new modules will show in the VS2005 startup splash, and new project types will be available.

If this still does not appear properly, you may need to rebuild your project templates. I took me a couple re-installs to get it right.
|||

did a re-install of the tool set which includes the BI templates and that worked.

Thanks!