locked
SSRS sql sever 2014 RRS feed

  • Question

  • HI

    please advice  me if above  one laks record unable  save using  ssrs  2014 ,kindly find  the below error  and advice

    SSRS Subscriptions

    Failure writing file ACCCCCCC : An error occurred during rendering of the report.

    A message that indicates that the number of columns exceeds the maximum possible columns per sheet is typically caused when the number of columns in an Excel worksheet is exceeded.


    baskarlakshmi

    Friday, July 28, 2017 1:23 PM

Answers

All replies

  • number of columns in an Excel worksheet is exceeded


    In which format do you export the Report; is it old XLS Excel format? That supports max. 256 columns.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, July 28, 2017 1:26 PM
  • Hii need to  export excel formate...records around 2 laks am ok that if can able add  sheet 2 ,sheet3 ,is there any way to do this

    baskarlakshmi

    Monday, July 31, 2017 4:38 AM
  • Monday, July 31, 2017 5:49 AM
  • Thank you worked fine..

    baskarlakshmi

    Wednesday, August 2, 2017 5:40 AM
  • Hi baskarlaksjmi,

    May I know how is your issue going currently? If your issue is solved please mark the appropriate answer as Mark as answer.  This will help other members to find a solution if they face the same issue. If you still have any questions, please feel free to ask.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, August 11, 2017 5:51 AM