Post reply

How to create trend report based on report snapshots

  • October 6, 2009 at 2:45 am

    #211685

    Hi all,

    How to make history reports(snapshots) as data source and create trend report based on them ?

    RS2005 store snapshots in binary format. Is there anyway I can export them as XML or something?

    Thanks for any helps

  • October 6, 2009 at 6:30 am

    #1062194

    Hi Z-438578,

    Sorry. I'm not getting you. Can u elobrate it?

    May i know where the snapshot is stored in binary format?.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • October 6, 2009 at 7:41 pm

    #1062562

    I think it's stored in Reporting Services database.

    Basically, I have some history reports for a single report.

    I want to use these history reports as data source so that I can create a new trend report to show how data goes over time.

    Cheers

  • October 7, 2009 at 12:48 am

    #1062602

    Hi Z-438578,

    Below is the list of tables having the Snapshot details

    select * from History

    select * from SnapshotData

    And i use the below query to retrieve the information of the snapshoted report

    select Catalog.Path as [Report Path],SnapshotData.* from SnapshotData

    inner join History on SnapshotData.SnapshotDataID=History.SnapshotDataID

    left join Catalog on History.ReportID=Catalog.ItemID

    I don't believe that you can achieve the output with this tables.

    I'm just thinking that to use the Reportservice Webservice to extract the information from the snapshoted report. Just give a try. Meanwhile if you find the better solution kindly let me know.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • October 7, 2009 at 9:28 pm

    #1063226

    I found this thread

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d5fbd89f-44d8-4bb1-ad8d-f72925984f44/

    but I don't know exatcly how to implement each steps.

  • October 8, 2009 at 2:11 am

    #1063271

    Hi Z-438578,

    Let me aslo try this and get back to you

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 6 posts - 1 through 5 (of 5 total)

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