Putting Reports in Folders

Using Visual Studio I am trying to arrange my reports.
Here is what I have found:
1. I cannot create folders in Visual Studio.
2. I can deploy individual reports after changing the project property
(destination folder) to have reports arranged in folders.
3. I can deploy multiple projects - each landing in different folders
to have reports arranged in folders.
4. I can deploy a project the vanilla way then in Report Manager move
reports to other folders.
My disappointment is with number 1.
Number 2 is a pain in the neck.
If I do number 3, I have to have so many Data Sources defined it's a
mess.
Number 4 is so much work, I hate it.
HERE'S THE QUESTION
What's the best way to do it?
Thanks in advance.
JerryI am doing #3 & have a folder on Report Manager to share the Data sources.
Data sources still are moved along with the reports to their corresponding
folders. I moved those ones to the shared Data Sources folder, and it works
pretty good for me.
- David
"Jerry Nixon" wrote:
> Using Visual Studio I am trying to arrange my reports.
> Here is what I have found:
> 1. I cannot create folders in Visual Studio.
> 2. I can deploy individual reports after changing the project property
> (destination folder) to have reports arranged in folders.
> 3. I can deploy multiple projects - each landing in different folders
> to have reports arranged in folders.
> 4. I can deploy a project the vanilla way then in Report Manager move
> reports to other folders.
> My disappointment is with number 1.
> Number 2 is a pain in the neck.
> If I do number 3, I have to have so many Data Sources defined it's a
> mess.
> Number 4 is so much work, I hate it.
> HERE'S THE QUESTION
> What's the best way to do it?
> Thanks in advance.
> Jerry
>sql

publishing a report with parameters

say if i have a report that takes 2 parameters, StartDate & EndDate. and i want to publish/deploy this report for other users to run. Will the user be prompted to enter the 2 dates when they attempt to run the report?

sorry for the "what if" type question. ive been asked to do a bit of research on SQL Reporting Services

Cheers,
Craig

This depends on the report setup and on the method of access.

By report setup I mean the parameter. You can configure these with defaults and hence the users won't need to select the values but will still have the option to change the defaults.

By method of access I mean whether you are using the report manager (or some equivalent method of URL access) or the ReportServerWebService.Render method. By using URL access you get the "out of the box" export toolbar and parameter toolbar. By using the web service you pass in the paramaeter values but do not get the mentioned toolbars.

Remember, parameter defaults can be query based so for dates this can be made to return a dynamic value such as the current date.

Publish between servers

Is it possible to publish a report from a DEV reporting server to a
PRODUCTION reporting server?
We would like our developer to deploy to the DEV server and then
someone publish it to production
gertYou can use RSScripter to do this
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gert Conradie" <gert.conradie@.gmail.com> wrote in message
news:1125402536.289327.24680@.f14g2000cwb.googlegroups.com...
> Is it possible to publish a report from a DEV reporting server to a
> PRODUCTION reporting server?
> We would like our developer to deploy to the DEV server and then
> someone publish it to production
> gert
>|||Perfect, really really handy!
Wish list: Specify destination server so that one dont have to run the
bat file in two step process. But still as it is - really hande.
Thanks.
gert
Jasper Smith wrote:
> You can use RSScripter to do this
> http://www.sqldbatips.com/showarticle.asp?ID=62
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Gert Conradie" <gert.conradie@.gmail.com> wrote in message
> news:1125402536.289327.24680@.f14g2000cwb.googlegroups.com...
> > Is it possible to publish a report from a DEV reporting server to a
> > PRODUCTION reporting server?
> >
> > We would like our developer to deploy to the DEV server and then
> > someone publish it to production
> >
> > gert
> >