You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create a report to show latest status and previous status

Received Response


Hi Community,

There is a requirement to create a report which should basically identify the date the SR was set to the previous status, followed by the date the SR was set to ‘Customer Responded’ or ‘Third Party Responded’. As a result, the fields should look like this:

I am trying to use transaction_table and incident table both to prepare the report however i am not clear as to how we can display the later part of the information like Date SR changed to Third party & the latest status.

Any help is appreciated, Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!