Dear Forum
I have an existing report that uses a stored procedure in MS SQL, the stored procedure creates a temporary table and populates it with data via a select
If during execution my select statements result in no data i have an insert statement to insert a default row. This is for the purposes of displaying a message within the report to explain no result were returned.
If i run the report where the select is inserting data to the temp table the report works well.
If i run my existing reports in the no data mode no data is displayed and recognised by any of the report sections. If i right click on a field and select browse data the data is shown within the browse data list. Bu no section will display the default data.
thinking i am going mad.........
I have created a brand new report using the same stored procedure and replicated the above and the results are displayed as expected including my no data mode results.
I suspect my first report has become corrupted in some way but did not want to go through recreating the report(s) (about three of them) as this would involve about 6 days report design 😔
Does any forum member have any experience of such an event. Any suggestion on how i can recover this would be greatly appreactiated.
Help Please..........
Thank you all so much in advance
Paul Marks