Not sure if this is a true Sesame (generated) issue or an Explorer issue.

I can send a report to Explorer, all 30 retrieved records print out to the screen, however if I do a "print preview" I show only one page with one record on it, and then explorer stops responding. I've tried doing a direct print from the retrieved records, and explorer locks up. The one time I did get something to print out it looks like maybe printer code.

I've tried this on three separate pc's with the same results. I can print anything from the net, and also records from another database.

Any thoughts? Am leaving work, but will return early Saturday morning. Thanks for any insights.

Fred

Ben, I sent the files, and then also sent a follow-up email - DON'T WASTE YOUR TIME ON THIS FOR NOW.

Looks like it may be a Server issue. I can't open any databases - too many users - and I'm the only one here. Also, cannot access my \Sesame\dwgs\ files or my \photos\ files (per the .log file). This is probably what is hanging Explorer.

Trying to contact my SysAdmin to reset Sesame Server.

Regards,
Fred

Well, I'm headed in the right direction. I'm able to get out "short" reports (1-3 records) and everything appears normal. I did two reports each consisting of 3 records. When I tried to have one report with all 6 records Explorer goes into its "Program Not Responding" routine. Looks like a memory problem.

We just switched computers from one running Windows 98SE to XP Pro SP2. I'd point to that as a probable cause, except that might not explain why all three computers have the same issue, although now that I think about it, my computer is the only one I ever ran these reports from. In the past, I could easily send 50-60 records, complete with photos and prints, to the SAME printer I'm currently trying to send to.

So next question - how can I print more records? Memory reconfiguration? Is there a limit in XP Pro as to the number of records I can print? I wouldn't think so. Any direction would be greatly appreciated.

You might also check both your local and networked print queues to see if you have one or more bad docs stuck in the queue.

PROBLEM SOLVED - but not totally understood.

I copied everything from the network to my pc and ran the program from there with the same results as before. I then took everything home and ran it there with the same results, eliminating network and printer drivers as the issues.

I then began looking at the individual records and images. I found several images to be rather large (181k vs normal 45-60k) so I resized these. I was then able to get more than the first record to be displayed in Explorer (preview report). I was getting the first 14 records, hanging on #15. I then looked into the database and record 15 had no image associated with it, so I put in a "false" one. I was then able to see up to page 20, whcih did not have an image either. I put false images in for all records that didn't have one, and was able to print out my entire report.

So, I get my report, but what if I don't have/want an image with a record? In the past, these records printed out fine without images associated with them. Our goal is to have an image with every record anyway, I just don't understand what might have changed.

Thanks to everyone who gave input in helping me problemsolve this. I learned a lot of things along the way.

Fred

Hi Ray - at home I'm using IE 6.0.2900.2180.xpsp2....

Just for clarification so that we're talking the same "Preview":
When I generate the report ReportName (Preview) EVERYTHING works as expected and I see all records on the screen, both the ones with and the ones without associated images. If I choose File-Print Preview I see only the first record (2 pages) unless I make the .jpg files smaller and ensure all records have an image associated with it. When I select Print is when the program hangs and I get the "Program Not Responding" message.

I didn't include the four images used with this report when I sent the files to you, so you are probably seeing the report without images, so naturally everything will work well. Would you like me to send them?

Regards,
Fred

Hello Fred,

The "both pages" was the preview of the original HTM report that you had sent me. It only had a few records in it, and since I had no images to go with that report it only took up two pages.

Yes we are taking about the same preview, the one from inside IE.

I just ran the report on all 30 records and IE Print Preview shows me 25 pages with images on most of the pages. It took a little while to display them in the Print Preview window, still under a minute, but my computer was also runnng a few other tests at the time.

I just sent you an e-mail that has the report that I ran here and Print Previewed here just fine. Save it down to your computer and try to do a File->Print Preview. Let me know if it works.

-Ray

Fred,

Ray is out sick today. He'll pick this up with you tomorrow.