Attached is a report with this query:

[font="Courier New"]SELECT

            S.schema_id,

            S.name AS schema_name,

            COUNT(O.OBJECT_ID) AS objects_in_schema

    FROM

            sys.schemas S JOIN

            sys.all_objects O ON

            S.schema_id = O.schema_id

    GROUP BY

            S.schema_id,

            S.name

            [/font]

The report has a list control with a group on schema_id and schema_name which has page break at end set. Then a table and a chart control within the list.

Just remove the ".txt" from the file.