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 - Format Point Labels

Is changing the display format of the Y axis of a column chart supported in the Sept CTP or is it going to be supported in the official release? For example I have built a report model with the numeric sales values set as 'C' for currency and have created a simple bar chart with year on the category axis and sales on the Y axis. The problem is that the Y axis displays as a general number (10000000) and would like to display it as a currency ($10,000,000). I can't for the life of me figure out how to display the Y axis as currency in Report Builder.
When I can create a report in BIDS and set the format to 'C' and upload it via the Reporting Services Web App the Y axis displays correctly.
I check the version of Report Builder I have installed and it is 9.0.1314.0.
Is this a know issue, bug, or not supported in this release of Reporting Services? Any help would be greatly appreciated.
Thanks,
Larry

This is true. If you format a field and display this field value on the point labels on a graph the format doesn't apply. In the Report Design if you go to the Chart properties -->Data Tab -->Values Edit --> Point Labels Tab-->there is an option "Format Code" to format the point labels. This isn't available in report builder.

Is there a work around?

Thanks, Susan

|||

I found a solution for my problem. I created a NEW field in Report Builder and I used the ROUND() Math function to round this field to two digits. I still think that you should be able to format the point labels in a graph in Report Builder. This is a bug.

Thanks, Susan