Report Designer - deploying to a specific directory

Hi - When creating a report without using the report wizard, how does one
specify the directory on the RS server that each SPECIFIC report is to be
deployed to? I know that the report project has a "Deployment Folder"
property but that is project-wide. We want to do it for each specific
report. Do I need separate projects for multiple folders?
thanksUnfortunately, you can only designate one folder per solution currently. A
possible alternative is to use an rs script to publish them to desired
folders. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
for an example.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> Hi - When creating a report without using the report wizard, how does one
> specify the directory on the RS server that each SPECIFIC report is to be
> deployed to? I know that the report project has a "Deployment Folder"
> property but that is project-wide. We want to do it for each specific
> report. Do I need separate projects for multiple folders?
> thanks|||Just a slight correction, you specify per project, not per solution.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
news:41813be2$1@.news.microsoft.com...
> Unfortunately, you can only designate one folder per solution currently.
A
> possible alternative is to use an rs script to publish them to desired
> folders. See
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
> for an example.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> > Hi - When creating a report without using the report wizard, how does
one
> > specify the directory on the RS server that each SPECIFIC report is to
be
> > deployed to? I know that the report project has a "Deployment Folder"
> > property but that is project-wide. We want to do it for each specific
> > report. Do I need separate projects for multiple folders?
> >
> > thanks
>|||Yes - thanks Bruce! It is per project.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:usX7J6RvEHA.1984@.TK2MSFTNGP14.phx.gbl...
> Just a slight correction, you specify per project, not per solution.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
> news:41813be2$1@.news.microsoft.com...
>> Unfortunately, you can only designate one folder per solution currently.
> A
>> possible alternative is to use an rs script to publish them to desired
>> folders. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
>> for an example.
>> --
>> -- "This posting is provided 'AS IS' with no warranties, and confers
>> no
>> rights."
>> jhmiller@.online.microsoft.com
>> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
>> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
>> > Hi - When creating a report without using the report wizard, how does
> one
>> > specify the directory on the RS server that each SPECIFIC report is to
> be
>> > deployed to? I know that the report project has a "Deployment Folder"
>> > property but that is project-wide. We want to do it for each specific
>> > report. Do I need separate projects for multiple folders?
>> >
>> > thanks
>>
>|||Hi John, thanks much for the info.
Matt
"John H. Miller" wrote:
> Unfortunately, you can only designate one folder per solution currently. A
> possible alternative is to use an rs script to publish them to desired
> folders. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp
> for an example.
> --
> -- "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> jhmiller@.online.microsoft.com
> "ISGADMIN" <isgadmin@.newsgroup.nospam> wrote in message
> news:BB9F0755-7F44-4507-B86F-B8691615BE59@.microsoft.com...
> > Hi - When creating a report without using the report wizard, how does one
> > specify the directory on the RS server that each SPECIFIC report is to be
> > deployed to? I know that the report project has a "Deployment Folder"
> > property but that is project-wide. We want to do it for each specific
> > report. Do I need separate projects for multiple folders?
> >
> > thanks
>
>

Report Dataset is lost once the Data Tab is clicked

1. Created a New Report Server Wizard Project using OLAP as datasource
2. Gone through the wizard steps to generate a matrix report.
3. All is fine and the report gets previewed. I build and deploy the report.
4. Now , if I need to add a new column I go to data tab of the report. Realize that the query is lost and now the report throws exception like the following when rebuild:

" [rsFieldReference] The Value expression for the textbox ‘Base_Premium’ refers to the field ‘Base_Premium’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."
5. No idea why the query given at the query builder stage of the wizard is lost

Steps to Reproduce:

1. Create a new Report Server Wizard Project
2. Create a new datasource using OLAP as datasource
3. Add the report data fields (query builder)
4. Select matrix report format and any style
5. Select the row, col and data fields.
6. complete the wizard.
7. Save, build and deploy the project
8. Preview the report.
9. Now try to add a new column to the report by clicking the data tab.

Actual Results:

The sql prepared from the query builder is lost and all the columns previously selected disappear. The report throws exception in preview mode something like :

" [rsFieldReference] The Value expression for the textbox ‘Base_Premium’ refers to the field ‘Base_Premium’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."

Expected Results:

Should be able to modify the report any number of times after it is initially generated.

Actual Results:

The sql prepared from the query builder is lost and all the columns previously selected disappear. The report throws exception in preview mode something like :

" [rsFieldReference] The Value expression for the textbox ‘Base_Premium’ refers to the field ‘Base_Premium’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope."

Expected Results:

Should be able to modify the report any number of times after it is initially generated.

Please check this KB article: http://support.microsoft.com/kb/909535/en-us