patricia.williams Posted May 13, 2015 Share Posted May 13, 2015 My query runs fine under pgadmin query tool but the dataset and query dialog wizard gives the error. Here's the query select f.filer_ident, f.filer_info_id, r.report_info_ident, r.report_type_cd, r.info_only_flag, to_char(c.contribution_dt,'fmMonth dd, yyyy') as cdate, c.contribution_amount, c.contribution_descr, concat(p.name_last,concat(',',p.name_first)) as name, p.name_organization, p.employer, p.occupation, p.job_title, a.city,a.state_cd, a.postal_codefrom filer_info f left join report_info r on f.filer_info_id = r.filer_info_id and r.info_only_flag != 'Y' and (r.report_type_cd !='SS' and r.report_type_cd not like 'DAILY%') left join contribution_info c on r.report_info_id = c.report_info_id and c.itemize_flag = 'Y' left join contribution_persent cp on c.contribution_info_id=cp.contribution_info_id left join persent_info p on cp.persent_info_id=p.persent_info_id left join persent_address pa on cp.persent_info_id=pa.persent_info_id left join address_info a on pa.address_info_id=a.address_info_idwhere f.filer_info_id=$P{FilerInfoID} order by name Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now