Subreport and Caching RRS feed

  • Question

  • Lets say you have a report rdl A.
    Lets say you have another rdl B that contains two subreports 1 and 2.
    Subreport 1 points to rdl A with parameter set P1.
    Subreport 2 points to rdl A with parameter set P2.

    When rdl B runs we want A to be cached as A(P1) and A(P2).  However from looking at the reporting service temp db it looks like a cache record is created for rdl B, but not for the 2 subreports.  Is there anyway to get this to work.

    Here is background on what we are trying to do.  Basically we are creating a wrapper rdl (B) in memory to hold a dynamic collection of subreports.  The collection of subreports is driven by database configuration per user.  So at the end of the day a user creates a collection of reports and then is able to export them to an excel spreadsheet with each sheet corresponding to a report. 

    At the same time we would like to be able to cache the execution of A(P1), A(P2), ... N(PN) so that if it appears in another user's book it can come from the cache (ie our wrapper is just grouping the reports).  Caching is perfect for us because we have data that is updated monthly, with slow legacy procs.
    Please someone help us figure out how to do thisSmile


    Monday, October 27, 2008 8:08 PM