Monday, February 04, 2013

I thought I will start updating my blog after a bit hibernation.


So here is a tip for getting rid of the blank page that appears if you use a Next Page After setting in the group section as shown below.


Use the formula Not Onlastrecord


To do this click on the formula section against the Next PAge After setting and type in Not Onlastrecord

Save the report and the last blank page will disappear.

No comments:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...