Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-15 : 07:21:00
|
| Sarika writes "We are using SQl Server 7 and Crystal Reports 8.5 along with Visual Basic 6.Our Crystal report is using stored procedure as data source.This stored proc is dynamically populating a table say "A" with data from various tables and returns the data from TABLE A to crystal report.It is required to clean the contents of table A everytime the stored proc is called, and then populate it dynamically.But If "TRUNCATE TABLE A" statement is written in the begining of the stored proc, then the stored proc if run thru Query Analyser shows perfect result.The same stored proc is called thru crystal report also shows proper result.But if this crystal report is called thru VB form, then it shows no data.If the TRUNCATE TABLE A is removed from the stored procedure then only report call thru VB shows data.We would like to know how to clean data from table that needs to be populated dynamically, in such cases." |
|
|
|
|
|
Use of dynamically populated table for crystal report.