Reporting Frameworks
-
What happened that nearly got you fired for using SQL Server Reporting Services ? I'm looking at using it for a current project as dropping a reportviewer out of visual studio takes care of the pdf export. If it's likely to do something that gets me fired then it'd be useful to know about it in advance. Thanks
-
Any chance there's an article? I would definitely be interested in reading it.
Don't blame me. I voted for Chuck Norris.
I'm afraid the Report Engine was written for the company during company time and drives all our reports. So in the particular case I wouldn't be able to do it.
Software Kinetics - Moving software
-
DevExpress' XtraReports[^] works for me. Cheers, Drew.
I've just started using this having tried MS and Crystal. So far so good! The help and suppoprt these guys offer is also outstanding.
-
I have used Crystal Reports when I was programming with C++, and hated it. When we moved to C# I tried several alternatives: 1) Crystal Reports (again) - 1 out of 10 2) SQL Server Reporting Services - 5 out of 10 3) XtraReports - 7 out of 10 4) StimulReports - 9 out of 10 I have found StimulSoft's product to be robust, fast and easy to use. They also have a web designer if you need that. HTH
--- Regards, Martin.
Martin's experience fits in almost exactly with mine. I would therefore like to add my vote for Stimulsoft Reports which is reasonably priced and has a good royalty free end user designer that can easily be made to look like part of your application and which you can customise to hide stuff that might confuse them or give them the power to cock something up (e.g. the code behind the reports). The new version has increased in price but it would take years to write it myself so buying it for a fraction of the cost makes a great deal of sense. You might need to train users in using the designer if they are not familiar with that sort of product, but hey that sounds like a chargeable extra to me :-) Chris Bray
-
I wrote my own.
Article???
ed ~"Watch your thoughts; they become your words. Watch your words they become your actions. Watch your actions; they become your habits. Watch your habits; they become your character. Watch your character; it becomes your destiny." -Frank Outlaw.
-
I've using SSRS for some time and find it largely adequate for most analysis based reporting. I agree with another reply about "dumbing down" some of the adhoc reporting tools. Our biggest problem with adhoc reporting in general is not the software to produce the reports but the retards producing them who have (apparently) no understanding of data quality or what they are doing from the larger sense. We constanly get back reports from our clients that such and such a report is "total crap". If it were up to me I ban adhoc reporting!
Go Shockers! -WuShock
-
There's active reports. What about reporting services don't they like?
I've used ActiveReports on previous contracts and found it much simpler to use than Crystal. It does just about everything that Crystal does, with a lot less bloat. The last time I priced the 2 products, ActiveReports cost a fraction of what Crystal is going for.
-
DevExpress' XtraReports[^] works for me. Cheers, Drew.
Drew Stainton wrote:
DevExpress' XtraReports[^] works for me.
Speaking of abominations! ;) The problem with these frameworks is NOT in creating the reports. That's typically easy enough to do and one seems as good as another. It's if you have to go in and maintain or change them. They do SO much for you that fighting your way through the generated code to find what you need is a nightmare. It's easier to start over from scratch. I've spent many an hour in communication with DevExpress trying to resolve these issues.
-
Article???
ed ~"Watch your thoughts; they become your words. Watch your words they become your actions. Watch your actions; they become your habits. Watch your habits; they become your character. Watch your character; it becomes your destiny." -Frank Outlaw.
Likely, but it's too integrated with other things so far.
-
Why is it that every man and his dog feels it's necessary to write their own report writer? Along with code generators it seems to be a favourite project of software developers, but rarely comes up with anything more than an expensive experiment - satisfying the programmer who writes it but not the customer who's paying for it. Report writers are just another meta-problem like code generators and ORM frameworks - fun for the developer but don't produce bang for buck for the client. Clients aren't paying us as developers to solve the problems we find interesting, but paying us to solve their particular business problem. [Sorry, just a rant about the million or so custom reporting engines out there] In my experience users always want to be able to customise their reports - and most reporting frameworks don't allow this or charge exorbitant license fees (where the user then needs training to use the tool). More often than not the users come back to us as developers to just produce the report for them. I don't think there is a perfect reporting framework out there for any one particular project, and it really comes down to the particular requirements of the project as to what you should use. Can you fill us in on your particular requirements? I've used Crystal Reports before, and for the most popular reporting tool out there I'm yet to find someone who's used it that actually likes it or swears by it. Personally I've encountered so many issues just deploying Crystal Reports in the times I've used it (spending much time in their kb for workarounds to their bugs) that I couldn't recommend it. I haven't used the full SQL Server Reporting Services but have used the local report engine (RDLC), which for all intents and purposes is the same thing. But you are likely to hit problems once you get beyond anything but basic reports in my experience. There are a number of others out there that I haven't used but look OK (Telerik, XtraReports, etc). Ultimately the only solution I've ever found to be popular with users is to generate reports as Word or Excel documents (either through automation, a VSTO addin, or populate it on a server using the Office Open XML or WordML formats). Users can then customise them to their needs, and if you have a template system (easy to do) they can create their own. Especially easy with Office 2007 with the Office Open XML standards (though I've also done it with WordML for Office 2003 compatibility). The advantages are that almost every user will have Office on their desktop,
christhecoder wrote:
satisfying the programmer who writes it
Yes, indeed. ::Sits backs and pats stomach::
christhecoder wrote:
Ultimately the only solution I've ever found to be popular with users is to generate reports as Word or Excel documents
I got tired of people saying, "I need you to report xxx in Excel!" At which point I'd remind them that spreadsheets aren't reports and the closest I'll ever come to actually writing an XLS file is writing a CSV file. When I give them a CSV file they don't know the difference, because, gee, "it opens in Excel". Personally, I prefer to see such things in a table in a Web browser. So I write XML with stylesheets (XSLT) to produce CSV and HTML, whichever the user prefers. (I suppose I could add WordML, I'll look into it.) I just remembered that the first time I recall having to produce "an Excel report" I actually produced a SYLK file instead, I may add that to my XSLT as well.
-
I've been tasked with researching some alternatives to SQL Server Reporting Services and was wondering what experiences and recommendations anyone out there has? I've also seen a couple of add-ons for reporting services, some of which look quite promising - has anyone got any experience of these? PS Ideally not Crystal Reports - I had to use this in an old job and *hated* it!! Cheers
It definitely isn't definatley
I would recommend DevExpress Reports. http://www.devexpress.com/Products/NET/Reporting/[^]
-
I've been tasked with researching some alternatives to SQL Server Reporting Services and was wondering what experiences and recommendations anyone out there has? I've also seen a couple of add-ons for reporting services, some of which look quite promising - has anyone got any experience of these? PS Ideally not Crystal Reports - I had to use this in an old job and *hated* it!! Cheers
It definitely isn't definatley
Oh, come on now. Who doesn't LOVE to work with Crystal? :rolleyes:
-
Drew Stainton wrote:
DevExpress' XtraReports[^] works for me.
Speaking of abominations! ;) The problem with these frameworks is NOT in creating the reports. That's typically easy enough to do and one seems as good as another. It's if you have to go in and maintain or change them. They do SO much for you that fighting your way through the generated code to find what you need is a nightmare. It's easier to start over from scratch. I've spent many an hour in communication with DevExpress trying to resolve these issues.
-
I've just started using this having tried MS and Crystal. So far so good! The help and suppoprt these guys offer is also outstanding.
-
I tend to stay away from designers, wizards and such and just stick to writing code - forces you to learn their API and works better in the long run. Cheers, Drew.
-
I've been tasked with researching some alternatives to SQL Server Reporting Services and was wondering what experiences and recommendations anyone out there has? I've also seen a couple of add-ons for reporting services, some of which look quite promising - has anyone got any experience of these? PS Ideally not Crystal Reports - I had to use this in an old job and *hated* it!! Cheers
It definitely isn't definatley
Most users just need a tabular list of data; for that, all the Reporting Frameworks are inappropriate, just not the right tool. If the goal is to have PDF: I used to have a Perl script that someone had written that would turn a text file into PDF.
-
DevExpress' XtraReports[^] works for me. Cheers, Drew.
I can vouch for this reporting tool. It is completely customizable, actually built a TIFF reader from their printing system that comes with it. Just so i could take advantage of their PDF conversion and Emailing capabilities. It can go simple as dragging a table on and binding it to drawing everything through code. There help is great and fast, cost is negligent considering how many hours they have saved me because i was able to ask a question and get response next day. You can also purchase their source code as a option if you want to. Oh and creating a custom report (like a mailing letter) for the end user to do took me half a day to implement, customers love it when you give them power to re-size text and add logos, etc... Jordon Kraft
-
I can vouch for this reporting tool. It is completely customizable, actually built a TIFF reader from their printing system that comes with it. Just so i could take advantage of their PDF conversion and Emailing capabilities. It can go simple as dragging a table on and binding it to drawing everything through code. There help is great and fast, cost is negligent considering how many hours they have saved me because i was able to ask a question and get response next day. You can also purchase their source code as a option if you want to. Oh and creating a custom report (like a mailing letter) for the end user to do took me half a day to implement, customers love it when you give them power to re-size text and add logos, etc... Jordon Kraft
-
I've used ActiveReports on previous contracts and found it much simpler to use than Crystal. It does just about everything that Crystal does, with a lot less bloat. The last time I priced the 2 products, ActiveReports cost a fraction of what Crystal is going for.
You can try Telerik Reporting. It is fast, easy and developer oriented. And it comes in bundle with all the control suites for WPF, Silverligt, WinForms and asp.net those guys make. Aaaa and they now have quite impressive O/R mapper which spared me a lot of DAL plumbing.
-
What happened that nearly got you fired for using SQL Server Reporting Services ? I'm looking at using it for a current project as dropping a reportviewer out of visual studio takes care of the pdf export. If it's likely to do something that gets me fired then it'd be useful to know about it in advance. Thanks