SSRS report with multi-column content and fixed dimensions?

You can use a Tablix to allow your data to be displayed in two columns.

You can use a Tablix to allow your data to be displayed in two columns. For the rows in the tablix you can leave "CanGrow" as "true" to ensure that it wraps and you will need to set grouping on your datasource based upon year. You may need to set up a new field in your database that is set to only the year, then you can create a group on that field in your report.

If this is SQL Server, you can add the following to the end of the "SELECT" statement before the "FROM" statememt ,DATEPART(YEAR,DateField) AS Year For "End of column" and "End of Transcript" you will use grouping. You can set group headers and footers to display messages as required. Tutorial on setting up groups: database.blogs.webucator.com/2010/09/10/... Update in response to op comments: In addition, you can use expressions in to group on for data, so you can probably group with the following expression: =FORMAT(Parameters!YearField.

Value,"yyyy").

Setting up a column grouping on year won't really work (since the data for any one year only takes up a small portion of the page), and, there is usually going to be 4 years worth of data. I have considered trying to add additional data into the dataset to group on (based on the amount of data from the SP), but, would rather not have to go that route (because it would get messy). – Bill Jul 25 at 12:44 What do you mean by "course/grade information cannot break up a given year"?

If you mean you want that data averaged or aggregated in some other way, then delete the details row and only use a footer row and use AVG or SUM expressions as required and group on an expression like I just posted. If not, let me know. I know we can resolve this stuff :) – Frank Pearson Jul 26 at 18:30 Sorry...I meant that a given year's information cannot get broken up across columns.

Also, I want to avoid trying to set up a column grouping by year since there isn't any hard and fast way to ensure the data gets broken up correctly (for example, academic year w and x fit in one column and academic years y and z). – Bill Jul 29 at 18:35 You should be able to use KeepTogether to true and wrap each row's cells content in a rectangle to ensure that they are not broken up between pages. That way you can get one or many years on a single page, and still ensure that you don't break any individual year up.

Does that work? – Frank Pearson Aug 1 at 15:40 KeepTogether on the contents of the rectangle. – Frank Pearson Aug 1 at 15:49.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.