Hi everyone,
I'm pretty new to cognos and I've been trying to get the report output based on a prompt where the user will type in the "Amount number" and get all the records related to that particular amount.
i tried the select and search prompt but with no luck. when i click on search ,it fetches that exact value and when i select that value and run the report it throws the "sql open result error".
You'll need to be a bit more specific on your needs. Are you looking for all accounts that contain that amount or more? or less?
There are two sides to a prompt. There is the control and the filter itself.
The control you mentioned is a search prompt. That's generally used for finding values containing a specific string. It sounds like you might want a value prompt cascading against a text prompt.
So create a text prompt for numbers then create your value prompt. In the query for the value prompt add the account details, then set the filter to [Namespace].[Table].[Amount]<=?Amount? And add a button to refresh the page. This way the user can type in a number, press the button, and all accounts with amounts less than or equal to what the user entered will be displayed in the value prompt.
Thanks very much for the quick reply , i am able to retrieve the data using the select search prompt but when the user is typing in a DECIMAL value it throws the sql open result error.
Can you paste the error message in here? That might give us a bit more of a clue...
Avoid the search prompt. When you need to search for individual accounts based on a variable value (less than, greater than, etc), use a text box prompt and a value prompt.