Generating Reports with Data from Unlinked Forms in Zoho Creator

Generating Reports with Data from Unlinked Forms in Zoho Creator

Hello Zoho Creator Community,

I'm facing a challenge in creating a comprehensive report. I have multiple forms in my application, but they are not directly linked through lookup relationships.

I need to generate a report that includes data from these unlinked forms. My goal is to export this report as a PDF using a custom template.

Is this possible within Zoho Creator?

If so, could you please guide me on the following:

  1. Data Retrieval: How can I effectively retrieve data from multiple unlinked forms for inclusion in the report?
  2. Report Design: What are the best practices for designing a report that efficiently displays data from diverse sources?
  3. PDF Export: How can I customize a PDF template to accurately represent the data from the report and achieve the desired layout?

Any advice, suggestions, or workarounds would be greatly appreciated.

Thank you in advance for your time and assistance.