0

I am having a hard time figuring out a solution to the following reporting issue. I used to do something similar using SAP Business Objects but am with a different org now and have different resources/software available. It seems like a common issue/function, but I am having a hard time finding information about it online. Perhaps I am missing some nomenclature on what this is called. A description of what I'd like to accomplish is listed below followed by some pointed questions.

Essentially, I'd like to automatically create a report for each row in a table based on a template. In other words, I'd like to design a report template that references certain columns from the table, and then automatically create a copy of each report for each primary key. I have about 300 rows, so I am trying to avoid manually exporting 300 versions of reports that are from the exact same template. For example, the header will contain that row's value from column 1, the right side will have the value from column 2, etc. Ideally, I'd like this solution to automatically generate an individual PDF version of each report. My workflow would essentially be: build a report template, pick a table to iterate over, and choose a directory to create the PDFs in.

  1. Can this be accomplished with SSRS or Tableau? These are the resources I currently have access to.

  2. If the above can't accomplish this, what kind of programs can do this?

  3. I have the files from someone who completed this task in the past. The PDFs' properties tell me that they came from InDesign- does InDesign have this capability?

  4. What is this function commonly called? It seems like it should be a common task in reporting, but I am having a hard time finding info about it online. I've been calling it "Iterative Printing", or simply saying that it is similar to Microsoft's "Mail Merge"

chiwangc
  • 3,566
  • 16
  • 26
  • 32
Luke
  • 1
  • 1
  • Common name is Variable Data Print (VDP) or as you said Mail Merge. Mail Merge is more commonly used for blending data and document for email where variable data print is for blending data and print template for print output. XSL FO is one of the common technologies used for print/PDF generation – Kevin Brown Jun 10 '15 at 22:36
  • I would add that the "variable" in the name VDP is usually because the templates can be much more complex than just "put this data here" ... they could be "if the state field is 'UT' then show this, or ...." in other words they can have deeply nested logic of IFs or CHOOSE/WHEN/OTHERWISE as well as repeating structures, sorting, etc. – Kevin Brown Jun 10 '15 at 22:44
  • You can do it from SSRS in different ways: 1) The "out-of-the-box" solution: with SSIS and data-driven subscriptions (requires a Business Intelligence, Enterprise or DataCenter edition of SQL Server) or 2) The tailored solution (the best option IMHO if you can afford it): Developing a tool generating reports using the SSRS WebServices. You can make it configurable and execute queries generating a report for each rows. Doing that you have also the ability to better customize delivery and not being limited by some subscription configuration that you need but are not implemented. – Sébastien Sevrin Jun 11 '15 at 08:53

1 Answers1

0

From an InDesign Automation Expert point of view, there are several ways of automating such a datamerge from simple to advanced needs. InDesign indeed offers a native datamerge tool which is rather efficient and simple to use. However it doesn't offer nor conditional processing nor updates. If you are adventurous, you can consider XML within InDesign, which is also a native feature. XLST can then brings conditional processing but it definitively increases complexity in teh workflow. Finally the tool I generally recommend is EasyCatalog because it's really powerful and smooth. The only hiccup is that it's not a true VDP plugin. If you generate 10k pages, it will not be optimized as a VDP plugin would do. So it's really up to you depending on your needs. Feel free to get in touch with us at ozalto.com if you want more infos on these tools.

Loic
  • 2,173
  • 10
  • 13