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