{"id":97345,"date":"2022-01-03T16:30:25","date_gmt":"2022-01-03T14:30:25","guid":{"rendered":"https:\/\/churchtools.academy\/help\/non-knowledgebase\/uncategorized\/can-i-create-or-customize-ad-hoc-reports\/"},"modified":"2026-10-02T10:36:57","modified_gmt":"2026-10-02T08:36:57","password":"","slug":"can-i-create-or-customize-ad-hoc-reports","status":"publish","type":"docs","link":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/can-i-create-or-customize-ad-hoc-reports\/","title":{"rendered":"Can I create or customize ad hoc reports?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">An ad hoc report is based on an SQL query. SQL stands for <em>Structured Query Language<\/em> and accesses the database directly. This allows any field in ChurchTools to be used for ad hoc reports.  <\/p>\n\n<p class=\"wp-block-paragraph\">Existing ad hoc reports cannot be customized on your own, since this requires access to the database; for the same reason, you also cannot create your own ad hoc reports.<\/p>\n\n<p class=\"wp-block-paragraph\">If you need a new report or would like to have an existing report customized, please feel free to contact our <a href=\"https:\/\/contact.church.tools\/contact\">support team<\/a> to discuss your options directly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>An ad hoc report is based on an SQL query. SQL stands for Structured Query Language and accesses the database directly. This allows any field in ChurchTools to be used for ad hoc reports. Existing ad hoc reports cannot be customized on your own, since this requires access to the database; for the same reason, [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"doc_category":[494],"doc_tag":[653],"knowledge_base":[224],"class_list":["post-97345","docs","type-docs","status-publish","hentry","doc_category-adhoc-reports-en","doc_tag-content-outdated-en","knowledge_base-churchtools-modules"],"pp_statuses_selecting_workflow":false,"pp_workflow_action":"current","pp_status_selection":"publish","pp_force_visibility":null,"pp_subpost_visibility":null,"pp_inherited_force_visibility":null,"pp_inherited_subpost_visibility":null,"acf":[],"year_month":"2026-10","word_count":92,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Victoria Weidemann","author_nicename":"vweidemann","author_url":"https:\/\/churchtools.academy\/en\/author\/vweidemann\/"},"doc_category_info":[{"term_name":"AdHoc-Reports","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/adhoc-reports-en\/"}],"doc_tag_info":[{"term_name":"Content outdated","term_url":"https:\/\/churchtools.academy\/en\/docs-tag\/content-outdated-en\/"}],"knowledge_base_info":[{"term_name":"Modules","term_url":"https:\/\/churchtools.academy\/en\/help\/churchtools-modules\/","term_slug":"churchtools-modules"}],"knowledge_base_slug":["churchtools-modules"],"_links":{"self":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/comments?post=97345"}],"version-history":[{"count":3,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97345\/revisions"}],"predecessor-version":[{"id":97348,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/docs\/97345\/revisions\/97348"}],"wp:attachment":[{"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/media?parent=97345"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_category?post=97345"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/doc_tag?post=97345"},{"taxonomy":"knowledge_base","embeddable":true,"href":"https:\/\/churchtools.academy\/en\/wp-json\/wp\/v2\/knowledge_base?post=97345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}