Printing report 'specs'

building reports desktopintelligence
1

Does anyone know how to print out the ‘specs’ for a Bus Obj report (i.e. Dimensions/Measures selected, Conditions, SQL, etc). Like printing out the source code.

Listserv Archives (BOB member since 2002-06-25)

2

Insert a cell in the report and go to Edit Formula. Under Data Provider functions, select Data Provider SQL, Data Provider, and then select any object from the left column. Here’s the resulting formula:

=DataProviderSQL(DataProvider())

George Baranowski
QuadraMed

Listserv Archives (BOB member since 2002-06-25)

3

In a message dated 01-05-03 12:46:38 EDT, you write:

Does anyone know how to print out the ‘specs’ for a Bus Obj
report (i.e. Dimensions/Measures selected, Conditions, SQL, etc). Like printing out the source code.

We have a VBA script on our web site (provided by another list member) that does just this. It lists objects and variables both. If you examine the data providers you will only get the objects selected in the query, and not the variables added to the report. It requires version 5.

I have not used this VBA macro myself yet, but it sounds good. :slight_smile:

Find it at: http://www.islink.com/tech_vba.htm

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)

4

Hi Dave,

I know its been a long time now. I am looking for a piece of code which performs the same operation. I am able to print out the query results and conditions, but need to print out the contents of the variables in a report.

The link mentioned below does not work anymore. Would you be able to guide me with the information/code for achieving the same?

Thanks.

Aficionado (BOB member since 2003-10-24)

5

Try this link here (it does not list local report variables nor formulas though).

Andreas :de: (BOB member since 2002-06-20)

6

The Integra link is here. You might also take a look at the utility from Lyon Technologies.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

7

I have downloaded the Document Data Dictionary addin off the Integra link given below. It’s great! :smiley:

However, I really want to be able to have this information in a printable format. In other words, I want ALL objects, Variables and Formulas in the report to be listed with its associated definition/description–in a single printable document. Having this would enable me to quickly reference this information as I (or another document tester) was going through a report column by column to review and test.

Does anyone know if this exists anywhere?

Also, I did try to download the utlity from Lyon Technologies, as mentioned in the previous post, but wasn’t able to. For some reason, the download off the website didn’t work.

Thanks for your help!

ciodice :us: (BOB member since 2005-04-05)

8

Hmmm … you might want to try again. The download worked fine for me just now.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

9

Are you implying that the Lyon Technology utility has what I am looking for?

Well, I did try again. It seems that if I just click on the icon – nothing seemed to happen. But, when I did “Save Target as” I was able to download it.

So now I have downloaded and installed it as an Addin – Now what?
I didn’t notice anything new in my file menu – how should I access this tool?

thanks for again for your time on this…

ciodice :us: (BOB member since 2005-04-05)

10

It is all spelled out in the PDF file that comes with the add-in: Go to Tools| Macros and run the macro.

Andreas :de: (BOB member since 2002-06-20)