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
> >