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.