CiviCRM Community Forums (archive)

Hey all,
Using CiviCRM 3.0.2 on Joomla 1.5.15
I'm developing custom reports. our finance department wants a report every morning of all of the users signed up for our events, what there status is (registered or pending-pay-later), and their address.

I've created the custom_php and custom_templates folders and created a custom report (called DailyEventsReport) right now it's a clone of participant listing and works just fine. I've been able to edit some of the text so I know that it's running off of the custom report.

The problem comes when trying to add things to the report criteria. the only custom report documentation i could find is at http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+structure+and+customization and it seems it's a little... lackluster.

Street address always returned blank, though I can see in the contacts section their home and billing addresses were filled in. I'm not 100% certain where this is stored. from what I can gather it's generated from the civicrm_address table. I tried to add city in place of street_address and that worked, however when I tried to add postal_code after it displayed, but city disappeared.

is there a better set of documentation for how to add fields to report criteria? I have been looking, but been unable to find it. If someone can point me in the right direction, after i figure this out, i'd be willing to write up a good guide for the wiki.

Thanks,
LDJosh

Thanks Lobo, the ERD helps.

I've got some of the custom data coming in now. I wasn't encapsulating right the first time around, but now some of it shows up. the problem is, not everything works and I can't figure out quite why...

Can someone take a look at this explain why city and postal code and street address work but street name doesn't?
id, is_billing and is_primary didn't show up either.
according to the ERD this should be fine. I'm missing something...





'civicrm_address'     =>
                  array( 'dao'          => 'CRM_Core_DAO_Address',
                         'fields'       =>
                         array( 'city' => null,'postal_code' => null,'street_address' => null, 'street_name' => null                              
                                ),
                         'grouping'  => 'contact-fields',
                         ),