Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by shanmku

  1. shanmku

    Prompts and Filters behaviour

    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
  2. shanmku

    Prompts and Filters behaviour

    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...
  3. shanmku

    Report Studio : Configuring data sources

    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...
  4. shanmku

    Report Studio : How can we default a date control to NULL

    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
  5. shanmku

    Report Studio : Cover Page Appearing Twice

    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...
  6. shanmku

    Report Studio: Cascade feature doesn't work like we expected

    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
  7. shanmku

    Report Studio: Cascade feature doesn't work like we expected

    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...
  8. shanmku

    Multiple pages in report studio - Causing problem

    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
  9. shanmku

    How to calculate Business Days in Report Studio?

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

    Advantage of Storing Report Locally??

    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
  11. shanmku

    Report Studio - Display page number

    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
  12. shanmku

    Report Studio - Display page number

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

    Report Studio - Display page number

    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
  14. shanmku

    Report Studio - Problems formatting a Group Header

    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.
  15. shanmku

    Report Studio - Problems formatting a Group Header

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

Part and Inventory Search

Back
Top