How to i automatically export data into Excel Format?

Question

How to i automatically export data into Excel Format?

shivani sharma-428076

SSC-Addicted

Points: 429
More actions
April 23, 2007 at 8:16 am

#370609

How to i automatically export data into Excel Format?

Ya i mean when user click on report it should open directly in excel format instead og HTML format.I don want to subscribe reports i is on demand report but user wants to open when he clicks view report it should direclty open in excwl format.Pls let me know how i can achieve that.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

What do you mean. Do you have a report you want people to access and when they do it provides Excel without the definition or how exactly?

jvElecenter SSCarpal Tunnel Points: 4502 More actions · Answer 2

the users need to subscript the report.

Is a property of the report. So they can ask excel output being sent to their mail.

JV

Antares686 SSC Guru Points: 125444 More actions · Answer 3

It really depends on how you manage it. The current interface does not allow for setting to render Excel only. But you can setup subscriptions to email to folks, or even just drop an excel file to a location they can download from if this is not an on demand report.

Another way is to integrate your own Reporting Site derived from Reporting Services and using the sample in the Reporting Services install you can make a .NET control of the report presentation console. I have made several adjustments to mine to allow uses to set several options. One also forces the item to be render directly to Excel and not the html format.

sqltung Hall of Fame Points: 3962 More actions · Answer 4

Another option is to setup a "linked server" to an Excel file and use SQL to write to the file. You could setup the Excel file with the title, headers and such ahead of time.

Malcolm Bee SSC Veteran Points: 271 More actions · Answer 5

Shivani,

The keyword here is 'automatically'

Please provide a scenario of what you wish to achieve

If users wish to receive a report on a regular basis in Excel format (either delivered via email or onto a file share), then we can set up a subscription through the report manager to enable this

If users wish to generate their own Excel representation of a report then they simply use the export option on the report toolbar

Cheers

moe_mayne SSCommitted Points: 1933 More actions · Answer 6

I think what he is asking for is to be rendered out in Excel instead of HTML.... and i think this might be accomplished by tweaking the ReportViewer.aspx page... i think in there is where you can tell it to render out in what format you want...

Moe C

Steven Adams-443677 Valued Member Points: 66 More actions · Answer 7

Wouldn't this involve altering code in examples such as:

http://www.codeproject.com/sqlrs/PDFUsingSQLRepServices.asp

to take the generated file, and have the response send back the appropriate MIME type headers and then the data from the file. (apologies for newbie errors)

Ben Sullins-437405 SSCertifiable Points: 5397 More actions · Answer 8

URL Parameters work too

http(s)://MyDomain.com/ReportServer/ReportPath/Report?

&rs:Format=EXCEL&rcmitFormulas=true

http://ezinearticles.com/?URL-Parameters-Used-in-Reporting-Services&id=176858

Cheers,

Ben Sullins
bensullins.com
Beer is my primary key...