How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters SyteLine 7.02 1) Checkout stored procedure (usually [always?] Rpt_XXXSp.sp) VSS Database Name VSS Database Path VSS Project SL7.02 App DB \\tomcat\SyteLineDev\ $/ApplicationDB/Stored Procedures 2) Modify code 3) Load & test in Query Analyzer MSSQL Server sa Password Database CATBERT\SL702 OH_App 4) Checkout report (XXX.rpt) VSS Database Name VSS Database Path VSS Project Working Directory SL7.02 App DB \\tomcat\SyteLineDev\ $/Reports \\sl7patch\fsTaskMan\Report\Reports 5) Open report in Crystal 8.5 from Working Directory Terminal Server (remote development) BPTerm a) Database / Set Location… i) [Set Location…] (1) [Options…] (a) Untick Tables, Tick Stored Procedures, Leave Views Ticked (b) OK (2) Expand ODBC (3) Expand SL7.02_OH_Dev (or a DataSource configured similarly to the table below) (4) Expand Stored Procedures (5) Select OH_App.dbo.Proc(Rpt_XXXSp;1) (6) [Set] ii) In Table field, remove prefix "OH_App." iii) [Done] b) "Propogate location changes across subreports with the same original locations?" [Yes] c) That sometimes brings up the Verify Database dialog where you pick Sp parameters. If not, Database / Verify Database… Your new parameters should appear in the list. i) Enter a logical value for each parameter; NULLs may work for everything. Nick Thurn Page 1 1/11/2017 How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters ii) OK d) Scroll down to and Double-click on "ReportNotes.rpt" e) Database / Set Location… i) [Set Location…] (1) Expand ODBC (2) Expand SL7.02_OH_Dev (or a DataSource configured similarly to the table below) (3) Expand Tables (4) Select OH_App.dbo.ReportNotesView (5) [Set] ii) In Table field, remove prefix "OH_App." iii) [Done] f) Save Data Source Name Data Source Description Server Database Language Translate Character Data Log Long Running Queries Log Driver Statistics Use Integrated Security Use Regional Settings Prepared Statements Option Use Failover Server Use ANSI Quoted Identifiers Use ANSI Null, Paddings and Warnings Data Encryption SL7.02_OH_Dev CATBERT\sl702 OH_App (Default) Yes No No No No Drop temporary procedures on disconnect No Yes Yes No 6) Checkout Form Configuration Name Terminal Server (remote development) SL7.02_OH_Dev DevTerm a) Modify parameter-list passed to Run Background Task (usually [always?] BGTaskParms variable) to include your new parameters. 7) Test! Report Results Directory \\slpatch\fsTaskMan\Report\OutputFiles\yourid 8) Checkin Nick Thurn Page 2 1/11/2017 How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters SyteLine 7.03 1) Checkout stored procedure (usually [always?] Rpt_XXXSp.sp) VSS Database Name VSS Database Path VSS Project SL7.03 App DB \\cmhvss01\vss\SL7.03App $/ApplicationDB/Stored Procedures 2) Modify code 3) Load & test in Query Analyzer MSSQL Server sa Password Database CATBERT OH_App 4) Checkout report (XXX.rpt) VSS Database Name VSS Database Path VSS Project Working Directory SL7.03 App DB \\cmhvss01\vss\SL7.03App $/Reports \\wilala-w2k\Taskman\Report\Reports 5) Open report in Crystal 9 from Working Directory Terminal Server (remote development) BPTerm a) Database / Set Datasource Location… i) In the Current Data Source box, highlight “Rpt_XXXSp;1” ii) In the Replace with pane: (1) Expand Create New Connection (2) Expand ODBC (RDO) (a) Highlight SL7.03_OH_Dev or CATBERT (or a DataSource configured similarly to the table below) (b) [Next] (c) Enter the sa password (d) [Finish] (3) Expand OH_App (4) Expand Stored Procedures (5) Scroll down & Highlight “Rpt_XXXSp;1” iii) [Update] (Your Data Source appears in Current Data Source box) iv) [Close] b) Database / Verify Database… Your new parameters should appear in the list. i) Enter a logical value for each parameter; NULLs may work for everything. Nick Thurn Page 3 1/11/2017 How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters c) d) e) f) g) ii) [OK] iii) Alert-box appears: “The database file “Rpt_XXXSp;1” has changed. Proceeding to fix up the report!” (1) [OK] iv) Alert-box appears: “The database is now up to date” (1) [OK] v) Dialog appears: OLE DB (ADO)… Choose a data source from the list (1) [Cancel] Save Scroll down to and Double-click on "ReportNotes.rpt" Database / Set Datasource Location… i) In the Current Data Source box, highlight “ReportNotesView” ii) In the Replace with pane: (1) Your data source / OH_App should still be expanded. If not, expand as described above. (2) Collapse Stored Procedures (3) Expand Views (4) Scroll down & Highlight “ReportNotesView” iii) [Update] (Your Data Source appears in Current Data Source box) iv) [Close] Database / Verify Database… i) Alert-box appears: “The database is now up to date” (1) [OK] Save Data Source Name Data Source Description Server Database Language Translate Character Data Log Long Running Queries Log Driver Statistics Use Integrated Security Use Regional Settings Prepared Statements Option Use Failover Server Use ANSI Quoted Identifiers Use ANSI Null, Paddings and Warnings Data Encryption CATBERT CATBERT OH_App (Default) Yes No No No No Drop temporary procedures on disconnect No Yes Yes No 6) Checkout Form Configuration Name Terminal Server (remote development) Nick Thurn SL7.03_OH_Dev BPTerm Page 4 1/11/2017 How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters a) Modify parameter-list passed to Run Background Task (usually [always?] BGTaskParms variable) to include your new parameters. 7) Test! Report Results Directory \\wilala-w2k\Taskman\Report\OutputFiles\yourid 8) Checkin Nick Thurn Page 5 1/11/2017 How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters SyteLine 7.04 9) Checkout stored procedure (usually [always?] Rpt_XXXSp.sp) VSS Database Name VSS Database Path VSS Project SL7.04 App DB \\USCMHSLDB1\Vss\SL7.04App $/ApplicationDB/Stored Procedures 10) Modify code 11) Load & test in Query Analyzer MSSQL Server sa Password Database USCMHSLDB1 OH_App 12) Checkout report (XXX.rpt) VSS Database Name VSS Database Path VSS Project Working Directory SL7.04 App DB \\USCMHSLDB1\Vss\SL7.04App $/Reports \\Uscmhslu1\fsTaskMan\Report\Reports 13) Open report in Crystal 9 from Working Directory Terminal Server (remote development) USCMHSLTS1 a) Database / Set Datasource Location… i) In the Current Data Source box, highlight “Rpt_XXXSp;1” ii) In the Replace with pane: (1) Expand Create New Connection (2) Expand OLE (ADO) (a) Select Microsoft OLD DB Provider for SQL Server (b) [Next] (c) Enter values as shown in table below (d) [Next] (e) [Finish] (3) Expand OH_App (4) Expand Stored Procedures (5) Scroll down & Highlight “Rpt_XXXSp;1” iii) [Update] (Your Data Source appears in Current Data Source box) iv) [Close] b) Database / Verify Database… Your new parameters should appear in the list. i) Enter a logical value for each parameter; NULLs may work for everything. ii) [OK] Nick Thurn Page 6 1/11/2017 How to Resynchronize a Crystal Report after Changing Stored Procedure Parameters c) d) e) f) g) iii) Some times an alert-box appears: “The database file “Rpt_XXXSp;1” has changed. Proceeding to fix up the report!” (1) [OK] iv) Alert-box appears: “The database is now up to date” (1) [OK] v) Dialog appears: OLE DB (ADO)… Choose a data source from the list (1) [Cancel] Save Scroll down to and Double-click on "ReportNotes.rpt" Database / Set Datasource Location… i) In the Current Data Source box, highlight “ReportNotesView” ii) In the Replace with pane: (1) Your data source / OH_App should still be expanded. If not, expand as described above. (2) Collapse Stored Procedures (3) Expand Views (4) Scroll down & Highlight “ReportNotesView” iii) [Update] (Your Data Source appears in Current Data Source box) iv) [Close] Database / Verify Database… i) Alert-box appears: “The database is now up to date” (1) [OK] Save Server User ID Password Database USCMHSLDB1 sa OH_App 14) Checkout Form Configuration Name Terminal Server (remote development) SL7.02_OH_Dev USCMHSLTS1 a) Modify parameter-list passed to Run Background Task (usually [always?] BGTaskParms variable) to include your new parameters. 15) Test! Report Results Directory \\Uscmhslu1\fsTaskMan\Report\OutputFiles\yourid 16) Checkin Nick Thurn Page 7 1/11/2017