Macro to list all the crystal report names form CMS

building reports crystal reports
1

Hi,
I need to list all the crystal report names present in the cms in an excel sheet, so is their any body having excel macro to automate this work.

Regards
Nalin

Nalin :india: (BOB member since 2008-07-18)

2

Try Query Builder:

SELECT SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport'

This should not take more than 5 minutes, i tried this and got the list in less than 5 minutes by formating the results in Excel.

  1. Run the above SQL in Query Builder
  2. Ctrl+A to copy all results and paste in Excel
  3. Delete Coulmn A completely
  4. Edit -> Replace “Top” with “” -> Replace All
  5. Apply a Filter on the coulmn and filter on Non Blanks
  6. You will have the list of all Crystal Reports

Copy the results to new sheet.

I hope this helps.

Viru

viru4808 :australia: (BOB member since 2008-01-09)

3

you can also use this method and adapt the code with the one given by viru

http://www.bobti.com/fr/articles/pdf/ART_UsingDeskiAndVbaToQueryRepository.pdf

bernard timbal :fr: (BOB member since 2003-05-26)

4

Hi viru,
Thanks for your quick response, it is displaying only report names, so can you help me in displaying report names, user having the access(user name), group, description.

Thanks
Nalin.

Nalin :india: (BOB member since 2008-07-18)