Lantica User Forum - Report Apprears To be corrupted

(UTC)

Lantica User Forum › Archived Topics › Archived Topics › Report Apprears To be corrupted

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: [1] 2

Send Topic

Print

Hot Topic (More than 10 Replies)

Report Apprears To be corrupted (Read 4863 times)

wildwood Full Member Offline No personal text Posts: 156 Location: New York Joined: Apr 2^nd, 2004	Report Apprears To be corrupted Oct 19^th, 2004 at 1:40am	Print Post
	When I preview a report after sorting all my records it appears fine as an HTML file. However when I try and edit it in Word it begins to open it in word and then i am told the file appears to be corrupted. However when I sort and use only a partial amount of the records it loads up fine in Word. How is the file corrupted when all the records are sorted but not when only a portion of them are retrieved? Peter


	IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Report Apprears To be corrupted Reply #1 - Oct 19^th, 2004 at 2:20am	Print Post
	How are you looking at the report in Word? Are you Print Previewing the file and then saving the file from your browser as HTML file and then opening the HTML file in Word? OR Are you printing the report to a file and then opening the file in Word? If Yes, what file extension are you using when printing to file? OR What other method are you using to edit the report in Word?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

wildwood Full Member Offline No personal text Posts: 156 Location: New York Joined: Apr 2^nd, 2004	Re: Report Apprears To be corrupted Reply #2 - Oct 19^th, 2004 at 3:02am	Print Post
	Basically I Print Preview. then when it opens as an htm file i merely click on the File tab and click on Edit with Microsoft Word for Windows. I havent saved any file as yet.


	IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Report Apprears To be corrupted Reply #3 - Oct 19^th, 2004 at 4:53am	Print Post
	Ok, thanks for explanation. What browser/version are you using? It sounds like you have Word as default editor also. I suspect this may be related to the caching of the html page contents. I haven't tested this yet, but before you try to edit, try scrolling down to the very last record. Then open File, Edit. Or try scrollling to the end and then Save as HTML document. Then use Word (default editor for your browser) to open the saved file. Or try using a different editor to open the Saved HTML file. Do you still get the same results?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

wildwood Full Member Offline No personal text Posts: 156 Location: New York Joined: Apr 2^nd, 2004	Re: Report Apprears To be corrupted Reply #4 - Oct 19^th, 2004 at 4:30pm	Print Post
	I'm using Internet Explorer 6.0 as my browser. Word is the only word processor I maintain on my computer. I have tried going to the last record on the print report preview but the results are the same.


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Report Apprears To be corrupted Reply #5 - Oct 19^th, 2004 at 4:47pm	Print Post
	Does the same file open in MSWord, if you open it directly rather than going through IE?

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

wildwood Full Member Offline No personal text Posts: 156 Location: New York Joined: Apr 2^nd, 2004	Re: Report Apprears To be corrupted Reply #6 - Oct 20^th, 2004 at 7:30pm	Print Post
	How does one open the same file in MSWord directly rather than going through IE??


	IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Report Apprears To be corrupted Reply #7 - Oct 20^th, 2004 at 7:46pm	Print Post
	When looking at report in IE, do File, SavePageAs, and enter location and filename, ending with .htm Now you can open Word and read the file, using File, Open, change the type to HTM, and get from the location used when you did SavePageAs in step above.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2480 Joined: Aug 20^th, 2003	Re: Report Apprears To be corrupted Reply #8 - Oct 20^th, 2004 at 7:46pm	Print Post
	Hello Peter, First run a report with all the records in preview mode. In the address bar for Internet explorer, You will see the address which will look something like "C:\Sesame\My_Report_2004_10_12_14_31_53.htm You will want to copy the entire path from the C:\ to .htm by selecting it and hitting CTRL C. Then open Microsoft Word. Click File Then click Open Click in the File Name Box at the bottom Hit CTRL V Hit the Enter Key Let us know if it loads, Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2480 Joined: Aug 20^th, 2003	Re: Report Apprears To be corrupted Reply #9 - Oct 20^th, 2004 at 7:52pm	Print Post
	Quote: When looking at report in IE, do File, SavePageAs, and enter location and filename, ending with .htm It is not recommended to do a File Save As. This action would muddy the waters, so to speak, because IE(Microsoft) is saving the report. The HTMl file already exists on the hard drive under Sesame's Working Directory really all you have to do is go there and load it.

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Report Apprears To be corrupted Reply #10 - Oct 20^th, 2004 at 8:14pm	Print Post
	Good catch Ray. I was forgetting that the report was already saved on the hard drive.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

wildwood Full Member Offline No personal text Posts: 156 Location: New York Joined: Apr 2^nd, 2004	Re: Report Apprears To be corrupted Reply #11 - Oct 20^th, 2004 at 8:19pm	Print Post
	Ray I followed your exact directions and it did the same thing prompting a: "Your File appears to be corrupted" message.


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Report Apprears To be corrupted Reply #12 - Oct 20^th, 2004 at 8:22pm	Print Post
	How large is the file?

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

wildwood Full Member Offline No personal text Posts: 156 Location: New York Joined: Apr 2^nd, 2004	Re: Report Apprears To be corrupted Reply #13 - Oct 20^th, 2004 at 8:54pm	Print Post
	The C:\...html file is 64.7 KB The DB file is 167 KB The DSR file is 151 KB and The DDT file is 198 KB


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2480 Joined: Aug 20^th, 2003	Re: Report Apprears To be corrupted Reply #14 - Oct 21^st, 2004 at 12:14pm	Print Post
	Hello Peter, Could you please send me the HTML Report along with your .DB and .DAT, preferably zipped, to Support@Lantica.com so that I can have a look at it. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Page Index Toggle

Pages: [1] 2

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge