Geek Answers Handbook

Cognos Report Command Line Macros

Is there a complete guide to using query macros?

I used several to filter the date and text fields (I found them looking around), I am looking to use a macro tooltip with combos (in this case with static fields).

Examples I used are: ORGID = # rows ('OrganizationID') # to_date (#sq (prompt ('Start_Date', 'DATE')) #, 'YYYY-MM-DD') (what does sq mean btw?)

Thanks.

+4
source share
1 answer

sq () means surround environment in single quotes.

Most of the information I found is contained in the Framework Manager Guide. It contains information including an explanation of sq

http://pic.dhe.ibm.com/infocenter/cfpm/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.im.cognos.ug_fm.10.1.0.doc%2Fug_fm_id10577using_macro.html

I created my own document from all fragments on the Internet.

+2
source

More articles:


All Articles