Hi Jhon,
Thanks for responding my email ,actually my requirement is I have Orders and related tables and now I need to generate a report something looks like below whenever user click on “+” that report will be expanded .I know it is possible in SSRS (SQl Server Reporting Services) but now my requirement is I need to generate that kind of report in R. If we look at screen shot (or PFA) almost 100244 order exists 8 times ,now I want to generate the report whenever user clicks on order 100244 and it needs to be expand and need to display the cost of all the products and what are the products they were purchased on this orderID . Note: in backend I did using Group by (sql) but I don’t know how to present in this report. Hi Marc, Thanks,Currently I’m creating reports using shinyapps only ,I have checked out throghly with shinyapps but I didn’t find any solution,is there any alternative way that I can use to genarate the drill down report. Manu. On Tue, Sep 13, 2016 at 8:33 PM, Marc Schwartz <marc_schwa...@me.com> wrote: > 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 <jrkrid...@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.redd...@gmail.com > >> Sent: Tue, 13 Sep 2016 16:16:05 +0530 > >> To: r-help@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. > > -- Thanks, Manohar Reddy P +91-9705302062.
______________________________________________ R-help@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.
