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 That won't work, because an account may have mulitple statuses, it will return accounts with status 6 where they have other status assigned. I only want to return accounts that don't have status 6 assigned. Any thoughts? Sid

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 Thank for your response, however, it is not prompt parameters that are the issue, its query items from query 1 that i want to place in the header, which is more complex as adding them creates new query?? Any suggestions

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

Thanks I managed to figure it out. With calculated fields comprised of two or more elements from the package, would you advise them to be introduced in to the FM? Then its a simple matter of pulling them in to the singleton items? Thanks Sid

Hi, When trying to add a singleton object to the header, i am getting the error data is not in query 2. 'Unable to insert this data item here because the query context "Query2" is not the same as data items in query 1 Can you advise how to resolve this. Thanks Sid

Hi How does a singleton query work, as I cannot insert my required data into it? thanks

Hi Basically I have a list report in report studio. In the header I am trying to place items i.e. date range parameters for the report, the employee whose records are being queried. These item are to be sourced from the query, however when i try to insert in to the header it brings up there is...

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