Question
Hopkins Software Pvt. Ltd.
IN
Last activity: 14 Apr 2023 7:28 EDT
How to shows assignments in different tables Today Table, Yesterday Table, Last 7 Days And Last 30 Days
Hi Everyone,
My Requirement is to show the assignment details in different tables
1. Todays Assignments table - show Todays opened Assignments Details
2.Yesterdays Assignments table - show Yesterday opened Assignments Details
3.Last 7 Days Assignments Table - show last 7 days opened Assignments Details
4.Last 30 Days Assignments Table - show last 30 days opened Assignments Details
Accepted Solution
Updated: 14 Apr 2023 7:25 EDT
Evonsys
IN
Maantic
IN
Hello @NagarjunaS16644648,
I am assuming you want to display the assignments based on the assignment creation date. You can create a section with different table layouts per your need and invoke the corresponding report definitions(Assignment Class) as the source and with the filter as the pxCreateDateTime as Today/Yesterday/Last 7 Days/Last 30 Days
Hopkins Software Pvt. Ltd.
IN
@GitarthaD33 . Thanks for your response. I have small doubt we have create 4 report definitions for 4 tables or 1 RD is enough
Evonsys
IN
@NAGARJUNA Saidu you can have 4 Report Definitions and make use of the Time periods in the select values-> Year wise, month wise, Days wise etc. You can use 4 different RDs in 4 different tables.
Or Create a data page, sourced with 4 of these RDs. When user selects any 1 option, use that option as the when condition to decide which RD to run and give results. And use this dpage with list structure as source to the table layout. This is for reuse purpose.
Above 2 approaches are for displaying records in the table layout in the UI. Below one just mentioning for you to know we have this approach also.
If you are enabling report definition to the user in the report browser using Shortcut, then just add .pxcreatedatetime as the filter with a parameter. End users can filter the results with Time periods at run time.
Updated: 12 Apr 2023 5:21 EDT
Hopkins Software Pvt. Ltd.
IN
@Anoop Krishna :How to Visualize this tables like below image 
Accepted Solution
Updated: 14 Apr 2023 7:25 EDT
Evonsys
IN
@NAGARJUNA Saidu In the Report definition itself, you have chart option. You can make any column to Summarize-> Count in the query tab. Then you can see many charts there. You can play with those charts and use those charts. Here you will see the count and chart together.
If you want to use charts in section, you have chart control and you can use that in section.
Updated: 14 Apr 2023 7:28 EDT
Hopkins Software Pvt. Ltd.
IN
@Anoop Krishna How to create below things. How to show 19 work Objects Total Appointments
Please Tell me
@NAGARJUNA Saidu In the Report definition itself, you have chart option. You can make any column to Summarize-> Count in the query tab. Then you can see many charts there. You can play with those charts and use those charts. Here you will see the count and chart together.
If you want to use charts in section, you have chart control and you can use that in section.