Search results for query: *

hello everyone i'm having a rather painful problem. I would like to have three columns on a report. 1st column will add the total amount when the invoice number is starts with 'tr' second column has amount and third column has count of those invoices that have tr. This is not the problem that...

I finally Figuered this one out!!! BOY im i excited ;D here is what i had to do. I created a union then i added some data items in addition to a little case statement CASE WHEN (_days_between({sysdate},[INVOICE_DATE])) between 0 and 30 Then ([Union2].[APPROVED_AMOUNT]) ELSE (NULL) END Hope...

I dont think i have been very clear here is the datediff function I use to calculate the difference between the invoice date and the current date. I have a column called approved amount. What i would like to do is just show the amount when the column meets the criteria below...

thanks for the response i guess my question is should i be puttiing this case statement on the expression of the column? Thats where im having a hard time understanding. Where do i put case statements in cognos besides filters?... Sorry if i'm having a hell of a time understanding here. and...

Yeah but how can I put a case statement based on just the column? I thought they worked like filters.

Hello everyone I apologize if this sounds like a stupid question however I'm a noob to cognos. but what im trying to accomplish with cognos would seem to me very doable. I Have a report that runs base on a calculation filter using the datediff function. It basically calculates the Difference of...

no problem thank you everyone for all your help on this one.

Hello everyone. Thanks for all the replies however i couldn't get my previous code to work but i figured out a different way to get this done. I will posted here in case someone else ever runs into this problem. As XLBO mentioned you cant use "destination" with different workbooks therefore i...

With wb.Sheet("aui01") i still get a object dosesnt support this property error...

thank you everyone for your help. yes both sheets are opened however now i get the object dosent support this property or method. Destination:=.Range("A" & .Rows.Count).End(xlUp).Offset(1, 0)

Range("A" & Rows.Count).End(xlup).... I have actually try that and still get a subscript out of range?... any ideas?

sht.Range("a1:al1").Copy _ Destination:=wb.Sheets("aui01").Range("A1").End(xlUp).Offset(1, 0) Next sht i still keep getting a subscript out of range here? wich i havent been able to figure out. Can anyone help?

I have a few sheets on 1 workbook and would like to copy all the contents of those sheets onto the last used cells of another workbook. im sure is something small im missing. here is my code. Any help would be greatly appreciated. i cant get it to run i keep getting a object variable problem...

Thank you glenn thats exactly what i needed sometimes a small detail scapes me and i spend endless hours working on a project. Also my apologies on putting this post on the wrong part forum.

I've i have 3 worksheets that have about 64k lines and i like to run my macro on all the worksheets. Here is my code those anyone see what im doing wrong? Dim ws As Worksheet For Each ws In Worksheets Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1")...