Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved import pdf files from my computer to dw report

  1. How-to
0
Votes
Undo
  1. ahmed tawfik
    ahmed tawfik
  2. PowerBuilder
  3. Wednesday, 10 July 2024 09:53 AM UTC

Hi All

I have report that retrieves data from  a table and put in tabular form

each row has a pdf files linked with it (I save path of pdf files for each row in other table "the path of each files related to each record does not appears in the report" - 

also I do not save any blob in database

 

after I retrieve data  in tabular form

I want to import pdf files from its path related to every row and display it at the end of report   -  for each row in the same order

can i do this with PB12.5 ?

if not

can I do this  with PB19 R1?

Thanks in advance for any help

Ahmed Tawfik

 

 

 

 

 

Extract file from OLE BLOB and save to disk
Windows could not connect to SQL Server after tls ...
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 10 July 2024 11:53 AM UTC
  2. PowerBuilder
  3. # 1

Hi Ahmed ;

     As you probably know, PB does not handle native PDF data streams. So one solution could be to convert the PDFs into something like plain text or rich text to have the DW Report display / print these attachments at the end.

     In PB 2022 R3 though you have a native Web Browser control. In that control you could display the the PDF. So while displaying the DW Report, you could also display the PDF file(s) in the WB Control adjacent to the DE Control or have a Command Button in the report where the App user could have the App open say a Response window displaying the related PDF for a given row. For printing, you could use the PrintdataWindow() for the report followed by printing the Web Browser's content right after to achieve what I think that you are looking for.

https://docs.appeon.com/pb2022/objects_and_controls/WebBrowser_control.html

     Another approach with PB 2022, would be to save the report as a PDF file using the new NativePDF feature in Appeon PB. Then use the new PDFObject class to merge the DW report PDF with the related PDF attachments to create one contiguous report. Then again print the merged PDF report using the Web Browser control.

https://docs.appeon.com/pb2022/objects_and_controls/PDFObject_object.html

Food for thought ... HTH

Regards .. Chris

Comment
Load more comments
Andreas Mykonios
  1. Andreas Mykonios
  2. Thursday, 11 July 2024 12:28 PM UTC
PB 2022 R3 supports merging pdf's. So it provides an answer to you original question. There are to many tools that can process pdf's. You can even create a cmd tool, using PB 2022 R3, that will merge your pdf files, and then call it from PB 12.5.

Andreas.
  1. Helpful
Andreas Mykonios
  1. Andreas Mykonios
  2. Thursday, 11 July 2024 12:29 PM UTC
Chris already provided that info.

Andreas.
  1. Helpful
ahmed tawfik
  1. ahmed tawfik
  2. Thursday, 11 July 2024 14:11 PM UTC
Hi Andreas

So the the answer of original question is to use pb 2022 r3

I changed the related file to be jpg

So you can negelect the original one

My question now is how the report displays all rows then displays each jog image linked with each row in separate page sequentially

When finish I print this report to pdf files and send this file to end user

Any help of this new question ?
  1. Helpful
There are no comments made yet.
David Peace (Powersoft)
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 10 July 2024 11:51 AM UTC
  2. PowerBuilder
  3. # 2

Hi Ahmed

I suppose the real question has to be: how are you going to render the PDF files within the PB DW report? DFs are typically rendered in a browser or PDF viewer, there is no such embedded technology in PB.

How would you attempt this in another language? I'm struggling to envisage the final report as each row will create a new page for the PDF report embedded. Surly it would look a mess.

The only thought I have is perhaps merging the PDFs together, but will only work if you are not reporting any data from your table.

Sorry not a huge help.

 

 David

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.