Post reply

Display SSIS log details in Drill- Down SSRS report

  • March 29, 2013 at 1:49 am

    #275694

    Hi All,

    I have a log table which stores the data, from log table I am able to find the duration for each task/ container.

    From that log table I want to generate the Drill Down report.

    I have attached the excel which has sample Log data and report.

    Any suggestions will be really helpful

  • March 29, 2013 at 3:37 am

    #1601950

    What are you exactly struggling with?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 29, 2013 at 7:27 am

    #1602008

    I want an idea on how should i build my sql query so that I can have parent-child kind of hierarchy. And then I can show that in SSRS report in drill-down format

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply