Recent content by globalbear

Hi, I put an extra loop in your code. Think it should do the trick. Public Sub FillBlanks() Dim lngLastKnownVal As Long Dim pntr As Long Dim lngLastRow As Long ' ALL Data in column A must be numbers lngLastRow = Cells.Find("*", Cells(Cells.Rows.Count...

I understand you want to see which interior color number that is defined for a specific cell. Here's one way: Sub a() iRow = 1 iCol = 1 oRow = 1 oCol = 2 Cells(iRow, iCol).Select c = Selection.Interior.Color Cells(oRow, oCol) = c End Sub This code will output the interior color of cell...

Confuse-a-cat-limited... Which blue arrow are we talking about here? There is one arrow pointing to the left just right of the house-icon. That arrow would take you back to where you where before. The arrow I mean is on the next row, pointing to the right. The tooltip for this icon is "Run"...

You don't need to close the report and invoke it again to resubmit new prompt values. Just run the report again by pressing the blue arrow. That should force you to choose a new prompt value.

I don't think I follow you now Swathi. If you use 'starts with' you don't need to concatenate with '%'. In SQL you would use something like 'select Custname from myTable where myTable.Custname like 'whatever%' In Cognos you would filter on something like '[CustName] starts with ?MyParameter'...

How about adding one more prompt where you enter a value, e.g. "WAN". Then filter the second prompt with [CustName] starts with ?Parameter1?

Could anyone explain the difference between setting up an event for a report in event studio and setting up a report schedule? I use Cognos 8. Is Event Studio schedueled to run at a pre-defined time or is it actually listening to the database in real-time like an SQL-trigger? Confused...

Thanks for your reply, but that will not do the trick for me. I don't want to add a new data source. I want to change data source from test to prod for the entire project. All tables etc. are identical for the two data sources. However, I found a way of doing this yesterday: *Find the Project...

Sounds like you should use a Union to connect the two queries. A union work like this: Query A: Row1 Data1 Row2 Data2 Row3 Data3 Query B: Row4 Data4 Row5 Data5 Union: Row1 Data1 Row2 Data2 Row3 Data3 Row4 Data4 Row5 Data5 The union works like a query of its own. You should be able...

I have developed a project in Framework mngr that connects to a data source called "Test". I have built a package on this project and constructed som reports on that package. Now, I have finished my project and my reports and want to change the data sorce from "Test" to "Prod". I would like...

OLE DB

This query will give me all transactions for a specific journal in the general ledger: SELECT COMPANY, FISCAL_YEAR, ACCT_PERIOD,CONTROL_GROUP,LINE_NBR, ACCT_UNIT, ACCOUNT, BASE_AMOUNT, R_SYSTEM FROM LAWSON.GLTRANS WHERE (COMPANY = 10) AND (CONTROL_GROUP = 2) AND (R_SYSTEM = 'GL') AND...

I am using Reporting Services to connect to an Oracle database. How do I manage to use parameters with Oracle? Example: I want to select all transactions from a certain period. I set up a parameter called Period. If I would have an SQLServer DB it would be fine to filter the Period-field with...

I am trying to compare two date fields in Reporting Services. I suppose I should use the datediff-function but I am not sure of the syntax. I noticed that the following line will give me the day six months from now. =DateAdd(DateInterval.Month, 6, now()) But how do I compare date1 with date2?

Yes of course you could. Try changing the line For col_copy_from = 1 To 4 to the number of cols you prefer. A better way of course would be to change 4 to a variable such as For col_copy_from = 1 To last_col But then you have to figure out how to give last_col the correct value - that one I...