Error exporting SSRS report to Excel RRS feed

  • Question

  • A PPS scorecard with red, yellow, green traffic light indicators is deployed to SSRS 2005 to do some customizations like freezing panes, etc.
    It's then deployed to a PPS dashboard & exported to Excel. Everything works fine if all the indicators are either red, yellow or green. When future months are shown in the report with no data (& a white traffice light indicator), export to Excel does not work.
    We need to show the current Semester scorecard (till Dec). But Sep, Oct, Nov, Dec don't have data & show a white indicator in the report.
    Is there a way to have no data & blank indicator & still be able to export to Excel?
    The export works correctly from BIDS 2005 & not from PPS Dasboard.

    Friday, August 14, 2009 4:46 AM