Search results for query: *

Hi Has anyone worked with reference pages in report studio 10.2.1? I have referenced some charts portrait, and some landscape. However all the reports default to landscape even thought print PDF is set to portrait. Any help would be nice Sid

Hi I have created a report which shows last years sales and this years sales controlled by a date_to prompt. However when I run up to previous month it keeps displaying including this month. [FYS]>= IF (extract (month,?To_date?) in (01,02,03) ) THEN ((extract(year,?To_date?)-1)-1) ELSE...

Hi I am trying to apply total percentage to a crosstab report. I have revenue as 1 row I have Sales targets as 2 row and periods as columns At present the total sales target is showing an addition of rev/sales target. However i would like to show in the total column total revenue / total...

Hi Does anyone how to re-order the legend content on a stacked bar chart? Thanks Sid

Hi I have two issues, if anyone can assist with. I have created a calculated field in report studio, which is aggregated up, using x%= (percentage ([Price)] for [Financial Year]). This is rounding up/down to the nearest integer. How do i stop/control this? As is giving incorrect figures...

Hi I have an existing cube, just pointed the source data to another database, identical setup. When building my cube i have a region hierichy with countries within the cube. Example Europe -- UK , France , etc in my cube i have Europe with its nested countries then drill to UK i get a number...

Hi I have just moved database from SQL Server to SYBASE, so a re-write of existing reports was necessary as the database table names had changed. When creating a cube in transformer, i have setup a few drill throughs into impromptu reports. When testing in client the drills perform correctly...

Hi I am trying to develop a report where status 6 is not present for an account. An account can multiple statuses, but I only want to show acc with no status 6 i.e. Account Status ============================= 0001 1 0001 2 0001 6 0002...

Hi, I am currently scheduling a suite of report studio reports 8.4.1 to a file system drive. Works a treat. However these reports are scheduled on a weekly basis, i have selected the option to create a unique file with date appended to the file. As I would like to keep history. This function...

Hi I am writing a report in which i would like to display sales rep's sales on different separate pages in a report studio report. I have listed below a really basic example of how i would like to report to look. Each page will share the same header date range. E.G Page 1 John Smith Tents 30...

Hi I am trying to count the amount of times a user has logged on to the system. I have user name, date/time, date extracted from date/time User =============== Date/Time ================ Date ===================================================== Adam =============== May 23, 2011...

Hi I have created a report in report studio. The report contains a prompt page and a main page. I have a header in the report which i would like to display data. I also would like to place a calculation at the bottom of the report. See example below Employee: XXXXXX Area:Europe Manager...

Hi, I am trying to add items from my query to the header in cognos 8 report studio. When i do this it sets another query; query2, query3 etc. Does anyone know how to insert query objects into the header. Thanks Sid

Hi, I have a date/time field in my cognos 7.4 catalog, im trying to create a prompt where the user can select only MM/YYYY. Does anyone know how I can just strip the date/time element and just display MM/YYYY in the prompt for a period of 10 years. thanks Sid

Hi, Does anyone who I could introduce zero when no data in the bucket range. CASE WHEN [Age] <= 0 THEN 'Future Value' WHEN [Age] between 1 and 30 THEN '1 - 30' WHEN [Age] between 31 and 90 THEN '31 - 90' WHEN [Age] between 91 and 180 THEN '91 - 180' WHEN [Age] between 181 and 360 THEN '181...

Hi, I have list report that returns a report with several hundred records. The record ID is duplicated in the report for each condition e.g. Approved, rejected, Assess. I only want to return the 1st record for the ID. At present all records are being returned. Any suggestions? Thx Sid

Hi, I am trying to run an IWR report in upfront and am getting the following error: GeTemplate iwr modifyprompts.utml failed. Reason: The version of cognos is 7.4.4 and the OS is windows 2003 enterprise server. The database is sql server 2005. Reports that don't have prompts run fine under...

Hi I am current migrating reports from 8.1 to 8.4.1 there is a day of week function in the header. This is failing in 8.4.1 with local processing error. I have check FM is set to LP. Any help would be appreciated. UDA-SQL-0460 A general exception has occurred during local...

Hi, Can anyone suggest or provide guidence on how to configure LDAP on a new windows server 2003 with sun one for Cognos 8.4.1. Thanks Sid

Hi, Has anyone burst analysis studio reports to a network drive and if have you changed run with option to excel. Please advise on a process to burst the analysis studio reports to network drives. This is required for 8.4.1 and is there any additional security to be considered? Thanks Sid