[R] Drill down reports in R

[Manohar Reddy]

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_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/
>
> 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.
>
>


-- 


Thanks,
Manohar Reddy P
+91-9705302062.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Orders_details.PNG
Type: image/png
Size: 16182 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20160913/d816e9a9/attachment.png>