I have a report containing many tabs that I need to save as PDF.
One of the report tabs will contain some commentary, i.e. some text, which is maintained in Word and is usually many pages of text. I want to find a way of inserting this commentary into one of my report tabs.
I’ve tried Insert, Object…into a cell in my but the contents of the Word doc are then truncated, plus when you save as PDF the page appears empty.
I’ve tried placing the text in Excel, then using the Excel as a DP but there are restrictions on length of 255 character, which I am way above.
I’ve tried copying the text into a Memo field in Access, then using the Access as a DP, but looks to be a known bug as only 1,000 characters are displayed in BOB (see link below). Not sure which version this applies to?
What I used for a client is upload a PDF document with text into the repository and add a link in my report to that document. This might be a solution for you as well.
When I copy and paste text from the Word doc into a cell in the report, only the 1st page of the Word doc gets copied…don’t know why. It’s nothing to do with number of characters though, because if I reduce the font size in Word so more text is on the first page, this additional text gets copied
Even after copying text into the cell in my report, when you save as PDF, it does not appear in the PDF document.
Have you double clicked on the cell horizontally and vertically so that all the contents copied are visible and fits into the cell in BO.
The save as PDF should work for all the pages as seen in BO
Thanks for your response…Yes I have made sure the cell size is large enough in BOB, it definitely only displays the first page from Word, despite doing a Ctrl A copy and Paste…which is very odd.
Having said, I still have the 2nd problem of the text not appearing after saving the BOB report as PDF…the Report tab is there but it just shows an empty box.
Not sure about the version you are using v5.1.2 having issues copying text to a cell.
Cannot reproduce it since the version is already obsolete.
If you have 6.x installed check in that if it has same problem.
Yes, I suspect you are right…it’s probably the version (v5.1.2) is the problem…I don’t have a later version here to confirm.
Do you have any thoughts on the 2nd point…even when I do copy and paste SOME text into a cell, if I then save as PDF it appears as an empty box in PDF…does the same happen if you do this?
I have 6.x version and save as PDF shows all the text copied to a cell even if there are lots of pages of text.
I think again the version should be the cause since it must be using an old PDF writer version to convert to PDF.
Put few lines of text in the cell and see if PDF shows it.
Or try from another machine.
Then add a report tab and let users fill in their comments.
Or if you are using XIr2 then there are components like discussions, Encyclopedia which can be attached to a report.
The Encyclopedia component requires a Premium license key. The Professional license key does not provide access to this component.
I have 10 reports, users will see these reports and they will want to make some comments on them (each report will be seen by more than one user, so for each report there can be different commentary).
Now what I want is to capture all these comments and write them back to the database, and then build a new report which will capture all this commentary.
my question is whether it is possible to use BO for writing back to the database (maybe there is some option in BOXI r3) or like you said the discussions. Are these written to the database?
(BOB member since 2006-11-09)
(BOB member since 2004-06-06)
(BOB member since 2004-03-02)
(BOB member since 2005-07-18)
(BOB member since 2006-12-15)