Cognos Report Studio Prompt Macros

macros report prompt cognos
TheMadCapLaughs27 picture TheMadCapLaughs27 · Feb 20, 2013 · Viewed 8k times · Source

Is there a full guide for the use of prompt macros?

I have used a few to filter date and text fields (I found them looking around), I am looking to use a macro prompt with a combo (in this case with static fields).

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

Thanks.

Answer

Nick.McDermaid picture Nick.McDermaid · Feb 21, 2013

sq() means surround in single quotes.

The most information I've found is in the Framework Manager guide. This contains info 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 have built my own document from all the fragments on the internet.

Related questions

What is ":-!!" in C code?

I bumped into this strange macro code in /usr/include/linux/kernel.h: /* Force a compilation error if condition is true, but also produce a result (of value 0 and type size_t), so the expression can be used e.g. …

Read More
__FILE__ macro shows full path

The standard predefined macro __FILE__ available in C shows the full path to the file. Is there any way to short the path? I mean instead of /full/path/to/file.c I see to/file.c or file.c

Read More
How to write macro for Notepad++?

I would like to write a macro for Notepad++ which should replace char1, char2, char3 with char4, char5, char6, respectively.

Read More