Hi, How to generate ?Drill down reports ? (like please refer below url) in R using any package ? I did lot of research in google but I didn?t found suitable link . Can anyone help how to do that in R ? url : http://bhushan.extreme-advice.com/drilldown-report-in-ssrs/ Thanks in Advance ! Manu. [[alternative HTML version deleted]]
It is not really clear what you want but have a look at ?subset perhaps. John Kane Kingston ON Canada> -----Original Message----- > From: manu.reddy52 at gmail.com > Sent: Tue, 13 Sep 2016 16:16:05 +0530 > To: r-help at r-project.org > Subject: [R] Drill down reports in R > > Hi, > > > > How to generate ?Drill down reports ? (like please refer below url) in > R > using any package ? I did lot of research in google but I didn?t found > suitable link . > > Can anyone help how to do that in R ? > > > > url : http://bhushan.extreme-advice.com/drilldown-report-in-ssrs/ > > > > Thanks in Advance ! > > Manu. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.____________________________________________________________ Can't remember your password? Do you need a strong and secure password? Use Password manager! It stores your passwords & protects your account.
Hi, Generally "drilldown" reports require a dynamic GUI that supports widgets that generate the data queries behind the scenes in response to user input/clicks and then updated the display dynamically with the additional data/content. This would be more typical of business oriented reporting/OLAP tools like Cognos, Business Objects, Crystal Reports, etc. The first thing that came to mind is RStudio's Shiny, which I do not use, but their gallery seems to have some possibilities: http://shiny.rstudio.com/gallery/ Regards, Marc Schwartz> On Sep 13, 2016, at 9:48 AM, John Kane <jrkrideau at inbox.com> wrote: > > It is not really clear what you want but have a look at ?subset perhaps. > > John Kane > Kingston ON Canada > > >> -----Original Message----- >> From: manu.reddy52 at gmail.com >> Sent: Tue, 13 Sep 2016 16:16:05 +0530 >> To: r-help at r-project.org >> Subject: [R] Drill down reports in R >> >> Hi, >> >> >> >> How to generate ?Drill down reports ? (like please refer below url) in >> R >> using any package ? I did lot of research in google but I didn?t found >> suitable link . >> >> Can anyone help how to do that in R ? >> >> >> >> url : http://bhushan.extreme-advice.com/drilldown-report-in-ssrs/ >> >> >> >> Thanks in Advance ! >> >> Manu.
As has been mentioned, this really requires a GUI tool beyond just R. Luckily there are many GUI tools that have been linked to R and if Shiny (the shiniest of them) does not have something like this easily available so far then you may want to look elsewhere in the meantime. One option is the tcltk package which interfaces with the Tk GUI tools (and the tcl language) which does have the pieces to build in the expandable/drill down interface. One implementation of this is the TkListView function in the TeachingDemos package which can be used to view list objects in this manner (it starts with the top level list objects, then when you click on a + symbol it will open that piece and show one level down). One possibility would be to create all of your results in a list, then view it with TkListView (this will require all computations up front, whether anyone looks at them or not). Another option would be to start with TkListView and rewrite it to do things more dynamically and with the output that you want to show. There is also the shinyTree package on CRAN that allows a tree type object in shiny that may do what you want (I don't know what all options it allows and what it can display beyond what is in the Readme). On Tue, Sep 13, 2016 at 4:46 AM, Manohar Reddy <manu.reddy52 at gmail.com> wrote:> Hi, > > > > How to generate ?Drill down reports ? (like please refer below url) in R > using any package ? I did lot of research in google but I didn?t found > suitable link . > > Can anyone help how to do that in R ? > > > > url : http://bhushan.extreme-advice.com/drilldown-report-in-ssrs/ > > > > Thanks in Advance ! > > Manu. > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.-- Gregory (Greg) L. Snow Ph.D. 538280 at gmail.com
Hi , It would be great if someone can share the links how to generate the drill down reports/tables using combination of ?R & Javascript/Ajax/some other packages?. Note : I tried with *shinytree* package but it?s not met my requirement. Manu. On Tue, Sep 13, 2016 at 11:02 PM, Greg Snow <538280 at gmail.com> wrote:> As has been mentioned, this really requires a GUI tool beyond just R. > Luckily there are many GUI tools that have been linked to R and if > Shiny (the shiniest of them) does not have something like this easily > available so far then you may want to look elsewhere in the meantime. > > One option is the tcltk package which interfaces with the Tk GUI tools > (and the tcl language) which does have the pieces to build in the > expandable/drill down interface. One implementation of this is the > TkListView function in the TeachingDemos package which can be used to > view list objects in this manner (it starts with the top level list > objects, then when you click on a + symbol it will open that piece and > show one level down). > > One possibility would be to create all of your results in a list, then > view it with TkListView (this will require all computations up front, > whether anyone looks at them or not). > > Another option would be to start with TkListView and rewrite it to do > things more dynamically and with the output that you want to show. > > There is also the shinyTree package on CRAN that allows a tree type > object in shiny that may do what you want (I don't know what all > options it allows and what it can display beyond what is in the > Readme). > > > > On Tue, Sep 13, 2016 at 4:46 AM, Manohar Reddy <manu.reddy52 at gmail.com> > wrote: > > Hi, > > > > > > > > How to generate ?Drill down reports ? (like please refer below url) > in R > > using any package ? I did lot of research in google but I didn?t found > > suitable link . > > > > Can anyone help how to do that in R ? > > > > > > > > url : http://bhushan.extreme-advice.com/drilldown-report-in-ssrs/ > > > > > > > > Thanks in Advance ! > > > > Manu. > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide http://www.R-project.org/ > posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > > > -- > Gregory (Greg) L. Snow Ph.D. > 538280 at gmail.com >-- Thanks, Manohar Reddy P +91-9705302062. [[alternative HTML version deleted]]