How to create publication

[Former Member]

Hi Experts,

Am scheduling crystal report .rpt file in Crystal Server over email, in this case am getting actual report as attachment in mail.

But i want actual report to be sent in mail body instead of sending it as attachment in mail.

i came to know that it is not possible to send report in mail body, but i heard the we can achieve it using publication.

Can anyone please help me in creating a publication and also tell how can i send Crystal report in mail body using publication.

Thanks in Advance.

[abhilash_kumar · Accepted solution]

Hi Ajay,

Publication has an 'mhtml' format that lets you place the report's contents in the e-mail's body. I'm not too sure how well it works though.

Use the search bar to the top right to find more info on this subject or just download the Admin Guide for the version of BO you have from http://help.sap.com

-Abhilash

[Former Member]

Follow the below steps to generate the report details in email message using Publication report.

1. In FOLDERS ->Click on Manage - > New-> Publication

2. Provide Title for Publication

3. select the Source Document - > Add -> Selecte the report.

4. Click on "Format" - > Check the "mHTML"

5. Goto Destination - > Check the "Email" - > Provide the email distribution list

6. In Message - > Paste this Tag line "%SI_DOCUMENT_HTML_CONTENT%"

8. Save and Close.

9. Right click the Publication and Subscribe  it.

10. Schedule the Publication now.

Hope this helps you!!

[Former Member]

Hi Vinay,

In CMC i selected Folders and under Manage i selected New, but after that am not able to See publication.

Am not able to find New--> Publication option, please help me to find this option.

Thanks

[former_member185603]

You have to click on existing folder and right click on 'Right hand pane' , select new and publication. or click on Manager and new- publication

[former_member230417]

Hi Ajay,

Please refer the below blog of Christina which will educate you on the Basics of Publication:

http://scn.sap.com/community/bi-platform/blog/2013/05/23/introduction-into-the-publication-process-a...

Regards,

Nachiket

[Former Member]

Thank you for the step by step list of creating the publication.  The output was not what I expected. 

• Viewing the report in Outlook did not show the correct format. 
• Viewing the report on my iPhone in portrait mode was better, but some of the columns bled out of the table.
• Only viewing the report on my iPhone in landscape mode showed me what the report is supposed to look like.

Is there a setting in the report that I need to change?

[former_member185603]

What version of Outlook you have?

Check below KB article.

  2220051 - BI 4.1 - Webi publication mhtml format shows title at the bottom when vieiwed in Outlook ...

[Former Member]

I do have Outlook 2010.  For some reason, I can't open the link you sent.  I'm getting a password error.  Using the same credentials I use for this site.

[former_member185603]

it is not the same credentials as SCN. To access above link, you need to have S-userID (SAP support Portal).

[Former Member]

How so I get that?

[former_member185603]

If you have support agreement with SAP, you company will have access to SAP support portal. You may need to reach out to someone in your company to get the access

[Former Member]

Thanks.  I have reached out to my Business Objects people.

[Former Member]

Hi Ajay,

Please check below threads you get some information:

Weird formatting with publication to mHTML

Thanks,

DJ