Hi
You can try to use, the custom SQL report that can be created for that.
Go to the reports tree,- create the folder or select existing one and use : right-click -> new -> SQL report.
Try to use this query for tasks with custom scheduling:
Select It.Name, bu.SourceItemGuid, Min(bu.StartTime) as NextRun from CalendarScheduledItemOccurrence bu
join vItem It
on bu.SourceItemGuid = It.Guid
where It.ClassGuid ='2c8d08c3-a9ba-4e39-a6ea-08701fba4a6e' and bu.StartTime > GetDate()
Group by bu.SourceItemGuid, It.Name
order by It.Name
for tasks with shared scheduling following query can be used:
SELECT Shed.SourceItemName as [Name], Shed.SourceItemGuid, It.Name as [Shared Shedule] FROM CalendarScheduledItem Shed
join vItem It
on Shed.SharedScheduleGuid = It.Guid
where Shed.SharedScheduleGuid != '00000000-0000-0000-0000-000000000000' and Shed.SourceItemTypeGuid = '2c8d08c3-a9ba-4e39-a6ea-08701fba4a6e'
Be aware that this is just "SQL select, you may need to tune that reports to support "role rights", etc..
AlexTH