Summarizing or merging duplicate lines with cumulative "Quantity" value
Re: Summarizing or merging duplicate lines with cumulative "Quantity" value
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.
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.
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Summarizing or merging duplicate lines with cumulative "Quantity" value
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.
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
The above attachments should be able to work for this. I am just trying to have the report show the query date range.
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Summarizing or merging duplicate lines with cumulative "Quantity" value
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
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
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?
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?
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Summarizing or merging duplicate lines with cumulative "Quantity" value
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.
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
Alright, thank you again for all of your help
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Summarizing or merging duplicate lines with cumulative "Quantity" value
Hello
We are always glad to help you!
Thank you.
We are always glad to help you!
Thank you.