Email Subscription Reports Not Rendering Correctly 1

[pabowen]

I have a report that I have set as an email subscription being sent out on a timed basis. The report is being sent as a Web Archive.

When the report is recieved some of the matrix tables are being cut off and are not displaying all columns. What I receive is this

1st table displays correctly (longest table)
2nd table displays correctly (short table)
3rd table cuts off mid column halfway across table (medium width table - at the point where the page ends if you did not scroll over)
All remaining tables cut off at the same point.

The point where it cuts off is at the edge of the page, if you were not to scroll over. But it allows you to scroll over and work fine for the first table.

Is this a bug? Does it only create the graphic up to the edge of the screen if it is not displayed within the viewer window?

Any ideas on how to get around this?

I tried submitting it as an excel file as a substitute, but it would only show the first 3 pages (as worksheets) and lost all remaining data from the report.

Thanks Everyone, I appreciate the help.

Patrick

 

[Catadmin]

Question, is it cutting off on the horizontal (bottom) edge of the page or the vertical (right) edge of the paper?



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[pabowen]

It is cutting off on the vertical edge. More specifically it cuts off at the edge of the screen.

To explain better: If I am looking at the matrix (and have not scrolled right at all) I can see the first part of the table fine. If I scroll right, I find out that it is immediately cut off from where the right side of the screen had previosly ended.

This only affects results that are not displayed on the first page when the report is generated. (you have to scroll down for it).

I hope this provides better info.

Thanks,
Patrick

 

[ookete]

Are you viewing this in the web-based report viewer, or are you looking at a final export such as a PDF file?

 

[pabowen]

I am looking at the final report inside of Outlook. It was emailed out as a subscription with the format of a web archive.

I just made a discovery! If I make any change in outlook to how it is viewed (font size, etc.) regardless of what the change is, it will re-render the drawing of the tables and show correctly. I must do this each time I open the email however.

So I am wondering if this is more of an issue with Outlook (outlook 2003 in my case).

I have to find a better answer though, I can't ask customers to change their view settings every time they recieve a report.

 

[Catadmin]

Check the layout of the report and the Matrix. In report properties, it will tell you the size of the "paper", and if you scroll to the right in layout you'll be able to see if your table & objects extend over that edge. Don't forget to take margins into account.

You may simply need to resize the body of the report along with any objects that extend that far.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[pabowen]

That wasy the Key Catadmin! It was hard to find because the report grows on its own as the results columns are dynamic. But once I increased the size of the report to 17inches it worked great. Thanks!

Patrick

 

[Catadmin]

Anytime. @=)




Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???