Change report from Date to days of the week

[jobina.barter]

Hi Everyone

I'm new to using Jaspersoft reports with CA PPM. I am trying to create a report similar to timesheet detail that will show the breakdown similar to the out of box report - how do I get the days of the week vs dates? This is through the advanced reporting.  Do I need to use Jaspersoft Studio?

 

[m.kamran]

Hi Jobina,

I would recommend handling the "day of the week" part withn your SQL script since jasper does not have a direct way (though you could make it work using conditionals but that would be a tedious approach). Here's how you would do it if using SQL server,

https://docs.microsoft.com/en-us/sql/t-sql/functions/day-transact-sql

but of course all DBMS's have functions available which would output DAY based on given date.

Hope it helps.

Thanks.