Deliver Cross Tab output to Users

[__Stephen]

Sorry about the cross-post.

"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.



TIA



__Stephen

 

[S. Justin Gengo]

Stephen,

Depending on how complex your data is you may be able to just use a
datagrid.

I have sample code on my website, www.aboutfortunate.com?page=codelibrary,
that shows how to output a datagrid as an excel spreadsheet. Just use the
search box to search for "datagrid excel".

The drawback? You can only output a single excel tab not multiple sheets.

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche

 

[Mauro Servienti]

Hi __Stephen,

Il Tue, 29 Nov 2005 09:45:52 -0600 hai scritto :

Sorry about the cross-post.

..it stands for italian not for information technology

"Life would be so much easier it we didn't have end users"

without wives (not women, wives) too... ;-)

btw, if your end users all uses Excel 2003 take a look at this great
framework to write Excel 2003 Xml Format, you don't need excel on the
server:
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

HTH,
Mauro Servienti
whynot [ at ] topics [ dot ] it

 

[__Stephen]

message
Thanks for the reply.

Depending on how complex your data is you may be able to just use a
datagrid.

I have sample code on my website, www.aboutfortunate.com?page=codelibrary,
that shows how to output a datagrid as an excel spreadsheet. Just use the
search box to search for "datagrid excel".

The drawback? You can only output a single excel tab not multiple sheets.

Drawback is my SP needs to be re-written.

That is why I have it in a cross tab.

Currently I have 7 columns. Customer, Text description of the business
period, Sorting version of the business period, Sales, Shipping, Shipping
sircharges, tax.

I present to the user
Client | total of 2 years Prior | total of last year Prior | Monthly through
current year | Total for current Year
-->Revenue
-->Shipping
-->AdShipping
-->Tax
---->>>> Total line for Client. for each coulnm listed above.


So this could get real ugly without using a cross tab to display in a
datagrid. Or did I miss some class that does the voodoo for me?

 

[__Stephen]

Hi __Stephen,

Il Tue, 29 Nov 2005 09:45:52 -0600 hai scritto :


.it stands for italian not for information technology


without wives (not women, wives) too... ;-)

btw, if your end users all uses Excel 2003 take a look at this great
framework to write Excel 2003 Xml Format, you don't need excel on the
server:
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

thanks. I have it downloaded and am searching in the docs for crosstab.