I have been scratching my head a bit recently with similar requests. I quickly found articles about "Star Schemas", dimensions and facts... and realised that really advanced reporting for any application could easily become a whole application of its own.
Solving this quickly, I would recommend you look at one of the available products and projects devoted to creating reports and "business intelligence" (as they like to cal it). If you have more time and an interest in trying to build the reporting module yourself, I put part of my code up on the paste bin. It shows a custom find function I wrote for finding facts based on any dimensions I want. http://bin.cakephp.org/view/1729436874 You need some understanding of the theory though. I just started reading about this earlier in the summer out of necessity and I am hardly an expert. The cool thing is that once the data you want to look at has been gathered into this new schema you can very quickly query the data in many different ways. A quick overview: First you need to figure out your facts, dimensions and grain ( number of sold products <by client> <per day> would give you a number-of- units-sold fact, a client dimension and a time dimension with at least a daily grain.). Then you need to take your normal data and create facts and related dimensions in your new "reporting tables". Then you need to figure out how best to query those facts to get the data you expect. This is where I created a general find function that I can use for any fact and any dimension I have. good luck :) it's a whole new world of reporting I never knew existed. /Martin On Sep 19, 5:56 am, AussieFreelancer <[EMAIL PROTECTED]> wrote: > Hi All, > > My client is requiring some reports, their site is built using 1.1, > but they would ideally like the ability to completely customise the > report, so for example, they choose the tables included in the report, > and the fields etc. > > I think that maybe it isn't possible due to the amount of combinations > that there could be, but I was wondering if there is already a module > that achieves this, and if not, if anyone has any thoughts on how I > could achieve this, if it is even possible. > > Thanks > > Patrick --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
