Hi, Mike!

Nice to see you in InterSystems Developer Community!

I have you book on my table) Thank you for your work! Can we wait for any new books from you?

I see Paul and Benjamin answered your questions. 

Here are my 2 cents: COS highlighting,  small FAQ. But as Paul mentioned DC is changing weekly so some of the advices became obvious some has become deprecated already.

Hi, Sylvian!

We used another approach to this problem and find solution which our customers use in production.

Customers wanted sophisticated excel reports from DeepSee. Thay alredy had hundreds of predefined reports in form of Excel.

What we do:

1. Transform this standard Excel reports into excel-xml(save Excel as xml) templates with XSLT variables inside.

2. Programmaticaly run reports in DeepSee, parse the result and perform XSLT transformation under excel-xml templates and data from DeepSee. You can use for this either %DeepSee.ResultSet or %DeepSee.REST.API or MDX2JSON.

3. Get the ready to use Excel reports with data from DeepSee in excel-xml form.

Here are some code examples, presentation and workthrough which are mostly in Russian (except COS).

Hope it helps.