Make sure width of the "body" area is less then width set in the report layout

For parameters query:

SELECT 0, 'All'

UNION

SELECT id, text

FROM table1

For data retrieval:

CREATE TABLE #IDS (ID int)

IF @ID = 0

   INSERT INTO #IDS

   SELECT id FROM table1

ELSE

   SELECT id FROM table1 WHERE id...