Memento Desktop Beta 1.3.0 - Reports, Print, PDF

[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:

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

[TecnoAdobe MX]

I already found how to make the reports, sorry

[Bill Crews]

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]

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:

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

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

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

[John C]

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]

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]

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]

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]

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:

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

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

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

[Idan Elingold]

What else is new in 1.3.0? for the pepole who are not in the beta testers.

[IVAN VERACRUZ]

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]

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:

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

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

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

[Bill Crews]

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]

Now when I try to print a forms report of my 8 guitar guitar collection I get this:

[John C]

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

[admin]

Hello, John!

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

[Cor Burger]

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:

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

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

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

[John C]

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]

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]

GOOD ONE! Worked perfect. Thanks!

[andrea Cocchi]

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:

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

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

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

[John C]

Try.

[admin]

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.
  

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

[Cor Burger]

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.

[Rogério Penna]

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]

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]

Is there any possibility to have Jasper Reports functionality in Mobile app coming up anytime soon ?

Kindly let us know

[Bill Crews]

Excellent tip! Thanks from all of us, I think. Certainly from me.

[admin]

Hello everyone!

Version 1.3.0 moved to production!

[admin]

Unfortunately, the Mobile app won't support reports in the near future.

[admin]

Sorry, I meant "Mobile app".

[Aaron Dahl]

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.

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.

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

[Aaron Dahl]

For others looking for information on the Jasper Reports and preparing reports that contain images as part of the data set, I have learned the following:

1. Jaspersoft Studio is a free software (look for Community Edition), the free application is available here: https://community.jaspersoft.com/project/jaspersoft-studio/releases

2. The images field have to be treated as an ArrayList because MDB permits more than one image in the field, use "java.util.ArrayList" as your java class. (thanks Vasya)

3. When inserting image you need to use the field code: $F{Image_Field_Name}.get(0) this will result in the first image in the field (if you have more than one, use get(1) for second, get(2) for third..)

This Jaspersoft Studio is robust but fairly easy to figure out and permits complete customization for reporting purposes directly from Memento Database. Only time will tell what we're going to be able to produce here.

Cheers!

[A.R. Jamal]

Hello, were you able to figure it out as to how to make a subreport of a linked fields?

Any help is highly appreciated, Thank you! 

[A.R. Jamal]

Hello, Can I get some sample file? I think that's what I want to do. 

Any advice is highly appreciated, Thank you!

[A.R. Jamal]

Hello, How can I make a field which has a relationship with some other library in Jasper?

Waiting for the reply as I want to create a report but unable to add fields with relationship.

Thanks.

[serge pecher]

Hello,

Already more info about this topic? Jasper reports looks very promising, but without any help, can't figure out how to use it...

Thanks to all

Serge

[RulliDB]

Did you manage to find a solution for linked entries with Jasper?

I would like to have a table with the sublibrary connected to the main library (an invoce with articles).

Is that possibile?

[Bill Crews]

I have very little experience with the desktop edition of Memento and zero experience with JasperSoft Reports, which is why I haven't responded. I truly have no idea.

I can't speak for others who may have this experience and why they are not responding to your messages.

--
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 on the web visit https://groups.google.com/d/msgid/mementodatabase/333dd3c1-27aa-429c-8c59-57faff3c5286n%40googlegroups.com.

[Alessandro Evangelista]

Thank you for the answer Bill. So you don't do report? Or you use Google Docs template? In this case i were able to create a table of linked entries, but not the attributes of the linked entries, how to di that? 

[Bill Crews]

I don't understand the question. I have used JasperSoft only a couple of times, just to check it out. I know very little.

By Google Docs template, I guess you mean to get reports by linking a report library in report format to my database and exporting or syncing that to Google Docs? I've done more of that than JasperSoft, but to be honest, still very little. I just use entry view/edit and the list & card views for everything. My needs are immediate, and I'm the only user/viewer of my data, though sometimes I'll export to a sheet to show some of what's in my database to my doctor or lawyer or contractor or someone like that.

As for link attributes, here's my wiki page for those from a few years ago. It's about all I know about them...

https://wiki.mementodatabase.com/index.php/Attributes_of_linked_entries

[Alessandro Evangelista]

Thank you si much for your work, i see that you did with passion and is very valuable.

Unfortunately this is not helping for my case. I would like to create pdf (invoice) out of entries of sales, in each sale there are different products that are linked entries with attributes (like quantity or color). 

I know that this is possible with a jasper template like giving the same name of the variables, but for linked entries doesn't work the sintax with the dot.

May I ask you were I can find some documentation? It's incredible that such a software doesn't provide an help or some detailed information. 

[Bill Crews]

I'm sorry I have no knowledge of JasperSoft.

As for accessing link attributes from a JavaScript or Calculation field, I've never heard from anyone that the wiki page is in error.

Please export your libraries to a template file attached to your reply. This can be done with a single export if you check the box to include linked libraries in the template. I suggest checking all boxes, but at least that one. In the mobile edition of Memento, you get to library export in the Edit Library screen's right-side menu at the top. I don't know how to do it on a PC.

If that doesn't work for some reason, you could send me links to each of your linked libraries, but the template would work better. If you don't want to send your real invoice data, just check the box in the export for structure only, not the one to include data.

It's more trouble for me, but if the above is not possible or if you don't want to do that, I mainly need to know...

1. how you link your libraries -- from the invoice to the items or from the items to the invoice.

2. the definition of your link attributes within the Link to Entry field edit card within your Edit Library screen, including the attribute definitions.

3. the script you're trying to use to access the attributes, particularly the line or lines that specifically reference the attributes. I use JavaScript, but if you insist to use a Calculation field, I'll do my best to solve the problem, though I never use Calculation fields myself.

With your libraries and any luck, I can recreate your problem on my device, experience the errors, and determine a solution for you.

[Alessandro Evangelista]

Hi Bill, 

Your are very kind! Thank you :)

I emailed the support of memento, and I discovered that linked entries can’t be added with Jasper. They told me that in the next release this will be fixed (the said 2-3 month by now).

So for sure it can’t be done with JasperSoft… But with Google Docs Template it can be done, but I didn’t see the way to insert the attributes in the Table of linked fields (here the doc: https://help.mementodatabase.com/?ht_kb=copying-to-google-docs).

[Bill Crews]

I never investigated Google Dogs templates for Memento. Thank you for introducing them to me. I'll check them out further.