Hi try ISnull function in sql Query isnull(columnname,'0') something like this

Create Group by Id --Right click on group->group properties->Page breaks-Page breaks options --select the check box.

if you don't want group field in table you can delete that column (select Delete...