Summarizing or merging duplicate lines with cumulative "Quantity" value

Stimulsoft Reports.NET discussion
JeffLaB9
Posts: 22
Joined: Thu Dec 27, 2018 6:48 pm

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

Post 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.
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post 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.
JeffLaB9
Posts: 22
Joined: Thu Dec 27, 2018 6:48 pm

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

Post 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.
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello,

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

Thank you.
JeffLaB9
Posts: 22
Joined: Thu Dec 27, 2018 6:48 pm

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

Post 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?
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post 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.
JeffLaB9
Posts: 22
Joined: Thu Dec 27, 2018 6:48 pm

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

Post by JeffLaB9 »

Alright, thank you again for all of your help
Lech Kulikowski
Posts: 6247
Joined: Tue Mar 20, 2018 5:34 am

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

Post by Lech Kulikowski »

Hello

We are always glad to help you!

Thank you.
Post Reply