Drilldown on ppDBText

rbuser

Hi,

I've been trying to work out how the DrillDown works on ppDBText components,
specifically using OnDrawCommandClick and OnDrawCommandCreate event
handlers. I can get the text value of the ppDBText component I click on
when previewing my report no worries, but I would also like to get the text
values of other ppDBText components on the same detail line, is this
possible?

e.g. I have a detail line with the following ppDBText components -
ppdbText1, ppdbText2, ppdbText3, ppdbText4, when I preview the report I want
to be able to click on the ppdbText1 component on any given line of the
report and not only retrieve the text value of that component but also of
the corresponding ppdbText2 and ppdbText3 components on the same line of the
report (without haviung to click on them as well).

Any ideas please,

TIA

Willie

nicocizik

Hi Willie,

The issue here is that once the drawcommands are drawn to the page, there is
no longer concept of a "band" to group the rest of the DBText component
together.

My suggestion would be to access the TppDrawCommand.Page property of the
clicked drawcommand, then loop through each drawcommand object for that page
comparing each of the Top values to the original. If you have lined each
DBText up properly, you should be able to compile a list of drawcommands in
the same row and access their values.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Thanks Nico,

I found an earlier post of yours pointing to one of the demo's about
drill-down using the .tag property of the TppDrawText object. I used that
and did a work around storing a unique recordid of the pipelines dataset in
the tag (in the DrawCommandCreate event handler) then used that to find my
record and get the other values I required from the dataset itself in the
DrawCommandClick event handler... if that makes sense.