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.

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...