Query builder results inside deski report

[system]

Hello,

Is it possible to write a VBA macro which would return results from repository Query Builder and display it on Deski report?

If yes, could anyone show me the simplest example which would do that.

For instance displaying results of the query

“Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_KIND = ‘Folder’”

Best regards
wojnarabc

---

wojnarabc (BOB member since 2007-11-07)

[system]

Hi,

Have a look at this topic:

Desktop Intelligence data provider using VBA to access CMS

Hello all, Been lurking on these boards for a few years now, and have gleaned a lot of good information from many great Admin/Dev’s out there. I feel it is only right to return the favour. Note: This was created in part from elements of others work, unfortunately I was working on a timeline and hadn’t created a list of authors to give credit to. If you see some code that you may have created, I thank you for great work, and for sharing that knowledge with others. I had been looking into ways…

There is a different query used there but you should get the idea how it works.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thanks Marek

---

wojnarabc (BOB member since 2007-11-07)

[system]

Here’s another approach for CMS reporting:

https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13214

You may also want to consider 3rd party alternatives that allow for CMS reporting (System Profiler, etc)…

---

crystal01 (BOB member since 2006-08-30)