Wednesday, March 21, 2012

matrix row total drillthru

How can I get to specify navigation from a matrix row total.
Thanks,
SamIf your question is how to define which detail columns display when you
perform a drill through on a total, then here is the answer:
It is defined in the data model. Open the data model that the report is
based on. Click on the entity that you would like to define the drill
through columns for (you have to do this process for each entity). You
will see a property for the entity called DefaultDetailAttributes.
Click in the proprty and an elips on the right will appear (a small box
with three dots in it). Click on the elips and it will open a dialog
box displaying the drill through attributes. In the dialog box, there
is an add button. Click that and another dialog box will open listing
all the attributes for the entity.
When you are done, redeploy the model. Any existing reports will now
drill through to the detail you defined.
- Steve
Sam wrote:
> How can I get to specify navigation from a matrix row total.
> Thanks,
> Sam|||Then I think my prior response will do the trick. Let me know. However,
I am assuming your report was created with report builder and not
visual studio reporting tool...
Sam wrote:
> Appreciate your response Steve. What I am trying to do is implement a
> drillthru on row subtotal.
> "steve" wrote:
> > If your question is how to define which detail columns display when you
> > perform a drill through on a total, then here is the answer:
> >
> > It is defined in the data model. Open the data model that the report is
> > based on. Click on the entity that you would like to define the drill
> > through columns for (you have to do this process for each entity). You
> > will see a property for the entity called DefaultDetailAttributes.
> > Click in the proprty and an elips on the right will appear (a small box
> > with three dots in it). Click on the elips and it will open a dialog
> > box displaying the drill through attributes. In the dialog box, there
> > is an add button. Click that and another dialog box will open listing
> > all the attributes for the entity.
> >
> > When you are done, redeploy the model. Any existing reports will now
> > drill through to the detail you defined.
> >
> > - Steve
> >
> > Sam wrote:
> > > How can I get to specify navigation from a matrix row total.
> > >
> > > Thanks,
> > > Sam
> >
> >

No comments:

Post a Comment