Search results for query: *

Hi All, I have a report with optional Select & Search prompt that runs perfectly when run ignoring the parameter. But when I try to search a value in the parameter with '%', it throws following error. Report validation is also fine. The parameter query is using a data item from a view in oracle...

Hi, I checked the log file (cogserver.log)in Program Files\cognos\c8\logs. I didn't find the particular error here. Can there be any other location for these logs? Thanks

Thanks... I will check the file once.

Hi, Thank you for your quick response. The report I referred to is in Public Folders and I am able to run it perfectly using my credentials. I wonder why the user only gets this error.

Hi All, User gets the following error when he runs a few reports in Report Studio. As part of the security, it's all fine. Could anyone let me know how I can debug this? An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. DPR-ERR-2082 An error has occurred. Please...

Hi Jim, Thanks for your quick response. I've added a query filter as I mentioned earlier. Sample values as below: Batch name Group name Budget Allocation ---------- ---------- ----------------- Batch 1 Group A 23000 Group B 9125 Batch 2...

Hi, I've got a problem and expect some of you may solve this. I am working on Cognos 8. I'm using a view as a query subject and to build a report.Two of the several query items in this report are Batch name and Group name. When the User selects a Batch name in its prompt control, only Group...

Hi Swathi, You can use a text box prompt for this. Create a text box prompt and modify the parameterized filter in your query as following: CAST([data item], VARCHAR(XX)) LIKE ?Parameter1? This enables the user for wild card search using '%'. XX is the maximum number of characters of the data...