Recent content by nevets72

Lisa, Thanks....I was able to run the SP by using: Exec Rpt_ActsAndFore 'Jan 1 2002 12:00AM' The connection type is in fact ODBC, and I'm utilizing SQL Server 6.5......do you think I need to make a change within Crystal Reports somewhere? The date/time structure seen above is used in other...

Lisa, Thanks for your response....I actually set it up that way at first, but I kept getting the following message: Syntax error converting DATETIME from character string. Additionally, when I tried to execute the stored procdure by itself in SQL server, I received: Procedure Rpt_ActsAndFore...

Hi everybody......I tried to open a report, but got the message below (I don't understand why this message comes up.....I've defined date_val in the stored procdure.....any ideas what I should look at? Thanks!)....... Procedure Rpt_ActsAndFore has no parameters and arguments were supplied...

That's it.....I checked the table, and it does have a trigger! I don't know how I overlooked that. Thanks guys!

Hi....I'm trying to delete a record from a table, but I get the following message: Attempt to insert the value NULL into column 'Employee_Type_ID', table 'staftrak.dbo.Outlook_Total'; column does not allow nulls. UPDATE fails. Command has been aborted. The column 'Employee_Type_ID' is an...

Hi....I want to call a stored procedure from within another stored procedure, but when I go to save the stored procedure, I keep getting: Invalid object Name 'Rpt_UnderAlloc.' I'm able to call a View (Rpt_ActForp2), but I can't call the Stored Procedure.....why can't I do this? Here's my...

Hi.....I've got a stored procedure in which the following code exists: SELECT * FROM Rpt_ActForp1 Where Date <= @date_val AND DatePart(yy,Date) = DatePart(yy,@date_val) UNION ALL SELECT * FROM Rpt_ActForp2 Where Date > @date_val AND DatePart(yy,Date) =...

Hi....I'm looking at a VB project that has a form with a TabStrip object......there are 3 tabs (Employee, Team, and Status) associated with the TabStrip object. Each of these tabs appears to be associated w/ a PictureBox (picOptions(0), picOptions(1), and picOptions(2)). By default, when...

Hi....has anyone encountered this problem? I want to modify the SQL Query (which can be accessed by clicking on 'Database' on the Tool Bar, and then by selecting 'Show SQL Query'). I'm able to modify the FROM and WHERE clauses, but the SELECT clause doesn't get updated.....why is that? It...

You guys are awesome....thanks for all your help.....I ended up throwing all the data I needed into a table, then executed a view out of Crystal Reports which read the table.....kind of like what MalcolmW suggested.....and it worked, so thanks again for all of your suggestions!

BP, I'm confused as to why you'd want me to remove the Union section....I did that, and the report runs fine, but I need the info from the Rpt_Actuals_MA view, hence the Union. Maybe I'm misubderstanding what you're saying? Thanks for the reply though! The Rpt_Actuals_MA view utilizes 11...

That's where I'm confused.....I am able to run the entire query successfully in the query analyzer, but it bombs when I try to create the report. Any ideas?

I just attempted to create a Crystal Report, via a view, but I got the following message: The query and the views in it exceed the limit of 16 tables. I'm not sure what options I have.....I really can't create a table based on the functionality of the application I'm using. What can I do...

Thanks guys....I used the: SELECT DISTINCT Job_Code, SUM(Hours) FROM #Temp_Table7 GROUP BY Job_Code and that worked.

Here's a problem that I thought would be simple, but I can't seem to get it to work.......I've got a temporary table with 2 columns. The first column is Job Code, the second column is Hours billed to that Job Code. There are only 8 different Job Codes, but my table has about 900 rows. I...