Stephen, I haven't don this yet so I may be WAY off base but if you guys are using office XP I think you can have Excel consume a web service you great that delivers the data and Excel is simply the "client" I am not sure how difficult formatting and formulas will be but this will allow you to reuse code if it works as I think it does. Worth looking into. Again this is something I think I remember reading about months ago in a magazine so I may be way off.
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Russell Sent: Tuesday, November 29, 2005 10:07 AM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Deliver Cross Tab output to Users "Life would be so much easier it we didn't have end users" :) I have an ASP.NET app that delivers a cross tab report to our Accounting Department. CFO just demanded that all of HIS reports are to be delivered in Excel format. Current version of Crystal is out of the box .NET version. Data is via a SP on my SqlServer. I don't like the idea of just putting into a new spreadsheet the call for data. I can't trust them to ever refresh it. So how do you folks deal with this from your users? I have been informed that we don't want to just throw money at this, (purchase crystal) but we look for other alternatives. No I don't want to load Office on the server either. I just don't trust M$ enough yet. Stephen Russell DBA/Developer Transaction Graphics Inc. Office: 901.312.7621 Fax: 901.312.7655 [EMAIL PROTECTED] This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. This message has been scanned by Modus Gate Anti-Virus/Spam technology. Yahoo! Groups Links ************************************************************************* This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
