April 4, 2019 at 6:20 pm
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply