Memento Desktop Beta 1.3.0 - Reports, Print, PDF

1509 views
Skip to first unread message

admin

unread,
Mar 6, 2018, 9:48:22 AM3/6/18
to memento...@googlegroups.com

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.


You can download the Desktop app from the following URLs:

Win64: http://mementodatabase.com/download/mementodb-1.3.0-win64.exe

Win32: http://mementodatabase.com/download/mementodb-1.3.0-win.exe

Java: http://mementodatabase.com/download/mementodb-1.3.0-jar.zip


There are now 3 types of reports possible for creation:

  • The table report. Data is shown in a tableview, the fields shown, grouping and aggregation can be chosen manually;

  • The form report. Printing the record card, when each card is printed on a separate sheet;

  • The custom report. The most adjustable and a bit sophisticated. The template needed is created in a separate application, which is called Jaspersoft Studio. It will be just right for the advanced users or the people familiar with Jaspersoft Studio.


Creating reports with Jaspersoft Studio:

0. Download and install Jaspersoft Studio

  1. Create a new report. Choose Data Adapter- One Empty Record as the Data source.There is no suitable data source for Memento for the time being, you won't get the list of fields or the preview data.

  2. Create fields with the same names as in Memento. Jaspersoft Studio displays report’s fields as children of the Fields node in the document outline view. To create a field, right-click the Fields node and select Create Field. On the field properties tab, select the appropriate field class for the field type in Memento. See the table on the wiki: http://wiki.mementodatabase.com/index.php/JaspersoftStudio

  3. Move the fields to the report area - Detail.

  4. Save the template in a jrxml file

  5. Choose this jrxml file when creating the Jasper report in Memento.


Download JasperSoft Studio: https://community.jaspersoft.com/project/jaspersoft-studio/releases

JasperSoft Studio work documentation:  https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/getting-started-jaspersoft-studio


Best regards,

The Memento team

Message has been deleted

TecnoAdobe MX

unread,
Mar 9, 2018, 7:30:02 PM3/9/18
to mementodatabase
I already found how to make the reports, sorry

Bill Crews

unread,
Mar 9, 2018, 9:56:46 PM3/9/18
to TecnoAdobe MX, mementodatabase
On the bar at the top and middle of the screen, there is now a printer icon. Press it to get things started.

I'll be adding wiki pages once I've had a chance to get to know Jaspersoft Studio better.

John C

unread,
Mar 11, 2018, 4:20:15 PM3/11/18
to mementodatabase
oh how wonderful. thank you.


On Tuesday, March 6, 2018 at 9:48:22 AM UTC-5, admin wrote:

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.


You can download the Desktop app from the following URLs:

John C

unread,
Mar 11, 2018, 5:36:31 PM3/11/18
to mementodatabase


This works absolutely beautiful for me right now. My boss is going to be happy with his new report.

1) After choosing the fields there needs to be a way to move them up or down. One mistake and you must select them all over
2)  I noticed on the mouse hover it says, report/export but there doesn't seem to be an export option.

I know this is a beta just thought I'd throw out some observations.

I also know Bill isn't responsible for this but I just thought he'd want to know.

J

Bill Crews

unread,
Mar 11, 2018, 7:04:12 PM3/11/18
to John Cesta, mementodatabase
I may be on my own to write wiki pages for this. In addition to my own experience playing with it, I'll have the Jaspersoft docs to use, but other than that, any input I can get from this forum would be useful.

John C

unread,
Mar 13, 2018, 1:35:15 PM3/13/18
to mementodatabase
I don't want to go thru the process with the jasper software download but does anyone know what the cost is? I'm just a one man show so I would never need a server based option.

Bill Crews

unread,
Mar 13, 2018, 1:39:30 PM3/13/18
to John Cesta, mementodatabase
The software is free. The only thing server-based about it that I know of is that it works on the Memento desktop edition only, so you need to be able to operate in that environment, which is integral to the Memento Cloud.

Dave Run

unread,
Mar 14, 2018, 9:18:08 PM3/14/18
to mementodatabase

Thank you,

  This is great news, I have managed to get my own custom Jasper Reports working, once you figure out the layout its fairly easy, 100% customizable!!  Just have not figured out how to get an image field to display, Idea?


