BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

Ole object -word doc - CR2016


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
bosupportdev
Principal Member
Principal Member



Joined: 15 Nov 2009

Posts: 115



PostPosted: Sun Mar 18, 2018 3:21 pm 
Post subject: Ole object -word doc - CR2016

Dear all,
Could you plse advice on the following:
I have form kind of customized template in wprd doc, users expecting the report in the same format.
Hence i took the template and embeded as an ole object however my question is can i place the report fields underneath the header of the ole worddoc?

Ex:i have a “Name” field in the form (ole object) and i dragged the namefield from the reexplorer into the template.

Instead me Replicating the entire form in the crystal repot using sections/boxes etc....?
Is there any disadvantages using the OLE embeded objects?
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1843
Location: Atlanta, GA


flag
PostPosted: Wed Mar 21, 2018 12:40 pm 
Post subject: Re: Ole object -word doc - CR2016

I don't think you can do this with an OLE object that is a Word document. Also, if your document extends to multiple pages, you will definitely not be able to do this because Crystal will only render the first page of the document.

There are a couple of work-arounds available, though.

1. If this will only be 1 page per record, I believe you can put the Crystal format reference to fields - e.g. {MyTable.MyField} - in the text of the document and it will automatically fill in the fields.

2. Another thing I've done for filling in forms is import an image of the form into the report in the section where it needs to be and then place the appropriate fields on top of the image.

For either of these, you can only work with a single record. If your report has any table-like areas where you need to show multiple detail records you'll need to recreate it in Crystal with the correct sections, etc.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
bosupportdev
Principal Member
Principal Member



Joined: 15 Nov 2009

Posts: 115



PostPosted: Mon Apr 16, 2018 3:35 pm 
Post subject: Re: Ole object -word doc - CR2016

Thank you.. for the Input,..
Yh , For the details sections, I used the Subreports within the forms.. i.e
Instead {MyTable.MyField} Isues.. Subreport, This helped to show the details of multple records..
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0295 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0260)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo