I am using Cognos. I have a field in my database that stores a date that I need to pull. The problem is that this is a text field.
Here is a sample contents: referred 2/2/2008. Or, somet...
Hi,
I would like to understand how Cognos manage the queries, as I've seen that (in a test) it's calling a query 3 times instead of what I was thinking -> calling the query one time and "work...
Hi,
We are upgrading to cognos 8.3 . Development and Production are on two diff servers. There are more than 150 users. Could you please provide the minimum and maximum System require...
How to upgrade cognos 1.1MR2 to cognos 8
I have been trying to create a feature in a report that I have that allows me to search for a billing code (by count), by location and then date range. The area where the problems creep in ar...
The data is meant to show how many visits a provider has made during a certain period. It needs to then be separated by location, and finally provide a total count by provider, and then by or...
Hi,
I have few questions regarding upgrading from 8.2 to 8.4.
1) Is it a good practice to have both development and production on one server? If so what would be the best scenario.
2) ...
Using ReportStudio, I am trying to create a calculation using values from two queries (eg. Total from Query 1 + Total from Query 2). Essentially I'm trying to duplicate this ability from Exc...
When a stored procedures is called in a report, how do you handle exception handling you can add in the PL/SQL when an error has occurred?
Can cognos handle output parameters? If yes, what is...
Hi I have recently started using Cognos8
I have been advised to use Reportnet to send reports via email. Can anyone explain to me what it is and how I use it within Cognos?
Thanks
I have created a prompt report in Cognos which is a line chart that pulls values for a building that will run each day. I have scheduled this report to run and save as a pdf file to a folder o...
I am trying to save a Cognos 8.4 report to a file but i do not see the option mentioned in the documentation 'Save to the File System'.
-- I have set the the Cognos Configuration setting for...
I have set up some cognos report to run on a schedule and save as a pdf file to a folder on the server. The problem is that this only seems to work for the initial run. All subsequent runs of ...
Using Dev Studio 2005 I have thus far been able to deploy my working Report. I say working because I have the report: MyReport.RDL runing with live data in preview mode with a parameter no le...
Hi,
In Cognos 8.3, report studio:
I've a strange problem with a HTML Item (in a HTML report, of course), which property "Source type" is defined as "Data Item value".
The code that is s...
i would like to sort columns in the output of the report studio - basically i want my canned report to be able to sort columns by clicking on the column just like excel. I am using 8.4
I kn...
I have a generic report that is titled "To Date Values for Region(s): ___". On the report I have a Value Prompt where the user selects a Region (they can select more than one Region). I want...
Hello I need to add a javascript to an existing Crystal Report using the CrystalDecisions.web object
The version I am using is 11.
Is it possible to do this? If so how is it done?
No...
Hi,
When any of our users run a report, at the top right of the prompt screen there is a link to report studio. We'd like to remove this like to stop them having access to that interface. D...
