Search results for query: *

Hi Team I have some data that changes and gets an update date whenever a field is changed. I am trying to report when a row has changed. I can get pretty close if I take out the update date using a group by in conjunction with a dedup query but am not convinced I am getting the correct values...

I have a macro that cycles through some data and creates worksheets named with the data. After I have created the sheets I want to delete them and keep the ones named so that it is ready for the next cycle. The code I have Dim wks As Worksheet For Each wks In ActiveWorkbook.Sheets...

Hello, I have data in multiple columns and rows in a spreadsheet. I want to start at cell A1, read the value, perform some functions then move to A2 and so on until all the data in that is read I then need to go to the next column so it would be cell B1. Some sample data is below: 170A 150B...

Hi All, I have created a stored procedure in an Oracle 8i database. I am using an Impromptu V6 report to retrieve the value sucessfully. The report uses the following: call EDM.PROCWRSTCUSTCOUNTS(?strStartDate? IN, ?strEndDate? IN, ?TotalCusts? OUT, ?15PerTotCusts? OUT, ?15perUCMOS? OUT...

I was after some code for Oracle that gave me a financial year by months with running totals and not being an expert thought something would be available on the web but couldn't find it anywhere. The financial year in this case was from the 01/04/2004 to 31/03/2005 but with a small modification...

Hi Team, I am running a macro in 6.6 on my PC that opens two reports in the same session of powerplay. the code is: [code] option explicit sub main dim objPPApp as object dim objPPFilterReport as object dim objPPChartReport as object dim objFilterReportRow as object dim sDateFound as string...

Hi Team, I have a field that is in minutes called DurationMinutes. I can calculate the days by doing DurationMinutes / 1440. This will give me a figure with a decimal eg 3559 minutes = 2.471527 days. I would like to get the remainder of .471527 and convert it to minutes by * by 360...

Hi Team, I am using Webi 6 to create my reports. I have created prompts in my Universe with the All functionality as described: (@Select(Sales Geography\Country Group) IN @Prompt('Select Country Group or enter * for all groups','a','Sales Geography\Country Group',multi,free) ) OR ('*'...

Does anyone know if the inbuilt Microsoft Calendar function be called in a CognosScript Macro. If you do a code sample would be good. Thanks in advance. binway