topic send report through email in QlikView

send report through email

Tue, 14 Jul 2009 13:58:57 GMT

Hello guys,

Please look at the attached example .

All I want is to send the report name "test" to an email.

How can I do that?

Is it possible ?

thanks

David

send report through email

johnw — Wed, 15 Jul 2009 01:22:30 GMT

If you just mean doing it manually, right click on the report, copy to clipboard, image, then paste into the email.

If you mean automatically sending an updated version of the report in an email on a scheduled basis, it's not really directly supported. In version 9.0, you can apparently send reports as PDF files in email. In earlier versions, you'd probably have to cook up a way to automatically export the image, build an email, and attach the image. I have a similar requirement, but I haven't looked at it closely because I'm happy to wait until we upgrade to 9.0, and if it doesn't turn out to be easy, to simply train the user to open up the QlikView file with the report.

send report through email

Wed, 15 Jul 2009 01:31:11 GMT

We're just getting started with QlikView 9 Report "Bursting". It requires QlikView Server (and Publisher?). You can automatically send out reports based on a schedule. You can also do automatic reloading, reduce data and even use Section Access. It seems to be very powerful. We're just starting to scratch the surface.

You may be able to create a macro that can assist in sending out e-mails. I expect this would be a somewhat manual process (user clicks a button to initiate the e-mail). I've used VB Script to handle it using other applications and by creating an Outlook object (for example) you have control over most of the properties of the e-mail.

send report through email

johnan — Wed, 15 Jul 2009 15:51:39 GMT

Hi, I've have a solution thats sends the email in HTML. You cannot reload the document with Publisher because the publisher doesn't support Macro.

send report through email

Wed, 15 Jul 2009 15:51:48 GMT

Thanx John,

There isn't really a clever way to do in manualy....

send report through email

johnan — Wed, 15 Jul 2009 16:01:39 GMT

I reload my app with windows Scheduled Tasks, and the email goes away automatic.

send report through email

Wed, 15 Jul 2009 16:35:56 GMT

The more automated way you have is to create a report in Qlivkiew with the data you want to see.

Then create a macro that will export the report as pdf and send it by email. The macro will print the report using Qlikpdf printer in order to save it in a temporary location. Then the macro will generate an email with the pdf file generated as an attachment.

There are some examples on how to generate this macro on the forum.

send report through email

Thu, 20 Aug 2009 14:19:36 GMT

do you hav an example on generating the pdf from report in macro?

//Regards Carl Johan

send report through email

johanlind — Mon, 04 Oct 2010 07:43:03 GMT

I'm also looking for an example. Where can I found some?

//Johan

send report through email

nathanfurby — Mon, 04 Oct 2010 10:05:10 GMT

Since QlikTech have changed the PDF Printer provider the methods have also changed from the 'old' way of manipulating registry keys. I have just posted an example on a seperate thread:

http://community.qlik.com/forums/t/17253.aspx

send report through email

Mon, 04 Oct 2010 10:30:45 GMT

Our company created a tool (vb.net), which copy object to excel/pdf and send it to users by email by schedule.

Ramunas

send report through email

nathanfurby — Mon, 04 Oct 2010 10:36:49 GMT

Can you promote yourself a little better? Link to website or something?

send report through email

Mon, 04 Oct 2010 10:44:43 GMT

Nathan,

Regarding this tool please send me to r.balukonis@veritana.lt , I'll send you a small description.