MMEX Discussion Forum

Hi
I am attempting to create a dynamic custom report (`.grm`) where the user must input a date range before the report runs.
Is it possible creating a report from scratch using GRM feature in MMEx?
Is it possible to force a date input dialog (like the one triggered by `DATE_PARAMETERS=1 or another`) in the GRM?
If so, what is the exact variable syntax (SQL, Lua, or special tag) that must be used to ensure the dates selected by the user are correctly passed to the SQL query?
Thank you for your time and support.

I can't help much because I rarely use GRM.
But I can provide you with a report that has a date entry and a report that lists the existing variables (current?).

Hi,
Is the info in General Report Manager insufficient ?
Like using those options available : &single_date, &begin_date, &end_date in where parameters of the SQL

where TRANSCODE = 'Transfer'
and STATUS <> 'V'
and TRANSDATE <= '&single_date'

Is this what you are looking for ?

Fern

Hi @Renato and @FernVeilleux
Thank you both for your help. Finally, I have managed to get the report working.
Indeed, the information provided in the Help section was enough and exactly what I needed, but it seems wasn't working initially because of how I was testing it. After importing and running the report provided by Renato from the Navigator menu (instead of trying to run it directly from the GRM editor), I adjusted my SQL using the standard parameters (&begin_date, &end_date) and it worked perfectly.

By the way, I found testing this type of report using (&begin_date, &end_date) an 'ASSERT INFO' error, which seems to be a known issue for Linux MMEx users, related to wxWidgets and Wayland/X11 compatibility. However, I can bypass it by clicking 'Continue', and the report displays correctly after that.
Attached the error just in case someone want to check it.

Thanks again,
Eduardo