Search results for query: *

I have an existing table with about 10 attributes and columns for 5 years of data. I want to take another table with similar attributes but only one year of data and update the first table. This one year is for a new year which does not exist in the first table. For example: Table 1 attr 1...

I apologize if I'm asking this wrong but does Cognos support AJAX at all? If not, does anyone know if there are plans for that. I talking about AJAX support for Cognos Connection and non-'studio' work. I find it very cumbersome to manipulate reports between folders with the constant refresh...

I'm using Report Studio 8.3. I have a report that validates fine and I get output with html but when I select any Excel or PDF option I get the following error: RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the...

I have a report that has two date prompts that needs to be scheduled Mon-fri, but the dates are different based on what day of the week it is. My chart is (Date1 and Date2 are referring to the day in the previous week): Today Date1 Date2 Monday Wed Thurs...

I know this is not a Cognos issue but it seems to have only come up with one of my users who is trying to output reports in either Excel or .csv format. Most of the time, the report runs, a box pops up for a split second (Way to fast to see if anything is in it) and then closes with no output...

I have a data element that is formatted as text. The are actually dollar values. I need to find a way to transform them in Cognos to be able to sort in value order, not text order so instead of: $1,000,000 $5,000 $70,000 I need it to be: $5,000 $70,000 $1,000,000 If I knew the list of...

I think I'm either missing a really easy concept or looking at this the wrong way. My problem is that want a filter to be 'optional'. What I'm doing it I'm prompting the user if he wants to use a filter. If Yes is selected, then the data is filtered, if No is selected, then all data...

I thought I saw this somewhere but I can't seem to find it. I have a list report from Report Studio 8.3 where I have 2 data elements plus the month number (Jan=1, Feb=2, etc) and then a count. I concatonate those first three fields so I have that and the count. The problem is that not every...

How do you set the default font for Cognos 8? I'd like to change it to 'Times New Roman'. Is there somewhere that the user can set that or does it needs to be set up further back by the administrator. thanks, -Eric

I have a value prompt where one of two static options can be selected. From that selection, I'd like a prompt to appear with the values of the selected option. For example: First prompt: Do you want values by Country or Continent? If Country is selected, then display another value prompt...

This seems like it should be really easy. How do I display yesterday's date on a report? Right now, I have it as 'Today()' but the data is really as of yesterday. thanks, -Eric