Crosstab Fit To Page

I am using the 2.3 Birt designer for Eclipse to prototype a report layout. I am using a basic cross-tab report item. I have weeks across the top of the report, shipping locations across the side, and the number of units shipped from that location for a given week as my data items. My page is a US Letter, landscape layout.

My goal was to test the fit-to-page functionality so I specifically included a large number of weeks.

By default all of the cells are shrunk to all be equal size (and thus cutting off their content so only the first few characters of each cell are displayed) when I go to Run -> View as PDF in eclipse.

So, I tried setting my summary and detail cells to 1in wide in the property editor. The cells are indeed 1in wide when I go to Run -> View as PDF in eclipse. However, my report is now split over two pages and not scaled to fit the page.

What do I need to do to get my crosstab to scale to fit a singe page?

Find more posts tagged with

Comments

mwilliams

Hi talmage,

How many columns are you trying to fit to 1 page? Also, what did you change to set the "fit to page" functionality?

mwilliams

talmage,

Are you just using the engine and not the designer?

talmage

For the purpose of my test I am trying to fit 18 1inch columns to a single US Letter Sheet in landscape form.

As for the fit to page funcionality I read on the Birt release notes page that when you do output as PDF the content is automatically shrunk to fit the page. Is this not the case? If it is not the case how do I achieve the fit to page functionality for PDF ouput?

Yes, I am just using the designer at the moment.

mwilliams

talmage,

Yes, the designer already does the fit to page automatically. If you were just using the engine, you'd have to call the fit_to_page function I believe. To my knowledge, the designer will just make the columns equal width like you said. If you give the columns a width, the designer shouldn't shrink them.

If you're doing 18 columns all the time, you may just want to fix the sizes of all the columns and text to fit yourself.

talmage

I need to correct what I said in my original post: It is not spanning the "extra" columns onto a second page, it was just I had too many rows. The "extra" columns are simply being cutoff.

I sanitized my dataset to remove any identifiable information and cut the report down to use two locations and several weeks. I also randomized the units being measured.

I have attached two versions of the output PDF: One where I set the column widths and one where I do not.

As for my correction: When I set the widths it is not scaling the crosstab to fit the page - yes, I know with this many columns it will be tiny if scaled to fit landscape...I am just trying to test out BIRT and see how it handles scaling.

So, how do I get birt to let me set column widths for a crosstab and still have it scaled to fit the page?

j.kassouf

I have the same problem

mwilliams

Can you recreate your issue with the sample database and attach the report in here with a description of what you'd like it to do, rather than what it is doing? Thanks!