Report Design & Layout

Hi Everybody, i have been having problems in design & layout of the following report .
i need the report layout as follows a
-
HP- FIELDS IN HEADER OF PAGE -REPEATED IN EVERY PAGE.
HR- FIELDS IN HEADER OF REPORT-ONLY ONCE ON 1st PAGE OF REPORT.

i have created a table report in the body of the report as follows.

HP - In Page Header, i have placed some text and page no
HR - In Table Header, i have placed some text & fields.
HP - In Group Header 1, i have some text & fields. & RepeatOnNewPage = true
HR - IN GROUP HEADER 1, text & fields, which i want to repeat on only 1st page.
(this is were i am having problems to set the group header for the table to
to repeat only on 1st page)
HP - In Group Header 1, some text & fields
DETAIL- some fields.

I would really appreciate your help, or any changes in design & layout of the report.

Thanks A lot IN ADVANCE
Sud

As I understand your issue, you have three rows in Group Header 1, the first row you want to repeat on every page, the second row you only want it to show on the 1st page, is this correct?

You can try creating two groups with the same group expressions. Put the first row in the first group and mark it RepeatOnNewPage. Put the second row in the second group and don't repeat it.

Report Builder limitations

Can anyone confirm the following?

1. Can't add images to reports.

2. Can't have fields in a non-tabular layout (e.g. mailing labels, letters, etc.).

3. Can't control column or row spacing of fields or have details that span more than one row.

Thanks.

Alrighty then. Can anyone at least tell me if there are any 3rd-party products out there that might be more robust than Report Builder?

|||

I use Visual Studio .NET to create reports. I am able to do all three. I will explain how if you need it, however if you use a different program to create reports I am not sure.

- Glenda

|||Yeah, I'm talking about design tools for end-users.|||

1) In the current version you can have images pulled from database. You need to have a model entity with an attribute of type binary (corresponding to your image column) and you need to edit the attribute to specify the right MIMType. After that you can drag the attribute into report and you will see images. In Yukon SP1 we are adding support for images embedded in report itself.

2) Yes, it will be hard

3) You can change width hieght of columns and rows in report builder

|||Thanks for the response. I look forward to SP1.

Report Builder - Error!

I defined a report through the Development Studio of SQL server 2005 which has got a grid and a chart in its layout. If i try opening the same report through the Report builder I get the following error. Why is it so?

======================================================
Cannot open this item
The report cannot be opened in the report builder.
Object reference not set to an instance of an object.
======================================================

And also, by default the Report Builder provides the layout of Matrix, grid and Chart. Does that mean that I cannot define reports having the mixed element like a chart and a grid in one single report?

-- Muthu

Report Builder does not generally support opening arbitrary reports created in SQL BI Development Studio, although you may get lucky occasionally. No, in this release Report Builder does not support multiple data regions in the same report.