Automatically generating PDF files for Customer IDs

system · October 18, 2006, 8:48am

Hi Guys,
I need to do the following, I have a table that contains a Customer ID column and I need to generate a separate report for each customer and the report title should contains the customer id, then sending each report via e-mail as a PDF file. Is it doable in smart way using Webi-XI
If not could it be easy with the DesktopI
Your Ideas are very valuable.

Mahmoud (BOB member since 2005-03-22)

system · October 18, 2006, 10:31am

Hi Mahmoud,

              This is possible using Business Objects SDK beginning from

Linking of database with CDO objects to sending mail throug SMTP

server.

prashil123 (BOB member since 2006-08-25)

system · October 18, 2006, 10:41am

Thanks Prashil for your reply, but could you give me more details? Acually I have a very limted knowledge of the SDK suit but if just guid me to the way I can start from I’ll be very grateful.
Thanks in advance

Mahmoud (BOB member since 2005-03-22)

system · October 18, 2006, 11:19am

Moderator note:
Please, do make an effort to choose a meaningful topic title (and not just “Very complicated request”, etc.). I changed the topic title for you this time

Andreas (BOB member since 2002-06-20)

system · October 18, 2006, 11:26am

Thanks Andreas,
It’s realy more comprehensive .
Looking forward for your valuable advices

Mahmoud (BOB member since 2005-03-22)

system · October 18, 2006, 3:21pm

See this link for emailing using VBA…

https://bobj-board.org/t/15915

BO_Chief (BOB member since 2004-06-06)

system · October 18, 2006, 3:29pm

check this link, specifically last post(code) in the first page… to use two DP’s and generate separate reports…

https://bobj-board.org/t/67910

Ma as salam…

BO_Chief (BOB member since 2004-06-06)

system · October 19, 2006, 12:13pm

Thanks Chief , I’ll check it.
But this will fit with sending it via email as PDF, what about generating a separate report for each customer ID? this is the main issue.
Shokran >>(=Thanks)

Mahmoud (BOB member since 2005-03-22)

system · October 19, 2006, 7:55pm

@Mahmoud:

See my quote above in the post… It is done, and yes it can be done…

Kaifal haal ya habibi…(how are you my friend)

BO_Chief (BOB member since 2004-06-06)

system · October 22, 2006, 1:11pm

Thanks Chief I’ll check it all.
How did you know that Arabic?
May he can meet at the Off topics

Mahmoud (BOB member since 2005-03-22)

system · October 23, 2006, 6:32am

Hi,

The code pasted below will help you to generate PDF some changes are

neccesory . For e-mail you can use this code so that u will get idea for

writing macro for sending macro.

'------------------------------------------------------------------------------

Private Sub Document_AfterRefresh()
For i = 1 To ThisDocument.DataProviders.Item(1).Columns(1).Count
ns = ThisDocument.DataProviders.Item(1).Columns(1).Item(i)
MsgBox ns
ThisDocument.Reports(1).AddComplexFilter “Country”, “==” & “”"" & ns & “”""
ThisDocument.Refresh

ThisDocument.Reports(1).ForceCompute
ThisDocument.Reports(1).ExportAsPDF (“c:\pdf_” & i & “.pdf”)
Next
End Sub

prashil123 (BOB member since 2006-08-25)