How to change the date range in the custom report automatically?

Garry · July 10, 2016, 9:35am

Hello!

I need some help from guru please. Here is my simple report:

Here is a simple action that prints out this report to a file:

Everything is good, but by default SambaPOS sets the date range to “Today”. As a result, there is only the short version of this report into a file (for today only).
How can I force SambaPOS to change the date range to “This Month” automatically?
I mean without changing it manually on the Reports Screen or without using SQL script.
The box “Parameters” at the screenshot (red arrow) doesn’t work for this purpose.

Thank you!

Jesse · July 10, 2016, 11:04am

Are you opening and closing Work Periods?

Garry · July 10, 2016, 1:03pm

Every morning we open WP and every evening we close it.
When I open this report manually in Reports, it works perfectly and I can see the whole month revenue per day.

Jesse · July 10, 2016, 3:23pm

Are you trying to save it to a file?

Parameters section of action is not for defining date range its so you can pass parameters to the report. Try leaving that blank.

If you want to use it then define it as a variable and set your parameter in the rule.

Garry · July 11, 2016, 4:45am

Thank you for your response!
Yes, it can be printed out of course.
But the question was not “how to print”. My question was how to force SambaPOS to change the date range while it is printing this report.
Now I have this result:

But I need this one:

So what should I do in order to SambaPOS makes this report for whole month but not only “for today”?

emre · July 11, 2016, 9:19am

Try setting report name as:

Daily Revenue Report:This Month

Garry · July 11, 2016, 12:51pm

Thank you for your replay, Emre!

I’ve tried, but now I’ve got an interesting issue
The destination file is empty, and if I try to open this report manually from Reports - I get “non-stop-working” until I close SambaPOS.
As you can see at this screenshot - the date range on the left side is correct (= this month), but on the right side there are something wrong.

emre · July 11, 2016, 12:55pm

No I didn’t said rename report lol. By report name I was referring to report name parameter.

Garry · July 11, 2016, 2:43pm

Oh…
Sorry, I didn’t understand you!

Thank you very much, Emre! Now it works perfectly!
That is the correct solution of this issue:

Thank you again for your help, Emre!

emre · July 11, 2016, 2:56pm

For next update (.61) I added Date Range parameter to make it more clear. Adding it in Report Name will also keep working.