Search results for query: *

Hello All, in my list report (in cognos 8.3) i am having remcount AmountRemit above both are measures now i am having weighted average as (it is a insertable object)WeightAVG= total ([AmountRemit]*[remcount])/total([remcount]) i have year objects as 2008 and 2009 and 2010 in each year...

hello all, i am having a small report (with crosstab in it) Column Year Rows Currency,Country,productgroups (here i am grouping by these columns for sub totals) then factcells are a calculated weigted average ---> total (sales * noOfItems) / total(noOfItems) so till here i am...

Hello All, in my report i have a simple cross tab, it sinmply contains 1 Cross Tab Row (some date column) , 1 Cross Tab Column ( quarter name) , measure column is some amount. now when i run report it has some 90 rows it is displaying in 3 pages, now the question is how can i set my cross tab...

(i am using Cognos 8.3 Report Studio) Hello All, in my Report, i am having 6 pages in it (ex: London Report, US, World, CAN, IND,EUROPE) each report having 2 queries in it (one for chart, one for list) output is fine, when we run the report and saved it, it will save 6 pages in single PDF...

Hello All, can you please give me a help hand regarding to the below problem presently i have a report with structure as below in report studio (8.3) TransactionDate,Detail,City,Amount,OldBal Nov 1, 2008,paybill for x-x-11-2003,win,-1200.73,710.00 Nov 3, 2008,Call Card,win,33.45,710.00 Nov...

Hello All, some how we get data from different sources to Database table, in our SSIS package, it needs to be write all table data to a .csv file, then it clears the table(by using execute sql task) now the problem here is, when there is no rows in table then it is creating 0 rows .csv file...

Hello All, Can any one give me an idea to handle currency conversion. in my source DB i dont have 1 table which structures as CurrencyFrom, CurrencyTo,Rate columns.(in this table we used to hole only current rate) and one table call transacts (it has all...

Hello All, i have no idea on administration side, however i need to create a report wishing & hoping some bodu can help me..,, please how can i show a report with all users , roles & privilages (what they can do in cognos, ) please help me, Thanks in advance

Hello All, Can you please give me any ideas related to below problem in my report i have a value prompt (multi selectable countries list) this is manually created prompt (inserted one prompt page, then inserted value prompt from toolbox) when i run the report this prompt shows available...

Hello Greetings To All, actually we have 3 same reports(except date condition is different) 1) is short term liquidity (has account no, name, amount) Condition--> Payment Date between today & nextyear same day 2) is long term liquidity(has account no, name, amount) Condition--> Payment Date...