locked
Quarterly Trend Reports RRS feed

  • Question

  • I am trying to convert an old financial report, that has maintained in EXCEL using Macros. This EXCEL report shows a set of 5 columns for current Quarter and then follows it with the last 11 quarters' worth of "5 column" reports.  I would like to convert this into Reporting Service reports that is subscribed to email users the last 12 quarters data in the same format. Is there any way, I can do this calling a report proc 12 times (with different quarter date ranges) get the data to populate each of the 5 tables within one report.? I appreciate any suggestions here.
    Friday, February 21, 2020 7:47 PM

All replies

  • Hi Din Chin,

    When you deploy Reporting Services, a set of data processing extensions are automatically installed and registered on both the report authoring client and on the report server to provide access to a variety of data source types. Reporting Services installs the following data source types:
    Microsoft SQL Server
    Microsoft SQL Server Analysis Services for MDX, DMX, Microsoft Power Pivot, and tabular models
    Microsoft Azure SQL Database
    Oracle
    SAP BW
    Hyperion Essbase
    Microsoft SharePoint List
    Teradata
    OLE DB
    ODBC
    XML

    Please refer to Data Sources Supported by Reporting Services (SSRS).

    Best Regards,

    Mona


    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

    Monday, February 24, 2020 9:37 AM