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

Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build?

What are the limitations of using Report Builder with SQL Server Databases?

Report Designer is the tool for building complex reports. In Report Builder you can only build simple reports such as a single table, matrix or graph.

The value in report builder is in creating fast ad-hoc reports without having to specify a query first. Report Builder is designed to work with SQL databases, but you have to create a model of your database first. You can do this automatically in Report Manager and then customize your model using Model Designer