Search results for query: *

I'm lost to see what my problem is. can some fresh eyes take a look and see what I've done. this won't open with the above error. I wrote this a couple of weeks ago. It was fine then. I have to deliver it tomorrow and it goes bizarre. Private Sub Splits_AfterUpdate() Dim RecSet As...

We are running Cognos 10.1.1 against a Sybase IQ database. Whenever we start the cube build we get the error message that says the mdc file is locked, The problem started when the cube build stopped when it hit the 2 gig limit. We removed the 2010 data from the input stream and restarted the...

I have just imported 60 stored procedures into VVM. About 12 return no data when tested in VVM. All the procedures run normally in SQL Server. I am at loss to figure out the problem with these 12. Has anyone run into anything similar I would appreciate any direction to debug this Thanks

Hi, I've been out of Cognos for a couple of years, now I've got a hurry up project in version 10. I need to see the metadata tree in the insertable objects pane. How can I access it. I've been trying for a couple of hours now

I have a situation where my customer wants to run a report by any one of 4 dates. I have this in my where clause: and (case when @DateType = 'Date1' then ([filename].[Date1] between @StartDate and @StopDate) when @DateType = 'Date2' then ([filename].[Date2] between @StartDate and @StopDate)...

This is a pain in the @#$@#$. Report Studio validates every report every time I open it. I am at a new site and no one can tell me why this happens. Any ideas on how I can get it to only validate after the package has been updated? thanks if you can.

I have a parameter ddrive report in COGNOS 8. the data source is a stored procedure with prompts. the SP test good in SQL SERVER and in Framework, but Reportnet returns not data for any paramter except Start Date to End Date. Any thoughts are appreciated

I know this must be simple, but I can not see it. Why are all my Insert field names flagged is invalid?? Thanks Msg 207, Level 16, State 1, Line 17 Invalid column name 'AmtPaid'. Msg 207, Level 16, State 1, Line 18 Invalid column name 'PaidFuelAmount'. Msg 207, Level 16, State 1, Line 19...

I have built .bat files to auto build several cubes. the cubes can be built with a manual start. but the .bat file gets the 'TR3108 transformer could not load User class Information' error I know that this may be because of invalid access time settings for the user class in Access Manager...

Hi, I have an Access Report that prints 4 complete copies of the report. It shows four copies in preview and four complete copies go to the printer. Anyone have this happen to them before??? Also, the report has six sub reports. After the last sub report, it page ejects and the rest of...

I have this query below and it is giving me the error msg: Invalid Column dame 'Retur_Date'. I know it is in the insert statement, but don't know why Here it is: create table #Merge1 ( [Model_No] [nvarchar] (50) NULL , [Return_Date] DateTime, [QtyRet] int not null default (0)...

Please take a look at this and tell me why this line year(a.Date_Return) = b.Rpt_Year gets this error: Server: Msg 170, Level 15, State 1, Line 27 Line 27: Incorrect syntax near '.'. select a.Model_No, year(a.Date_Return) as Rpt_Year, a.Defect_Code, count(*) as DefectCount...

Hi, I can't call a subroutine using a case statement. Will you look at my code and tell me what I am doing wrong? Thanks insert into #ReturnsDetail ( [Build_Date] ) select case [Prod_Line] when 'PT' then set @SerNo = a.[Serial_No] exec sp_PT_Date_Built @SerNo, @DateBuilt OUTPUT when...

Hi, I am upgrading to SQL 2k5. Mainly because I want to get away from T-SQL for stored procedures. I have used a lot of VBA (mostly DAO). What do you think of using VB.net for developing stored procedures. Is it a big change from VBA. Will I need visual Studio? All thoughts appreciated...

I am trying to include a new table in a DTS package. After creating the transform data task. I try to open the properties to define the task. I am locked up for about 30 seconds and then enterprise manager shuts immediately down. I see no error message. How can I get this fixed. All thoughts...

I was checking the security on one machine that runs a common Access application and started the security wizard. It changed the workgroup for the application and now no one can log on. Any thoughts? Thanks

I have a prompted report that ran well in Ver7, but since I moved it to 8, It consists of 5 charts, 1 does not return data. It uses a seperate Stored procedure from the other 4. I am assuming that the link to the prompts is broken, but don't have any idea how to make a connection. Any Ideas...

Hi, I need to select every record in one file, if one field is found in either one of two files the logic is simple Select table1.* if table1.model = either table2.model or table3.name. I think I need to merge the key fields from table2 and table3, then select my records from table1. Can...

I have a DTS problem that is driving me crazy. When I built an upload from BW oracle tables I did not consider one issue. We get data via EDI from Our customer. That data has information by model numbers that differ from our model number. I have built a cross refernece table with their...

I have created an application for our test lab. The last bit is to provide a way for them to attach either an excel worksheet or word doc to a form in a tab control. The attachment could have pictures and data. My guys are great techs, but not PC literate, so what do you think is the easiest...