multi line text / newbie

[R7Dave]

Hello - I am new to reporting services and have a few questions.

I am trying to display 3 fields: an ID (integer), a name varchar(50), and a description that can be a max of varchar(500).

I used a Table from the Report Items and selected "Expression" to pick from Fields(DataSet1)

The data part works fine but how do I set text to allow multiline? I want the report to be "tightened up" so that there aren't huge spaces when the data has 50 characters or 500 chartacters.

Also, where do I go to make sure the data fits on one page? (...and not 2 coumns on one page and a third on another)

Sorry if these are easy to find answers but I haven't been able to find solutions and I need to get this going fast. Any answers or good resources are appreciated.

Thanks in advance
Dave

 

[bburnell]

Just based on my mostly CR experience and SRS experience (so far), you could make the field the minimum size and use the "can grow" proerty in the fields you want to do that. There's also a property for "Can increase to accomodate contents" as well.

As for being on one page, there's a property to "keep data together" (or something like that). There's also the property to "Make new page before" and "make new page after" as well.

I hope that helps!
Brett

--------------------------
My new website coming soon!