Print Page | Close Window

Run SQL Script from report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13965
Printed Date: 22 Apr 2025 at 9:29pm


Topic: Run SQL Script from report
Posted By: alikmb
Subject: Run SQL Script from report
Date Posted: 03 Aug 2011 at 10:01am

Hi!

I have CR11 and SQL Server 2005. I created Stored Procedure to Delete all records from table and than base on Select Statement Insert back to this table new records base on parameter sent from Crystal Report. Later, I use this table as a Data Source for other report.

I created report base on this Stored Procedure and created Parameter in this report. However, when I run the report it just Alter Stored Procedure and do not run it. (do not' execute the script for Delete and Insert).

Any suggestions how to handle this situation? Thanks at advance.

Alec.


Print Page | Close Window