Zuckerreport and Ireport blank Output

[SVydelingum]

Hi,

I installed Zucker report 1.7 and I am using ireport 1.3 to create a report querying the leads and lead_cstm table.

In ireport this is my sql with a parameter entry.

SELECT
leads.`salutation` AS leads_salutation,
leads.`first_name` AS leads_first_name,
leads.`last_name` AS leads_last_name,
leads_cstm.`jr_lead_pov_c` AS leads_cstm_jr_lead_pov_c,
leads_cstm.`jr_lead_ih_c` AS leads_cstm_jr_lead_ih_c,
leads_cstm.`jr_lead_iag_c` AS leads_cstm_jr_lead_iag_c,
leads_cstm.`jr_lead_lod_c` AS leads_cstm_jr_lead_lod_c,
leads_cstm.`jr_contact_apptype_c` AS leads_cstm_jr_contact_apptype_c,
leads_cstm.`jr_lead_ref_c` AS leads_cstm_jr_lead_ref_c,
leads_cstm.`jr_lead_dob_c` AS leads_cstm_jr_lead_dob_c,
leads_cstm.`jr_lead_nationality_c` AS leads_cstm_jr_lead_nationality_c,
leads_cstm.`jr_lead_fees_c` AS leads_cstm_jr_lead_fees_c
FROM
`leads` leads,
`leads_cstm` leads_cstm
WHERE
leads.id = leads_cstm.id_c
and leads_cstm.`jr_lead_ref_c` = $P{client_ref}


If I run the report via ireport I get the result.

I uploaded the report to Sugar CRM OS 4.5.1b using Zuckerreport module. I have created a parameter with the Friendly name to be Client Ref and Default name to be jr_lead_ref. I have assigned this parameter to a report and bind it to the lead module. I also tried to bind it to the custom field table.

Unfortunately, I am getting no results, using the exact parameter value i used via ireport.

Any help appreciated.

regards
--
Savyn

[kasolg]

Hi Savyn

Check again the parameter in the sugar, it has to be the same name as it is in the ireport.So change the default name to client_ref.

[SVydelingum]

Hi Kasolg,

Thank you, I got it to work by following your instruction.

amazing

Thanks
--
Savyn