Hi All,
I need to drill drown from one report to te other.
We are providing hyperlink,when click on the hyperlink button that value has to pass to the another procedure file.
The another procedure is expecting data with in Quotes.(for example '15').From the main report tha value is passing like 15.I need to put it into double quotes.
How can i do like that.

Thanks,
Raghu

This message has been edited. Last edited by: Kerry,

 

-SET &DRILL_LINK = ' SEVLEVEL=' || '''' || &SEV_LEVEL || '''' ;

OR

-SET &DRILL_LINK = ' SEVLEVEL=' || '''' || '1 OR 2 OR 3' || '''';

Then

TYPE=DATA, COLUMN=N3, FOCEXEC=&DRILL_LINK, $

 

Which ever may apply.

This should give you an idea on how to do it.

-SET &VAL1 = 15;

TYPE=DATA, COLUMN=N3, FOCEXEC=program.fex (VAL1=&VAL1.QUOTEDSTRING), $

If the value comes to the drill down procedure as a number, you can transform it in the drill down procedure with code similar to one of the statements below. The first -SET statement surrounds the value with double quotes, the second -SET surrounds it with single quotes.

-SET &VAL1 = '"' | &VAL | '"';
-SET &VAL2 = '''&VAL.EVAL''';

Did you try doing this in report painter? Were you looking for coding or GUI. Using the GUI is much easier.