Skip to Content
0
Jan 13, 2012 at 09:28 AM

Report Values not shown on report.

31 Views

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