DH 



 
On Tuesday, March 6, 2018 at 7:48:22 AM UTC-7, admin wrote:

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.


You can download the Desktop app from the following URLs:

Idan Elingold

unread,
Mar 15, 2018, 9:44:23 AM3/15/18
to mementodatabase
What else is new in 1.3.0? for the pepole who are not in the beta testers.

IVAN VERACRUZ

unread,
Mar 16, 2018, 12:23:09 PM3/16/18
to mementodatabase
good afternoon,

I have only tried to print on the table report and forms report.
My question is the following:
In the fields barcode and qrcode, you can print the image of the barcode or qr and not print the text that contains the code.
for daily use it is very important, just as it is very practical to be able to search by reading the barcode is equally important to be able to print it to read it.

The photographs if included to print them.

a greeting

Ivan

John C

unread,
Mar 19, 2018, 9:17:32 AM3/19/18
to mementodatabase
Today I eas testing out the reports. I have about 25 records in my pseudo journal. When I used a table report the images came out as thumbnails.

So I tried a forms report with one record. The image came out ok. So I tried the entire range of records. I got this message.



On Tuesday, March 6, 2018 at 9:48:22 AM UTC-5, admin wrote:

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.


You can download the Desktop app from the following URLs:

jasper template.png
jasper report message.png

Bill Crews

unread,
Mar 19, 2018, 9:28:04 AM3/19/18
to John Cesta, mementodatabase
Well, I don't know much, but I know that, in general when talking about dynamic programming languages, GC means the "Garbage Collector". This is analogous to the Heap in older programming languages.

Bottom line, I think the default installation of Java on your platformneeds to have a setting tweaked that extends the resources given to the garbage collector. Unfortunately, I don't know how to do that. I would start skulking around within the installation to find an XML or other text file or something with some kind of settings, properties, parameters, or configuration  name.

John C

unread,
Mar 19, 2018, 10:24:56 AM3/19/18
to mementodatabase
Now when I try to print a forms report of my 8 guitar guitar collection I get this:

John C

unread,
Mar 19, 2018, 1:10:18 PM3/19/18
to mementodatabase

I am just throwing these things up in order to assist as a beta tester.

admin

unread,
Mar 19, 2018, 3:54:04 PM3/19/18
to mementodatabase
Hello, John!

Thank you for the bug reports, I will try to fix it.

Cor Burger

unread,
Mar 24, 2018, 6:58:32 AM3/24/18
to mementodatabase

When creating a report, i see to many decimals. Can I changes the format? 



Op dinsdag 6 maart 2018 15:48:22 UTC+1 schreef admin:

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.


You can download the Desktop app from the following URLs:

Mementoreport.JPG

John C

unread,
Mar 24, 2018, 8:09:36 AM3/24/18
to mementodatabase
I get that too. Can't figure it out. Something to do with some other fields being summed up having decimal places.

The other thing about the design of the report is that there is a need to be able to move the report fields up and down after selecting them. Or we have to remove them all and start over again.

Cor Burger

unread,
Mar 25, 2018, 10:10:56 AM3/25/18
to mementodatabase
I solved it with a calculation, there I used the function "round". Example:
round (# {total pieces} / # {pieces per m2} * 100) / 100.
In this way you get 2 decimals.

Op zaterdag 24 maart 2018 13:09:36 UTC+1 schreef John C:

John C

unread,
Mar 25, 2018, 2:03:26 PM3/25/18
to mementodatabase
GOOD ONE! Worked perfect. Thanks!

andrea Cocchi

unread,
Mar 29, 2018, 12:35:21 PM3/29/18
to mementodatabase
can I change field name?



Il giorno martedì 6 marzo 2018 15:48:22 UTC+1, admin ha scritto:

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.


You can download the Desktop app from the following URLs:

John C

unread,
Mar 30, 2018, 8:26:10 AM3/30/18
to mementodatabase
Try.

admin

unread,
Mar 30, 2018, 5:06:59 PM3/30/18
to mementodatabase
Hello!

1.3.0 Release Candidate 1 available for testing.

Changelog:
  • Increased speed of loading libraries with script fields.
  • The RichText fields are properly displayed in the reports.
  • Sign in with Google.
  • Added ability to order fields in the reports.

Cor Burger

unread,
Apr 2, 2018, 5:47:30 AM4/2/18
to mementodatabase
In the aggregation Sum in a report I still have to many decimals. How can I control this?


Op dinsdag 6 maart 2018 15:48:22 UTC+1 schreef admin:

Please welcome the new Memento Database desktop beta version, containing reports creating feature. Something that we all have been waiting for :)  More detailed documentation will be ready soon.

