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 Builder field calculate problem

Hi,
I have a problems with the field calculations. NOT Work.
When i tried calculate total sales for a specific store, this duplicate or
3, 4, 5 times the total sales.Hello Guillermo,
I would look closely at you data source view and check that there is
nothing funny with the table joins you are basing your model on. This
is the main place where something goes wrong and causes the issue.
I would also review the report you are creating and check there are no
many to many possibilities with entries you have selected.
If you are still not having any luck have a look at the blog entry
describing how to trap the SQL generated by Report Builder.
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
Hope this helps
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/

Report Builder & Drillthrough

Has anyone succeeded in specifying a report that should be drilled-to from a
specific field? I have followed all the instructions I could find, but always
get the error:
The 'DrillthroughSourceQuery' parameter is missing a value
Is it necessary to learn the gory details of .rdl and semantic queries to
get this to work?
cheers,
Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.comI'm doing this like this:
* create a report using report builder
* set the option in the report to authorized the drill to this report from
other report
* save it as RDL (if you want to edit it in VS) or publish it directly
* using the management studio, edit the report builder model and setup the
drill for the target entity to your new report.
A "drill-to" report required some metadata and specific parameters, using
this method the system create all of these parameters for you.
good luck!
Jerome.
"Helen Warn" <HelenWarn@.discussions.microsoft.com> wrote in message
news:63A3CBC0-6C39-4777-B70A-11F2B57BEB2A@.microsoft.com...
> Has anyone succeeded in specifying a report that should be drilled-to from
> a
> specific field? I have followed all the instructions I could find, but
> always
> get the error:
> The 'DrillthroughSourceQuery' parameter is missing a value
> Is it necessary to learn the gory details of .rdl and semantic queries to
> get this to work?
> cheers,
> Helen
> --
> Helen Warn, PhD
> Agile Software Inc.
> www.agile-soft.com|||Yes it works perfectly fine... the drill through depends on how you design
the Report model and the relation it has with all the tables for drill
through. Why tables ? because it has data, so it relates the data and drill
through the data from your report, depending on the relation and the columns
selected on the report.
Ofcourse you have an option on report builder to enable and disable. Go to
Report Properties from the menu (From report Builder) and enable it.
Amarnath
"Helen Warn" wrote:
> Has anyone succeeded in specifying a report that should be drilled-to from a
> specific field? I have followed all the instructions I could find, but always
> get the error:
> The 'DrillthroughSourceQuery' parameter is missing a value
> Is it necessary to learn the gory details of .rdl and semantic queries to
> get this to work?
> cheers,
> Helen
> --
> Helen Warn, PhD
> Agile Software Inc.
> www.agile-soft.com|||Well, maybe it isn't designed to do what I want it to do. I have a contact
report that displays several fields related to a person. What I would like to
do is drill through to an address report (each contact can have several
addresses) that lists all the contact's addresses using drill-through on one
or more fields in the contact report. Is this possible?
Thx
Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com
"Amarnath" wrote:
> Yes it works perfectly fine... the drill through depends on how you design
> the Report model and the relation it has with all the tables for drill
> through. Why tables ? because it has data, so it relates the data and drill
> through the data from your report, depending on the relation and the columns
> selected on the report.
> Ofcourse you have an option on report builder to enable and disable. Go to
> Report Properties from the menu (From report Builder) and enable it.
> Amarnath|||I agree, there is no much of flexibility in RB, but still it satisfies quite
a bit what the so called "C" users want to see. Answering the second part of
your post.
It is very much possible. After creating report model with proper keys, and
enabling drill through through Report Properties from RB menu. one more thing
you need to do to make this work. You need to associate this report with an
entity in the data source, to allow users to drill to this report using
Management Studio, then it should work fine.
Amarnath
"Helen Warn" wrote:
> Well, maybe it isn't designed to do what I want it to do. I have a contact
> report that displays several fields related to a person. What I would like to
> do is drill through to an address report (each contact can have several
> addresses) that lists all the contact's addresses using drill-through on one
> or more fields in the contact report. Is this possible?
> Thx
> Helen
> --
> Helen Warn, PhD
> Agile Software Inc.
> www.agile-soft.com
>
> "Amarnath" wrote:
> > Yes it works perfectly fine... the drill through depends on how you design
> > the Report model and the relation it has with all the tables for drill
> > through. Why tables ? because it has data, so it relates the data and drill
> > through the data from your report, depending on the relation and the columns
> > selected on the report.
> >
> > Ofcourse you have an option on report builder to enable and disable. Go to
> > Report Properties from the menu (From report Builder) and enable it.
> >
> > Amarnath
>|||Thank you for your reply. I have followed all the steps you outline, and it
still does not work. Yesterday I installed SP2, which did solve another
intermittent problem I was having (saving reports from the Report Builder),
but I still cannot get my drill-through report to work properly.
I am very pleased to know that the RB should allow what I want to do. There
seems to be a problem in generating the semantic query.
Perhaps there is something wrong with my Report Model, but I am not seeing
it. I plan to open another support case with MS this morning.
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com
"Amarnath" wrote:
> I agree, there is no much of flexibility in RB, but still it satisfies quite
> a bit what the so called "C" users want to see. Answering the second part of
> your post.
> It is very much possible. After creating report model with proper keys, and
> enabling drill through through Report Properties from RB menu. one more thing
> you need to do to make this work. You need to associate this report with an
> entity in the data source, to allow users to drill to this report using
> Management Studio, then it should work fine.
> Amarnath
>
> "Helen Warn" wrote:
> > Well, maybe it isn't designed to do what I want it to do. I have a contact
> > report that displays several fields related to a person. What I would like to
> > do is drill through to an address report (each contact can have several
> > addresses) that lists all the contact's addresses using drill-through on one
> > or more fields in the contact report. Is this possible?
> >
> > Thx
> >
> > Helen
> > --
> > Helen Warn, PhD
> > Agile Software Inc.
> > www.agile-soft.com
> >
> >
> > "Amarnath" wrote:
> >
> > > Yes it works perfectly fine... the drill through depends on how you design
> > > the Report model and the relation it has with all the tables for drill
> > > through. Why tables ? because it has data, so it relates the data and drill
> > > through the data from your report, depending on the relation and the columns
> > > selected on the report.
> > >
> > > Ofcourse you have an option on report builder to enable and disable. Go to
> > > Report Properties from the menu (From report Builder) and enable it.
> > >
> > > Amarnath
> >