Search results for query: *

Yes, I tried the opposite. But ended up getting the sql error like "An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'." Let me know. Thanks for your support. Kumar

Hi, Since we are new to Cognos 8 Report Studio. We would like to clarify few things about Prompts and Filters behaviour. The scenario is, we have a value prompt which contains static choices and multiple selections enabled in it. It uses a param variable called 'prmReqType'. When the user...

Hi, Since we are new to Cognos. We need information on how we can configure datasources for different environments. For example, we have reports in QA environment that uses a certain package which connects to QA database. Once the reports were tested, the package and the reports are moved...

Hi, I do not want to use a default date for a date control in my report. How can I control this. Unfortunately date control doesn't have Static Choices property to set it to a different value. Please advice Report Studio experts. Thanks in Advance. Regards, Kumar

Hi, Since we are new to Cognos ReportStudio, we need your advice. We have a report in which we have 3 prompt pages, each prompt page contains about 6 prompts. When we run the report, the cover page shows up first and then the rest of the pages. The issue is, when we get the cover page...

Thanks a lot for your advice, MF. I followed the instructions and it works now like we expected. Also the report looks great. Regards, Kumar S

Hi, In one of our reports, we have three prompt pages. One of the pages contains prompts that is associated to one another. So we have a heirarchy of prompts which has a parent and child relationship. Each of these prompts have an associated query where we have a detailed filter to check...

I am new to Cognos 8. I designed a report in such a way it has multiple pages and a coversheet too. The issue that I am facing is, the coversheet page has been displayed twice. And also the first two pages gets repeated again. Anybody has any advice. Thanks in Advance. Kumar

Is there an inbuilt function available for calculating Business Days between two given dates? Any advice will be more helpful. Thanks in Advance. Kumar

Could anyone tell me the advantage of storing Cognos Report file locally in the hard disk than storing it in the report server? Although we are new to Cognos 8 Report Studio, we would like to know the Pros and Cons of it. Any suggestions. Thanks in Advance. Kumar

I need to print it with a certain format like for instance Page 1/10 etc. Do you know, How to format it and show it in the Cognos Viewer? Let me know. Kumar

I need to display it like Page 1/10 in the Cognos viewer.

How can we display a page number in report studio with a specific format ? Say for example, I want the page number to look like 'Page 1 of 10' and it goes on. Report Studio experts, any idea? Thanks in Advance. Kumar

No, I meant that previously when I didn't know how to change the group header. I was creating a data item which starts with the month name and then year. so it was sorting based on the string. Now based on your suggestion, I unlock the structure. And It works fine.

I forgot something in my previous reply. Keep checking this forum. We need your support. Thanks Kumar

Thanks and I appreciate for your timely help, sir. I was trying the exact thing that you described in your reply. Creating a data item that has the Month and the year and then grouping on that. But there was an issue with sort. Thanks Again. Kumar

I am new to Cognos Report Studio. But I have reporting experience. Currently I am facing a problem in a report where I am grouping the rows based on a certain column. Also I am using the column as a group header. The issue is, How do I make the group header look in a desirable format...