Page 2 of 2

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Fri Jan 11, 2019 8:25 pm
by JeffLaB9
I was able to get the "Today.AddDays()" expression to work as intended, however I wasn't sure if there was a better option.


Ideally, I would like to know if there is a variable or some expression that could post the query date range? So if I pull a report for 01/01/19 to 01/15/19, it would show that date range? This information wouldn't be a part of the database, so that's why I wasn't sure if there is a way to trigger the query date ranges?

I'm not sure if this makes a difference, but my Stimulsoft program appears to be attached to our supply chain management software.

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Sun Jan 13, 2019 9:49 pm
by Lech Kulikowski
Hello,

Sorry, maybe we did not exactly understand your question.

You can use variables with expression or with values from the database as a date range.

Thank you.

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Mon Jan 14, 2019 5:27 pm
by JeffLaB9
The above attachments should be able to work for this. I am just trying to have the report show the query date range.

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Tue Jan 15, 2019 10:49 pm
by Lech Kulikowski
Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Wed Jan 16, 2019 8:38 pm
by JeffLaB9
I'm not sure if I would be able to represent this in test data or not.

We have Stimulsoft as a 3rd party program on our inventory management software. Within our inventory management software's reporting, I will query dates "01/01/19 to 01/14/19", is there a way to identify what the query date range was on the report?

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Thu Jan 17, 2019 11:34 am
by Lech Kulikowski
Hello,

In this case, you should send the request to your programs developers. We do not know how the query is provided in your report.

Thank you.

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Fri Jan 18, 2019 12:16 pm
by JeffLaB9
Alright, thank you again for all of your help

Re: Summarizing or merging duplicate lines with cumulative "Quantity" value

Posted: Fri Jan 18, 2019 2:58 pm
by Lech Kulikowski
Hello

We are always glad to help you!

Thank you.