Hi Everyone,
My Requirement is to show the assignment details in different tables
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
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
@GitarthaD33 . Thanks for your response. I have small doubt we have create 4 report definitions for 4 tables or 1 RD is enough
@NagarjunaS16644648 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.
@Anoop Krishna :How to Visualize this tables like below image
@NagarjunaS16644648 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.
@Anoop Krishna How to create below things. How to show 19 work Objects Total Appointments
Please Tell me
