If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Prompt/parameter issue

Started by Tsunami, 18 Aug 2011 08:40:19 AM

Previous topic - Next topic

Tsunami

I have a value prompt that diplays a list of salespeople.  It uses the query subject 'Salesperson prompt' to populate the list.  That parameter is then passed to a filter for the main query subject.

For some reason, after I submit my selection, I get a system generated prompt for the same thing.  Is there something I should be looking for?  I've had this issue before but forgot the solution.

chaithucognos007

look in the Report Main Page or Query.... whether u have 2 Filters ?

Lynn

Is the parameter name spelled slightly differently for the prompt control vs. the query filter?

Tsunami

No, they are the same.    This is a large report and I've gone everywhere it's used in a filter and set the filters as optional.  I still get a 'required' star next to the system prompt.


Lynn

Do you reference the parameter in a data item? That could cause the behavior you are describing.

Tsunami

#5
Well, there was one but I removed it.  I thought that was my problem but I am still getting the prompt.  I searched/ran each individual query subject and I'm still coming up short.

Also, when I run my main query, it works properly and the system generated prompt for salesperson is optional.  It's when I add the prompt page that it duplicates...but I'm referencing the same parameter that already exsited in the report.

Lynn

Did you try using the search option for expression text to see if it is somewhere you missed? Could it be in conditional format or variable expressions?

You could always just copy the XML to the clipboard and do a search that way. I guess if you are getting a system generated prompt for something that you believe is optional then it has to be referenced somewhere that doesn't allow you to be optional about it.

Tsunami

Dumb question:  Where's the search function?  Never used it.

I just ran the report in XML....and didn't get the system prompt.  :o  What does that mean???  It's still showing up for HTML though.

Lynn

If you look in the edit menu you will see a "Find" option, and not a dumb question at all and I should have said Edit > Find instead of search!

In there you can select "Expression Text" and then fill in the name of your parameter to search for it.

What I meant about XML was to go to the tools menu and select "copy report to clipboard", then open notepad or something like that and paste it in there. Then do a search for your parameter to see if it helps you find some reference to it you've missed.

Tsunami

Ah, I found it!  Thx Lynn.  The Find function found one I had missed.

chaithucognos007

Nice Solution Lynn !!! I learned something new :)