ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Truncation of content/detail randomly (https://www.excelbanter.com/excel-discussion-misc-queries/44565-truncation-content-detail-randomly.html)

oursmp

Truncation of content/detail randomly
 

Hi,

I am working on a VB6 application (using COM PLUS components
extensively), with SQL Server database, that has reports in MS Excel
2003. Most of our reports are working alright but some reports are not
working some times.

When some particular users open some reports, the report opens alright
the first time (say with 100 lines of content). When the same report is
opened again in the second instance, it does not open completely (has
limited content only - say 10 lines only). When we try to close this
report, it gives an error message "The picture is too large and will be
truncated". When the report is opened the third time, it opens correctly
and so on.

We also observed that this happens with excel reports that have a
separate header section in the report.

Not sure why the trunction of content is happening randomly (the first
time a report is opened in an instance it opens correctly. Subsequent
openings are not proper and this is random - some times it works some
times does not).

Any help is greatly appreciated.

Thanks
oursmp


--
oursmp
------------------------------------------------------------------------
oursmp's Profile: http://www.excelforum.com/member.php...o&userid=22443
View this thread: http://www.excelforum.com/showthread...hreadid=466171



All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com