Render the type and number of subreports based on a varying number of instances

  • Duncan Lawrence

    SSCrazy

    Points: 2007

    Hi, I have a reqirement for a single report that produces a number of different documents of different types and to different recipients.

    Scenario.

    A landlord wishes to send notices to tenants. The document should be a single pdf file containing: -

    Covering letter for each person responsible for the tenancy.

    Accompanied by two copies of the Notice for each recipient

    Covering letter for each member of the household (not including those responsible for the tenancy)

    Accompanied by two copies of the Notice for each recipient

    For a single peron household there would be a single covering letter and two copies of the Notice. Simples.

    For a four person household where two are responsible for the tenancy, there would be two copies of one covering letter, two copies of the second covering leter, plus eight copies of the Notice.

    I had thought of using subreport functionality but cannot workout how to filter the number and type of reports to be included based on the household composition.

    Any ideas on how to generate the mix and number of documents based on the profile of the household (the T-SQL element is complete this soley revolves around rendering the final document).

    Thanks you for taking the time to review this.

    All the best,

    Duncan


    All the best,

    Duncan

Viewing post 1 (of 1 total)

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