Cross Tab and MS Word

Hello,

I have a cross tab in a report with a grandsTotals row. When I export the report to MS Word 2003 and print it, Word drops this row. You can see it in the print preview and print layout views however. Why is MS Word doing this? Are there any properties I can set in BIRT to fix this problem?

BTW I'm using BIRT 2.3.2.2

Thanks.

Find more posts tagged with

Comments

mwilliams

Hi stuart,

Does this happen with all reports with a grand total column in a crosstab in word? Or just this one?

stuart

Hi Michael,

The report has 4 cross tabs, and only 1 prints properly (all of them have grand total rows).

Stuart.

mwilliams

Stuart,

I've got that same setup at home, Word 2003 and BIRT 2.3.2.2. I'll test it there and let you know.

stuart

Thanks Michael. Look forward to hearing how you go.

stuart

Hi Michael, were you able to observe the same problem with the grand totals row of the cross tab?

mwilliams

Stuart,

Sorry. I did my testing, but forgot to post before the weekend. In my test with 3 crosstabs all with grand totals rows, the grand totals rows printed for all of them. Is there any way you can recreate this issue with the sample database?

stuart

Hi Michael,

Attached is an example report which reproduces the problem where some grand total rows print and others do not. Please let me know if you need more info ... any work around would be greatly appreciated.

BTW I have used a font size of 7 point b/c I need to display (in my actual report) totals for each day of the month across the page and this is the only font size that fits properly.

Thanks

Stuart.

mwilliams

Stuart,

All lines printed for me when I ran it in the web viewer, exported to Word and printed. I have windows XP, Word 2003, and BIRT 2.3.2.2 on the computer I tested on. Not sure why you would be seeing missing totals rows and I wouldn't be.

stuart

Hi Michael,

Isn't that always the case with technology ...

One last comment from me:

To cause the grand total row on the first 2 cross tabs to print in the report I need to drag the bottom boarder of the table, in word, down a fraction. Then these rows then print correctly.

Any ideas?

Thanks heaps for your assistance - hope that you get a break over Christmas from troublesome BIRT users like myself.

Stuart.

mwilliams

Stuart,

That is definitely odd. Maybe it has something to do with the margins set in Word vs. the margins set in BIRT? Not sure since it works for me from the start. Yes, isn't technology great? You could try a newer version of BIRT to see if you get the same issue, unless you have a requirement of 2.3.2.2.