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...
...= MIN
(Actual_Calendar.Actual_Calendar_Date )
FROM Actual_Calendar
WHERE Actual_Calendar.Actual_Calendar_Closed = 0
SELECT * FROM Rpt_ActFor1
Where Date <= @date_val AND
DatePart(yy,Date) = DatePart(yy,@date_val)
UNION ALL
SELECT * FROM Rpt_ActFor2...
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...
...I can't call the Stored Procedure.....why can't I do this?
Here's my code:
CREATE PROCEDURE Rpt_ActForp @date_val varchar(10) AS
BEGIN
SELECT *
FROM Rpt_UnderAlloc
Where Date <= @date_val AND
DatePart(yy,Date) = DatePart(yy,@date_val)
UNION ALL
SELECT *
FROM...
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?
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...
...Actuals_Percent_Allocated,
Project_Description, Actuals_Date, Manager_Last_Name, Manager_First_Name,
Job_Code_Description) SELECT * FROM Rpt_ActPrjEm
I thought I needed to use a pound sign, but I get an 'Invalid object name #Temp_Table'. I also tried the above without the pound sign and...
Well, I did cut and paste it into a SQL query window, and it worked! That's why this is confusing.....something within Crystal Reports is preventing me from doing a UNION.....some property or condition has been set to prevent it as far as I can tell.....what that is, I have no idea, or no idea...
Hi.....not sure if someone can help me or not....I made some changes to an SQL Query within Crystal Reports, specifically performing a UNION.....however, I get the following message:
(SQL Server)All queries in an SQL statement containing a UNION operator must have an equal number of expressions...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.