c#, custom reporting.

Necuno

Necuno

Court Jester
Joined
Sep 27, 2005
Messages
58,566
Reaction score
3,437
need: ability to generate custom report with custom layouts :sick:

lol, o well - the only way i can see so far is to write some code that will interpret the layout from a drag and drop control, write that to a form of xml (xsl or rldc) and do the transform with it and show the report.

any other ideas ?

or just return the whole table and have them fix it up in excel :D
 
ok... there is SSRS, which as client report builder :)
 
What's the specific need? Would your users need to pull any data from the system in a format that they choose?
 
FarligOpptreden said:
What's the specific need? Would your users need to pull any data from the system in a format that they choose?
Click to expand...

it was basically custom report ability on a contract management system, they were able to make up their own reports with custom headings and items then add a header and footer to it - in end 'print to excel'. (very basic)

but after running it past my boss; it the implementation 's time and energy outweighs the total use of such a custom report facility to using it now and a then to see reporting on project. Also bit of an overkill vs what the endusers are able to use and their level of report building.
 
Last edited:
Oh, alright then. Well, if you ever need help on writing a DataTable to an Excel sheet, I wrote a very helpful class to export to Excel 2007, without the need to reference any of those bulky Office libraries. The idea was just utilizing the OpenXML framework (which all Office 2007 documents are built upon), together with the SharpZipLib Zip library. Works wonders.
 
FarligOpptreden said:
Oh, alright then. Well, if you ever need help on writing a DataTable to an Excel sheet, I wrote a very helpful class to export to Excel 2007, without the need to reference any of those bulky Office libraries. The idea was just utilizing the OpenXML framework (which all Office 2007 documents are built upon), together with the SharpZipLib Zip library. Works wonders.
Click to expand...
Yes please. I'm busy with Word documents right now, and it sounds like I could learn from your class.

@Necuno: Our typical solution for this type of thing is to generate a CSV that can then be opened and played with in Excel. So far we've not had a single comeback.
 
FarligOpptreden said:
Oh, alright then. Well, if you ever need help on writing a DataTable to an Excel sheet, I wrote a very helpful class to export to Excel 2007, without the need to reference any of those bulky Office libraries. The idea was just utilizing the OpenXML framework (which all Office 2007 documents are built upon), together with the SharpZipLib Zip library. Works wonders.
Click to expand...
cool, please share :)

Raithlin said:
@Necuno: Our typical solution for this type of thing is to generate a CSV that can then be opened and played with in Excel. So far we've not had a single comeback.
Click to expand...
more or less what i will be doing.
 
I've written 3 classes that write data in a DataTable to:
- Excel 2007 (including table formatting and filters): Returns path to .xslx file
- CSV: Returns string representing .csv data
- HTML: Returns string representing .html file

I'll see if I can get the files uploaded somewhere to share to ya'll...

EDIT: Maybe I can just add them into a .dll file and share as a complete library of exporting goodness :p
 
....of we could pm you our email address :p
 
FarligOpptreden said:
I've written 3 classes that write data in a DataTable to:
- Excel 2007 (including table formatting and filters): Returns path to .xslx file
- CSV: Returns string representing .csv data
- HTML: Returns string representing .html file

I'll see if I can get the files uploaded somewhere to share to ya'll...

EDIT: Maybe I can just add them into a .dll file and share as a complete library of exporting goodness :p
Click to expand...
I'm most interested in checking out the code - I want to try do the same with Word.
 
FarligOpptreden said:
Oh, alright then. Well, if you ever need help on writing a DataTable to an Excel sheet, I wrote a very helpful class to export to Excel 2007, without the need to reference any of those bulky Office libraries. The idea was just utilizing the OpenXML framework (which all Office 2007 documents are built upon), together with the SharpZipLib Zip library. Works wonders.
Click to expand...

I'd like to have a look at what you did because I am trying to write code to format a Excel 2007 document, but struggling a bit and I can't find any samples!

Sent you a PM.
 
MielieSpoor said:
I'd like to have a look at what you did because I am trying to write code to format a Excel 2007 document, but struggling a bit and I can't find any samples!

Sent you a PM.
Click to expand...

:confused: Didn't receive any though... What helped me was a little OpenXML book I got at a Microsoft Interop day a few months ago. I've scoured that book many times and eventually figured out all the necessary documents.

Also, try creating an Excel 2007 document with just ONE sheet. Save the document somewhere, rename the extension to .zip and extract it. Et viola, a perfect sample of SpreadsheetML. :) All the relationships between the XML files can become a bit confusing at times, but keep with it. There's also a .rels file defining the relationships in almost every directory. That forms the base of the document.

I struggled for a few days getting the format exactly correct, as Excel kept on saying some table cells were problematic. I found that my .rels files weren't all in order. :p
 
FarligOpptreden said:
I've written 3 classes that write data in a DataTable to:
- Excel 2007 (including table formatting and filters): Returns path to .xslx file
- CSV: Returns string representing .csv data
- HTML: Returns string representing .html file

I'll see if I can get the files uploaded somewhere to share to ya'll...

EDIT: Maybe I can just add them into a .dll file and share as a complete library of exporting goodness :p
Click to expand...

finally i can have a looky; damned noobs that kept me away :D

-thnx for the pm and code mailed :)
 
...not yo be too daft here; Custom_Report.xlsx is as "a zip" and office 2007 would open this correctly via openxml ?
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X