Microsoft Report - Free Form

Is there a way to build a ssrs report that is free-form, i.e. =not matrix or tabular.

Currently to do this I have just added textboxes to the report, however I am unsure how to add grouping and sorting so that it shows one record per a page.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You have to have a table of some kind.
either a reg. table or matrix
In matrix you can have texboxes free floating but you have to have a group to produce more than one record per page.
Megan BrooksSQL Server ConsultantCommented:
You can do certain kinds of free-form things in SSRS 2008, by using a few tricks. It could be harder in SSRS 2005, but might be possible depending on what you want to do.

Some of the tools available are:
  • Hiding and showing rows and columns based upon whether fields are present in the dataset (hiding columns doesn't work so well in SSRS 2005, though)
  • Using custom code or a custom assembly to dynamically map fields to report columns by constructing the query at run time
Two questions:
  1. What version are you using?
  2. What exactly do you want to do? A picture might help. You might simulate a view of the report in a spreadsheet and attach it here.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
spen lang  are you still having problems with this report?
spen_langAuthor Commented:
Projected eneded
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.