how to send output of my query in Excel to inbox .

[Former Member]

hi,

1. I have created a query

2. executed the in RSRT Tcode and set the broad casting setting.

3. execute the broadcasted settings .

I got that to my inbox also (only hyperlinlk).

Now my doubt how to get the output in excel format to my inbox directly .

I checked the braod caste settings.it only show me MHTML,HTML ,Online link to Current Data

i do not find an excel option there in broad cast settings.

Can any one help me...or even docu's......

Regards

Laxman

[former_member182516]

Hi,

Goto Transaction :RSRD_ADMIN

click on "Settings"

Enter the Technical Name and Descreption of the broadcasting

in the Basis Object

type - BQ - query

technical name - Query Technical name

Content

Distribution type - MAIL

Outputformat - XLS

and click on F8(Execute).

Next goback and select Schedule and enter the scheduling parameters and check.

Regards

KP

[Former Member]

hi ,

Thanks a lot prashant,

i able to do the steps you had explained.

but i got the below errors:

An active RFC server could not be found 1

Error occurred during processing of framework class CL_RSRD_PRODUCER_EXCEL, type PROD

I thought some bg settings are missing.

if you can help on this settings ,please help.....

regards

Laxman

[former_member182516]

Check for the precalculation server is working fine or not?

There are some settings need to be done before broad casting-- check the below links

http://wiki.sdn.sap.com/wiki/display/BI/WikihomeoftheBroadcasting+precalculation