Reporting with Multiple Entries

[Alex MacKenzie]

I have a deficiency tracker that I'm trying to write report for. I'm not very fluent with Jasper Reports. I do have it installed on my desktop. I can run a very simple report that gives me a report on a single entry.

But I would like to create a summative report with all items together on one sheet.

Field One - UNIT - (integer)

Field Two - TRADE - (multiselect)

Field Three - DEFICIENCY - (text)

Field Four - ROOM (multiselect)

I'd like to be able to either generate reports straight from phone - sending the items to a Google Docs template and have multiple entries show up together on a single google doc report. OR create a custom Jasper report, again, showing multiple entries on a single report.

I've had great success using Google Sheets and Query language to create reports in google sheets. I'm trying to simplify the process for fellow coworkers. 

Can anyone help?

Desired output would be something like:

Unit: 201 (single reference, although all entries on this particular report would share this unit number)

Room: Bedroom

• • scratch on floor board
  • paint touch up at door frame
  • missing electrical coverplate.

That report would pull from memento where its more like:

201 Bedroom Scratch on floor board

201 Bedroom paint touch up at door frame

201 Bedroom missing electrical coverplate

Currently looking at thousands of items over a 400+ units....

Thanks for the help.

[Mmm]

Предположу, что самое простое решение — дополнительная библиотека отчетов. 

Скриптом из основной библиотеки создавать сводный отчёт и сохранять его в дополнительной библиотеке в виде отдельной записи. 

Как сделать отчёт из одной записи, Вы знаете. 

вторник, 13 мая 2025 г. в 23:57:13 UTC+3, macke...@gmail.com:

[Er Mo]

Hallo
Du musst die einen Filter in der Bibliothek einrichten der das Anzeigt was du im Bericht haben willst . Im Bericht auf Tabellenansicht gehen und nach Zimmernummer Gruppiren .

Ps. Du kannst nur in der PC Version Berichte Drucken

Hello
You need to set up a filter in the library that displays what you want in the report. In the report, go to table view and group by room number.

P.S. You can only print reports in the PC version.

Ernst

[Alex MacKenzie]

Thank you Er Mo,

I had previously overlooked the group by tab in the table report structure. Thank you for bringing that to my attention.

I'm trying to find a way to generate the summative reports using a google docs template, so that, inexperienced users can generate everything from a mobile device, phone or tablet, and not be required to have the desktop running.

From what I can tell that isn't possible yet...

Alex MacKenzie

647 818 5543

--
You received this message because you are subscribed to the Google Groups "mementodatabase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mementodataba...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/mementodatabase/4de73c68-5fea-42d3-99ef-f234800ea8a2n%40googlegroups.com.