Auto Removal of Blank Schedule from Consolidation report

Hi,

We have a client requirement to removed Blank schedules from Consolidation related formatted report.

Below is requirement-

• Heading should come at top with dates at against each schedule
• Total should be shown at bottom after schedule ending
• Only lines/schedule which has data should show.
• There are around 80 entity and this should be applied for all 80 entities.
• Note numbering should change automatically based on Data available in schedules.

Please help, if someone has done this.

Regards

Rahul