29
Views
4
Comments
Sales Report
Question

Hi Everyone, I'm going to ask again how to connect the date picker range to the new screen. I want to create a sales report for weekly, monthly, and annual sales report that is connected to the calendar. If the calendar is clicked, the sales report should also work. Thank you so much 



Screenshot 2024-11-23 143314.png
Screenshot 2024-11-23 143512.png
2019-01-31 08-54-57
André Costa
Champion

Hi @Melvin Placer 

Can you elaborate more what are you trying to accomplish technically?

AC

2023-01-26 16-03-24
Ana Agostinho

Hello Melvin Placer,

Are you asking how to implement a date picker? If so, have you already checked the documentation pages for that widget?

If you have any questions, please don't hesitate to ask.

Best regards,
Ana

2024-09-12 02-43-38
Deepsagar Dubey

Hello @Melvin Placer 

Create 2 local variables in your screen (i.e. PickedStartDate and PickedEndDate) and select Date as the Data Type. 

then you can give a default value to these 2 variables lets suppose today date so now your both variable have today date, then in your aggregate named GetSalesReport use these two variable to filter, (based on your entity attribute)

Example -

    Order.CreatedOn >= PickedStartDate 

    Order.CreatedOn <= PickedEndDate 

 

then create a new client action to handle DatePickerRange on selected event.

Inside the client action assign the selected values to your local variables and after that refresh your aggregate, so it'll filter according to new values.

 

I hope it'll help you.

Thanks
Deep

2018-10-04 11-30-51
glenn michiels

Rather than asking the same question without further explanation in a new post it would be more progressive if you were to provide further details on your actual question or answer those who wish to help you.

If you are unable to find your previous post I'll link it below.
(Original post: https://www.outsystems.com/forums/discussion/100392/sales-report-for-weekly-monthly-and-yearly-transaction/)

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.