June 13, 2010 at 6:36 am
Dear All:
I am building now a Reporting Service with Microsoft Business Intelliegence
i building my reports to run over a operational database for non relational tables
and i need to build a drill down, and drill up techniques inside the reports.
i need after deploying the reports on report server to make user access the reports and make drill down and drill up in the report....:hehe::hehe::hehe:
means if the user is standing on reports grouped by years, i want him to click on reports to drill down to quarters, and to months,, and also the same for drilling up from months to quarters and so to years....
Can any body please have any idea how to make it,,,???????????????:w00t::w00t::w00t::w00t:
June 14, 2010 at 6:00 am
You can add drill down and drill up by utilizing the visibility functionality and setting a text box to toggle between visible and hidden. In the selected textbox, you will get a plus or minus sign depending on whether the detail is hidden or shown.
June 15, 2010 at 4:40 pm
thank you for your reply
but have you saw the drill option in SAP BO ?
when you click on chart or graph the drill option auto generate a new report runs on the parameters which the mouse is over....
but about the toggle option yes ofcourse i use it as a drill down,, but i need to do the same like the SAP BO drill down and up.
I am very thankfull for your reply once again
June 15, 2010 at 5:08 pm
yes, you can click on a chart or figure by utilizing the Navigatin Tab jump to Report or jump to URL options and then specificing the parameters. I have not seen the SAP product.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply