Recent content by Tomadams

got it - Thanks for responding

I put a break on the statement but I don't understand what you mean by use the tool to see what's going on in the connection. Can you explain?

hey skip recset.open is the highlighted code tom

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

Gotit to work this way: (case when @DateType = 'Date1' then ([filename].[Date1] when @DateType = 'Date2' then ([filename].[Date2] when @DateType = 'Date3' then ([filename].[Date3] when @DateType = 'Date4' then ([filename].[Date4] end) between @StartDate and @StopDate Thanks folks!

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)...

Thanks, I have been doing a lot of validation of existing reports and not saving. I will do a save on exit and relieve myself of the pain. thanks for the insight

Got it Thanks

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 have the same issue using Cognos 8.4 and SQL Server 2008. I have validated the port as haripali suggested and still I cannot make connection. Any thoughts. this is critical and highly visible. thanks

Nope. I am just testing outside as a query ouside of a stored procedure