AFO report format gets changed after scheduling

[former_member456005]

Hi Team,

We are having one AFO 2.8 report which contains two data sources. When we scheduled that report, output of file is adding one row extra below columns heading of that report though original report is not having that row in report.

Original report

Report after scheduling

Anyone has faced this kind of issue earlier. If yes, what is the reason behind it.

Regards,

Kirti Rane

[ajakash]

Hi Kirti,

I hope that you have attached two images, but they are not visible here.

Is the row that is appearing after scheduling the report is hidden by you previously in AFO Screen, or is it appearing as a part of the report structure?

In both the cases you can try to write a VBA script to hide the row as shown below. For example, if 23 is the row number, use the below formula:

Rows (23).Hidden = True

If you still face the issue, try to protect the format of the sheet. You can refer to the below link to do it:

How to protect worksheet’s formatting only in Excel? (extendoffice.com)

Thanks,

Akash.