OK had a look - totally, completely and utterly lost.
Don't understand where or how it's installed, let alone if it's possible to build a customised report.
I'm looking for some way of designing a PDF output for a given form, with a query parameter to select which submission (based on a certain field) so that a team member can open the report, select a submission and print/email the resulting PDF.
Is that what this does? I'm not looking for BI type graphs/numerical analysis of multiple submissions (I think I have that with Redash), just a friendly way of presenting what was entered on a particular submission.
If you carefully read the post you see that there's a link to the github repository:
There you have the instructions on how to install and how it works.
Through the Shiny app you connect with OData to your submissions.
You can filter these graphically, then you choose the kind of reports you need and you get an html file with the report that can be opened on any browser and print as well.
In the post there's as well a link to a demo on how it works.
Excel could indeed be a good starting point. Its Power Query features wouldn't even require you to use VBA and are relatively easy to use; most things can be done with it already. Plus it can read the OData feed directly. You may then try to develop a spreadsheet that works well with the print layout. Using filters, you may change what the spreadsheet shows in order to generate individual PDFs.
I like to use an intermediate database to store Central's data in a classical relational database and expose it to our other tools (redash for web dashboards, jasper studio for static pdf, QGIS to print map atlases...)
If opensource tools like redash/metabase/superset could have a real ODATA connector which is not only use by Central it would be a great thing.
No I still use Jasper because I have old report templates that still work with it and it is simplier than redevelop.
It depends on your needs, the other tools you use, the workflows that already occur in your organization and your skills (r, python... mine is SQL)
I exposed our use case here : SQL first try to get Central data into internal PostGIS database - #5 by mathieubossaert
I do need to consolidate the data we gather with ODK in a larger database, which contains a lot of other data to "join" to.
I could manage to directly query Central's database, but logically, the "guaranteed" interface to Central is its API.
So I started to get data out from Central into our PostGIS database schemas through the API.
And now, as other users, I see and use ODK Central as a whole independent tool (even if it uses an internal PostgreSQL database) I query through its great API
Update for anyone interested - it's taken me a VERY long time but I've been able to use the Central API to get whatever I want from Central, with the exception of images/attachments.
I had to use the API to start a session, obtain a token, use the token to access the data and place in my report. I haven't done anything as sophisticated as writing a proper query yet or used parameters (except for the token itself) but it appears to work reliably.
I've hit a wall though with importing images - I can construct the URL to an image pretty easily but Jasper doesn't have the ability to enter HTTP headers when requesting the image, so I can't give it the token. Any ideas?!
That sounds really promising but I think is probably waaaay over my experience level. I looked at R when trying to find a decent reporting tool but read lots of scary stories of R being one of the toughest computer languages to learn. Am I wrong? If so, any good places to start?
I've never done any SQL, java or anything and literally just know the basics of what a database is, what tables are etc.
Just had a look at the bits and bobs you refer to - ouch, my head is hurting already!
I'm not seeing the bit I need though - an easy way to publish reports so my team can go to an intranet address, choose a report, input any parameters and run the report - this is what Jasper offers but it looks like R will only give me RStudio Connect, which is costly.
What you describe here is a dashboard with user inputs as parameters for analysis and visualisation. In R, the prime technology for that is https://shiny.rstudio.com/
You are not limited to hosting RShiny apps on RStudio Connect, you can host it yourself using Shiny Server, or deploy via Docker images.
https://github.com/SwissTPH/repvisforODK is a nice generic RShiny dashboard that lets your users build and export their own reports. Ping to the developer @lucidviews and his colleague @Thalie for more help. Following the README will get the repvisforODK app running on your own machine, which should be enough to evaluate.
Google Data Studio allows controls to capture user input, so that might be another approach.
Ping to the developer @samlevy for more help.