Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > Crystal Reports
Crystal Reports General discussion about Crystal Reports. For discussions specific to the book Professional Crystal Reports for VS.NET, please see the book discussion forum for that book.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Crystal Reports section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 15th, 2004, 04:23 AM
Registered User
Join Date: Sep 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Run time document insertion

Hi, I have a web based app within which is a module that allows users to generate a set of letters for mailing based on names stored in a sql db. I have used CR to generate the salutation & signature sections of the letter, but hoped to leave the body text dynamic. It is hoped that a user will simply upload a .doc file and this will form the body of the letters, this .doc file will always be saved into the same place & have the same name. The main reason for using .doc is to try and maintain any formatting.

I have tried two approaches to include the doc in the report, inserting on OLE Object and setting it as LINKED, however, the report does not refresh the changed/new doc until the design view of the report is opened and the ActiveX kicks in to update the link - can this update be forced through code? Tried opening an instance of the report and using the .refresh method but it didn't work. I also tried using sub-reports, didn't work either.

Approach two was to save the document in the db in a blob field and push it into the report. However, the report treats the blob field like an image and only shows the "broken-link" icon on the report. If I export the report to either .pdf of .doc it places a different blob field image (used for company logo image - stored in separate table to the document) into the place holder for the document???

Any/All help gratefully accepted
Completely stumped

Similar Threads
Thread Thread Starter Forum Replies Last Post
errors during run-time Chacko C++ Programming 0 March 4th, 2007 02:33 PM
Run time errors Martin Outlaw Excel VBA 2 August 23rd, 2006 05:13 AM
Design-Time or Run-Time now ? ALGNET .NET Framework 2.0 1 July 31st, 2006 04:43 AM
Run time Help Dazzer96 Access VBA 2 May 3rd, 2006 07:03 AM
Run-time error '1004' Document not saved Tucky Excel VBA 0 October 28th, 2004 12:04 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.