Looks like you just have a typo in your query somewhere. Want to share your query as well?
From: [email protected] [mailto:[email protected]] On Behalf Of Rob Castaneda Sent: Thursday, October 31, 2013 11:33 AM To: [email protected] Subject: [servman] RE: Question about SQL Datawarehouse Report Sorry about that. The error I get when trying to run it is: Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 106 Incorrect syntax near 'ActivityStatusDSStatusDS'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 197 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 216 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 216 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 217 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 217 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 218 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 218 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 219 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 219 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 220 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 220 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 221 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 221 Incorrect syntax near ')'. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 227 Incorrect syntax near '='. Msg 102, Level 15, State 1, Procedure ServiceManager_Report_ChangeManagement_SP_GetListOfRFCs_WithActivities, Line 232 Incorrect syntax near ')'. Thanks From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Travis Wright Sent: Thursday, October 31, 2013 12:00 AM To: [email protected]<mailto:[email protected]> Subject: [servman] RE: Question about SQL Datawarehouse Report Do you have more details on what the issue is? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Rob Castaneda Sent: Wednesday, October 30, 2013 1:54 PM To: [email protected]<mailto:[email protected]> Subject: [servman] Question about SQL Datawarehouse Report Good afternoon or evening I am trying to adjust a report based on the instructions on this website and wanted to know if anyone knows what I am doing wrong? http://www.authoringfriday.com/2013/05/10/creating-custom-reports-in-scsm/ I am sorry if this is the incorrect forum for this and but I am trying to figure things out based on the instructions and am stuck. Any assistance would be greatly appreciated. Thanks, Rob
