Search results for query: *

Hi Swathi, Did you try using 'for' in the running-total calculation? I think if you compute running-total for Service,Internal then it should give the output as expected. Hope this helps... Regards, Sharat

Hi, There is a dedicated chapter for Performance optimization provided in Documentation PDFs: Mastering Impromptu Reports --> Part 2: Reporting Environment --> Chapter 6: Optimize Performance in Impromptu. Hope this helps.... Regards,

Hi, You can make use of the 'Blank' template and then insert List reports each populating data for master and child queries. Regards,

Hi Stacy, Whatever Flex has suggested is correct....so I would request you to verify the same in FrameWork Manager and also the 'Aggregate' option set for it. Though for a fact it by default sets the aggregate option to Sum... Regards,

Hi, You can use the Stored Procedure template to create an Impromptu report provided the output parameter of the stored procedure is of ref cursor type.... Hope this helps... Regards,

Hi, Is your first query related to the second query ? Regarding your second query, we can drill through from a value in the parent report's main query to a main query in the child report. So, if we try to drill-through to a report whose main query doesn't contain the selected column then...

Hi, Time-based Partitioned Cubes are a new deployment option available in Cognos Series 7 Version 2. Similar to a cube group, Time-based Partitioned Cubes are made up of a collection of child cubes. The differing factor is that Time-based Partitioned Cubes allow you to access the collection of...

Hi, You could try applying outer-join between the tables to fetch all records from 'po' even when 'notes' don't have them. Hope this works... Regards,

Hi Prasad, Probably this could be one of the reasons for ur problem... By default excel cells are not formatted to handle multi-line text. It is only if you format the cells and check the 'Wrap text' option the whole text becomes visible.... Sharat

Hi debdas, This could be a solution to ur problem... dayname(to_date(number-to-string(20020101),'YYYYMMDD')) :-)