Friday, February 24, 2012

Limitations in Report Builder?

I'm using Report Builder. I have a NameAddress entity that I want to have printed on the report. There is only one "Drag and drop column fields" box on the "design report" screen. Every field I drop in there goes from left to right. Is there a way to reposition the headers/fields, so that I can have something in the following format:

First Name: xxxxxx Last Name:

Address 1

xxxxx

Address 2

xxxx

City: xxxxx State: xx Zip: xxxxx

Everything I drop in there goes from left to right. I want to position things "anywhere" on the screen, and be able to split the column headers apart from the data.

Basically, how do I get this tool to work like access report designer. Just a simple access report?

Thanks,

Michael

Background:

I have upsized an Access DB into sql server 2005.

I created a model and published it, and now I am trying to simulate a user's day to day ad-hoc report creating activities. They previously used access 2003 reports to do this.

We want to users to use Report Builder, because we don't want them in bi-dev.

Report Builder has only basic layout support in this release. Multi-row or freeform detail layout is not supported, although it is on the list for a future release.

|||

Thanks.

No comments:

Post a Comment