Make the report an element. Include the report element in the view, where you want to present the report. Make the report element request the data it needs using requestAction from a controller that can provide the data. If the report data does not change often, cache the element for some time to avoid unnecessary request for data.
Is the above what you want? Enjoy, John On Apr 22, 3:08 pm, mivogt-LU <[email protected]> wrote: > To generate somer report data I want to execute a short sql command to > collect some data and hand it over as array to the html->table helper > to be displayed. > > sql code is > SELECT > BP.AnreiseDatum, BP.AbreiseDatum, BS.name, LS.Zimmernummer, > concat(CS.name,': ',CS.Firma,': ', CS.Vorname,', ', CS.Nachname) > FROM `booking_positions` as BP, `bookings` as BS , lodgings as LS, > customers as CS > WHERE bs.id = bp.`booking_id` AND `lodging_id`=LS.id AND > `customer_id`=CS.id > > is there a better way to solve this using the find()? > > How do I need to do the views manually (as the bake shell will not be > of use as far as I understood...) > > Thanks in advance > > Michael > > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with > their CakePHP related questions. > > 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 > athttp://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
