Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: asini
  • Order by date
  1. asini

    how to show each year as column in list report

    Hi blom, really appreciate your immediate response, here i tried as you suggested but it shows irrelevenat and very larger values in the output year columns i did as, here i forgot to tell you one thisn year attribute is a datamember (created & calculated in report) as RemYear ==-->...
  2. asini

    how to show each year as column in list report

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

    How to Custom Aggregates for Group level of Crosstab

    Any one please you can take own example just i want to get weighted average group level in crosstab please.................. asini
  4. asini

    How to Custom Aggregates for Group level of Crosstab

    Please Kindly any ideas is it possible at all????
  5. asini

    How to Custom Aggregates for Group level of Crosstab

    Could anyone please.....
  6. asini

    How to Custom Aggregates for Group level of Crosstab

    Could anybody please share any ideas please please Thanks in advance asita
  7. asini

    How to Custom Aggregates for Group level of Crosstab

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

    how Format Cross tab resuts Top to bottom, then left to right

    Any Open Ideas..,, please feel free to share your thoughts regards bujji
  9. asini

    how Format Cross tab resuts Top to bottom, then left to right

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

    How to split Cognos report (PDF) into multiple pdf's

    hello can any one please.....
  11. asini

    How to split Cognos report (PDF) into multiple pdf's

    (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...
  12. asini

    how to calculate running total based on two column values

    thanks for all whom ever tried at least to help me Dear All, it may helpful to some others running-total([Amount]) + [OldBal] - [Amount] works fine this idea given by Jurri (Master) Regards asin
  13. asini

    how to calculate running total based on two column values

    Hello All, kindly any ideas please basically the problem is need to calculate running total for a column (initiat start is stored in another dataitem) this initial data item contains only one value
  14. asini

    how to calculate running total based on two column values

    Please Help me any idea please.....
  15. asini

    how to calculate running total based on two column values

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

    how to check no of records in a table

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

    Currency Conversion handling in FM model

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

    How to show all present users in cognos

    Hello Ties, Thank you very much for your valuable information, i am checking into it in the PDF (installation & Admin Guides) i will go through it Thank you very much for your reply Best Regards asin
  19. asini

    How to show all present users in cognos

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

    how to set default values in Value Prompt

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

Part and Inventory Search

Back
Top