[R] Drill down reports in R

[Marc Schwartz]

> On Sep 13, 2016, at 11:11 AM, Manohar Reddy <manu.reddy52 at gmail.com> wrote:
> 
> 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.
> 

Hi Manu,

As noted, the type of functionality that you are looking for would typically require a GUI that supports dynamic interactions and updating. That is why there are dedicated reporting tools, as I noted, that have evolved over the years, to serve that need in the typical business domains where it is used. 

Most of those tools typically interface with a live server database backend (e.g. Oracle, MySQL, etc.), a local database or spreadsheet file (e.g. MS Access or Excel via ODBC) or an intermediate "OLAP cube" construct, as the primary data repository to which dynamic queries are sent based upon user inputs from the GUI.

If Shiny does not have that in place already and you wanted to use Shiny, you would need to develop it on your own or have likely have to pay someone do it for you.

I am not aware of other possible R related GUIs that support that type of interaction, albeit, it is possible that somebody has done something that is not yet well publicized or may be for internal use only. 

There are a variety of supporting technologies (e.g. AJAX, Java, etc.) that could provide for that type of functionality, either stand alone or within a browser based environment, but it would not be "pure R" per se.

It may also be possible that one of the other commercial R vendors (e.g. Microsoft) have built something on top of a server version of R and you would need to contact them to see if that is the case.

Regards,

Marc

> 
> On Tue, Sep 13, 2016 at 8:33 PM, Marc Schwartz <marc_schwartz at me.com <mailto:marc_schwartz at 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/ <http://shiny.rstudio.com/gallery/>
> 
> Regards,
> 
> Marc Schwartz
> 
> 
> > On Sep 13, 2016, at 9:48 AM, John Kane <jrkrideau at inbox.com <mailto: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 <mailto:manu.reddy52 at gmail.com>
> >> Sent: Tue, 13 Sep 2016 16:16:05 +0530
> >> To: r-help at r-project.org <mailto: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/ <http://bhushan.extreme-advice.com/drilldown-report-in-ssrs/>
> >>
> >>
> >>
> >> Thanks in Advance !
> >>
> >> Manu.
> 
> 
> 
> 
> -- 
> 
> 
> Thanks,
> Manohar Reddy P
> +91-9705302062.
> 


	[[alternative HTML version deleted]]