COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bvacha on 25 Apr 2013 09:51:32 AM

Title: Remove Dotted Line for Text Prompt
Post by: bvacha on 25 Apr 2013 09:51:32 AM
Hi,

Has anyone figured out a way to remove the red dotted line that appears below a non-required text prompt?  I've seen posts for how to do this through javascript for value prompts, but not for text prompts.

Thanks,
Brian
Title: Re: Remove Dotted Line for Text Prompt
Post by: rprameshwor on 26 Apr 2013 12:13:20 AM
Have you tried  setting the following properties for the prompt :

Required : No
Hide Adorments : Yes

Title: Re: Remove Dotted Line for Text Prompt
Post by: bvacha on 26 Apr 2013 08:02:50 AM
Thanks rprameshwor,

I did try that but I still get the red underline.  The hide adornments removes the red asterisk and the little red arrow next to the text prompt, but not the red underline.

I created a new Text Box Prompt and set Required=No and Hide Adornments=Yes and the red line disappears.  So, I found that I'm seeing the red line because the parameter I'm using for the original Text Box Prompt is tied to one of the values in a stored procedure.  If I use a different parameter, I don't get the red line.  However, I need to be able to accept NULL or an empty string as the value for the stored procedure, and I don't like having the red line under the prompt box.  It makes the prompt look sloppy with the other graphics on the page.

Brian
Title: Re: Remove Dotted Line for Text Prompt
Post by: calson33 on 26 Apr 2013 10:26:05 AM
I had a similar issue with prompts in SQL - In the end I had to make sure the prompt had a default value:

(#promptmany('parm1','string',sq('NotSelected'))#)

Hope that helps...

John
Title: Re: Remove Dotted Line for Text Prompt
Post by: bvacha on 26 Apr 2013 11:18:58 AM
Genius, John!  Since I don't need the multiple values, I used just the prompt macro in Framework Manager for the stored procedure value:

#prompt('parameterName', 'string', ' ')#

I couldn't get it to work with an empty string or without putting in a default string, so I'm using a single space as the default.  Not ideal, but very close to ideal.  This will work and I don't get the red underline anymore.

Thanks!
Brian