Unable to set time period in reports
Moderator: Renato
Unable to set time period in reports
Hello everyone, I'm writing from Italy, forgive my bad English, I use google traslator: o)
In the reports it is not possible to indicate a period of dates, from date to date, other than those proposed in the system, I wanted to know how you can enter a time period example: 01/01/2020 - 31/01/2020 thanks to all .Re: Unable to set time period in reports
I'm assuming you are using v1.3.3
It's not possible in v1.3.3
It was to be a feature in v1.4.x which is still in development
I'm not sure if they've put that feature into v1.3.4 release that is now availabe.
It's not possible in v1.3.3
It was to be a feature in v1.4.x which is still in development
I'm not sure if they've put that feature into v1.3.4 release that is now availabe.
-
- Senior User
- Posts: 31
- Joined: Tue Jun 12, 2018 3:36 am
- Are you a spam bot?: No
Re: Unable to set time period in reports
I cannot see the feature in the 1.3.4 beta release I downloaded on 09MAR2020 and am currently using. However in the HELP notes for the General Report Manager in the 1.3.4 beta I see the sentence below which says that the feature is going to be in the 1.4 release.
For MMEX version 1.4.0 there is a possibility to transfer dates into a report's SQL script.There are six options available: &single_date, &begin_date, &end_date, &budget_years, &fin_year_day, &fin_year_month. In case if a SQL contains one of the parameter above it will be replaced with a date from a calendar widget or a value from the MMEX settings.
For MMEX version 1.4.0 there is a possibility to transfer dates into a report's SQL script.There are six options available: &single_date, &begin_date, &end_date, &budget_years, &fin_year_day, &fin_year_month. In case if a SQL contains one of the parameter above it will be replaced with a date from a calendar widget or a value from the MMEX settings.
Re: Unable to set time period in reports
Hi, that is for General Report Writer for when writing your own reports in v1.4.x
This is one of the standard reports from v1.4.x - hopefully the developers will finish it off soon or pull the functionality into v1.3.4+
This is one of the standard reports from v1.4.x - hopefully the developers will finish it off soon or pull the functionality into v1.3.4+
-
- New User
- Posts: 5
- Joined: Thu Mar 26, 2020 5:24 pm
- Are you a spam bot?: No
Re: Unable to set time period in reports
Thanks, that works! I was simulating a return on investment plan for some real estate in Cannes for my boss, and I had issues with the time periods as well...
Last edited by Tanker5455 on Mon Apr 20, 2020 5:41 am, edited 1 time in total.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Unable to set time period in reports
In v1.3.4 it would be possible as well.
Re: Unable to set time period in reports
Hi Nikolay
Are you saying the parameters can be put into 1.3.4 custom reports as per 1.4.x ?
Is there a full list of the parameters?
Are you saying the parameters can be put into 1.3.4 custom reports as per 1.4.x ?
Is there a full list of the parameters?
-
- Senior User
- Posts: 31
- Joined: Tue Jun 12, 2018 3:36 am
- Are you a spam bot?: No
Re: Unable to set time period in reports
I downloaded MMEX v1.3.4.rc.3 earlier today. I discovered that you can now set the time period in a number of custom reports. There is a new option called "Custom" listed after the "Last 365 Days" selection and once you select "Custom" the two date fields containing calendar widgets which were previously grayed out are no longer grayed out and allow you to set the time period to anything you like. This capability to specify "Custom" is added to all the custom reports (Categories, Payees, Income vs Expenses). This is a welcome addition which makes these custom reports twice as useful as they were before, Thanks to the MMEX developers for this fine addition to the product.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Unable to set time period in reports
There is a sample sql in the help page with &single_date variable.