Knipsel.JPG
Knipsel2.JPG

Rogério Penna

unread,
Apr 4, 2018, 12:42:32 AM4/4/18
to mementodatabase

Hello. I downloaded the MementoDB desktop version. But I can´t get past install.

On my Notebook, when the login screen appeared, the computer got extremelly slow, like, impossible to use.

Tried on my desktop PC. At Login Screen, I create a new user, but then, it stays forever trying to create a new user... left it ten minutes trying to create a new user but it seemed to never be able to contact the home site.

KK Fashion Exports

unread,
Apr 5, 2018, 6:05:00 AM4/5/18
to mementodatabase
After some efforts I figured out how we can put data in tables in Jasper report.
Actually in Jasper tables use separate datasets.

In table Dataset add new Parameter for each field you want inside table.
Then in main report click on table and in dataset property go to parameters and assign these parameters value of fields in your main dataset.
Then set value of table rows as $P{Parameter name}

Hope this Helps!

KK Fashion Exports

unread,
Apr 5, 2018, 6:06:53 AM4/5/18
to mementodatabase
Is there any possibility to have Jasper Reports functionality in Mobile app coming up anytime soon ?
Kindly let us know

Bill Crews

unread,
Apr 5, 2018, 10:25:48 AM4/5/18
to KK Fashion Exports, mementodatabase
Excellent tip! Thanks from all of us, I think. Certainly from me.

admin

unread,
Apr 7, 2018, 7:15:53 AM4/7/18
to mementodatabase
Hello everyone!


Version 1.3.0 moved to production!

admin

unread,
Apr 7, 2018, 7:16:49 AM4/7/18
to memento...@googlegroups.com
Unfortunately, the Mobile app won't support reports in the near future.

admin

unread,
Apr 7, 2018, 7:32:51 AM4/7/18
to mementodatabase
Sorry, I meant "Mobile app".

Aaron Dahl

unread,
Nov 23, 2018, 8:45:46 PM11/23/18
to mementodatabase
Howdy all!

Now that I've got a (mostly) functional application with a couple users entering data. I need a more streamlined way of generating reports.

Currently, I have several report templates set up in Google Sheets. When we need to produce a report, I sync the data to Google Sheets from my phone, then I fiddle around with the report sheet in Google Sheets, then I finally print to *.pdf (usually for someone else to send out). This process if cumbersome, so I was pleased to learn of this reporting functionality in Memento Database. After fiddling around a bit with the standard Forms Report and Table Report templates, there's just not enough customization here, so I've now downloaded the Jaspersoft Studio. Dismayed by an application that is clearly beyond my skill level, this is clearly a capable program - one I am confident provides the features and capabilities I need to replace this clumsy Google Sheets process.

Currently, I have two hurdles I can't seem to resolve:

1. The relationship of my libraries is a parent-child type. I need select one Report to print, within each report are many Activity Items (sub entries of this particular report), there is actually an option in the MDB print option for "linked tables", but I cannot seem to create a similar sub-level entry in Jasper.

Capture.JPG

I have tried creating a field #{Report ID.Activity Title} similar to a calculation field, but this is not working, and I'm just stabbing in the dark here.


2. The records in my Activities library include photos from project sites and I need to produce these images within the report template, but I see no such Class option in Jasper (i.e. java.lang.Image) format for image.

Capture2.JPG


There are some YouTube videos on the Jaspersoft Studio that I am beginning to watch, but much of the direction is not relative to what we need to do for MDB. It's certainly a bit difficult since I cannot use the preview page of Jaspersoft. Anyone who has a good source for creating more advanced report functions using Jaspersoft as it would relate to Memento Database would be greatly appreciated.


Thanks,

/ad