locked
Export to excel RRS feed

  • Question

  • Hi Geeks,

    I am creating a SSRS Report which should not have any visual - table/matrix etc to show the tabular data. Instead when after passing the parameter  and run the report, it should generate the output in an excel sheet.

    My report is having around 100 columns and its not practical to create and show this report in report designer using tablix control.

    Can anyone help me out on this problem.

    I am using SSRS 2015

    Thanks,

    Avhilash Kumar

    Thursday, June 20, 2019 9:27 AM

All replies

  • In the Report you have to define which data should be use and for export to Excel you have to use a tablix.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, June 20, 2019 9:57 AM
  • Hi Avhilash,

    For what I understood from your post, I think in this situation, you don't need SSRS. You could directly edit your query with parameter and export the result into Excel.

    SQL SERVER MANAGEMENT STUDIO – EXPORT QUERY RESULTS TO EXCEL

    Regards,

    Lukas


    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, June 21, 2019 7:11 AM