Hi Amr H.,
Hope you are available to complete small project for me that I need urgently. I have an excel spreadsheet with data and need to create SSRS report.
1 - Load the detail data(WeeklyData and DailyData tabs) into a database table in SQL Server express
2 - Create SSRS report that has two charts - one showing ET DAILY daily data over time (dates on X axis and run duration in hours over the Y axis) and another chart showing the ET WEEKLY data
3 - When there is gab in data meaning that there is a date but status and RunDurationHours have no data then I want to show to highlight that on that day there was no activity (job did not run)
4 - When the status of a row is "Failure" please highlight that in the chart with a red line.
That is. is that something you can help with?
I am attaching the file