What is the status of report generation these days?
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
What database are you using? If it's MS SQL then you could use the include SQL Server Reporting Services.
"Time flies like an arrow. Fruit flies like a banana."
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
SSRS is the bomb for you. And from a simple report you can export to Excel so people can 'play' with the report. It works. Butttttt...... It really takes someone who understands databases and being able to setup and get it working right. This means usually a programmer/DB Analyst. Probably you. with that said. If your end users want to do more than just 'play' with the data. If they want to create their own visuals you probably need to research PowerBI (Microsoft) or Tableau. I have worked extensively with both. I prefer Tableau. Mainly because I am more familiar with it. But they both have their good and bad points. They are both fairly expensive. as always ymmv. But that is my .02 Enjoy.
To err is human to really elephant it up you need a computer
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
charlieg wrote:
I've never heard of anyone loving a report generation tool.
My "boss", a DBA, loves my tools. He can generate the interface for I/O (data queries, data entry/edit/delete) and feed them to his stored procedures. All from SQL tables. It generates a table automatically from the returning record set - configurable in a feature-creep-dreamworld. It's now approaching 800 reports for the same set of php/javascript files. Even a button to convert the table returned to an excel file. Paging, for large records sets and all sorts of crap. I built into it about 40 data-base configurable HTML controls - char/numeric/VIN/drop-list (regular and parent-child that even work many-to-many), even one for javascript injection. As he noted, I made his life very easy. We don't need not stinkin' crystal reports. It is corporate-agnostic. It'll work for insurance claims or pizza orders. The generating their own reports is (via the input fields) by creating SQL filters on-the-fly. Also, line, bar, and pie charts - but as it turns out, no one wanted them once they became available. Yeah - he loves it.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010
-
What database are you using? If it's MS SQL then you could use the include SQL Server Reporting Services.
"Time flies like an arrow. Fruit flies like a banana."
mysql at the moment for the simple situation. For the production one, I'd bet on MS Sequel Server but the application is database agnostic.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
XSL-FO with 3rd party component. It's not suitable for quick customization so don't.
thatraja
Coming soon1 | Coming soon2 | Coming soon3New
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Take a look at the open-source reporting tool Fastreport: best-open-source-reporting-tools[^]
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
I've mostly worked with CR and unlike everyone else here, actually like it. For newer projects, we've been using DevExpress. It's a little pricey but it's easy to work with, has tons of documentation, and tons of options. We use their pivotgrid control for ad hoc reporting and it works great. You get what you pay for. Unfortunately, you also get bloat/dependency from using third-party tools. :sigh:
"Go forth into the source" - Neal Morse "Hope is contagious"
-
Take a look at the open-source reporting tool Fastreport: best-open-source-reporting-tools[^]
:) Why is your name on that page? :laugh:
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
For some reason people love to knock Crystal Reports and I used to be one of them ( way back ) , but if you spend some time learning it you can create very complex and powerful reports, if you're after sexy looking reports maybe look elsewhere but for informative down to the metal reports I think it's very good. It supports the usual while / do / for loops, arrays ( albeit one dimensional ) so the limit is your imagination. As for integration with dotnet I don't know what is available these days.
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Roll your own. Back around 2007 I wrote a simple reporting module for an application I was working on. It uses XML and XLST to allow the user to view the results in either Excel for a browser.
-
:) Why is your name on that page? :laugh:
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Why not 😆
-
Roll your own. Back around 2007 I wrote a simple reporting module for an application I was working on. It uses XML and XLST to allow the user to view the results in either Excel for a browser.
The reports are simple enough (based on the sql I know needs to be done) you may have a point (for the second application).
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Wow! You're still here, Charlie? Happy New Year - this is #17 for this site, isn't it? It's getting hard to find many of us old timers here... Good to see you still above ground!
Will Rogers never met me.
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
While things come back round, you'll find user expectations are way different. Everybody has an iPad or some touch device and wants instant touch and play on the reports. We've moved to Power BI (at great cost) and people love it. MS is putting a lot of effort behind it, and the desktop version is free if you just want to see what's possible. If you know excel, you can create a report simply (if the devs setup certified data sets or similar, or you have access to do so). You'll want the 'application owns the data' integration (MS website will lead you down P1 (£5k/month min) where you end up with all your customers on active directory)... However, you can just use an A1 (£700/month) under this method: Embed content in your Power BI embedded analytics application enabling better embedded BI insights for your organization - Power BI | Microsoft Docs[^] You can start with no cost, see what's possible. The user interface is great. What you can't do.... If you want a report of an 'invoice', this is not the tool for that. Then you're back at SSRS type reports in Power BI (also back to £5l/month min!) If you wanted an interactive report of say, all your stock, how it's sold over time and filter it by whatever you want, then this is the tool. If you want, it is possible to have a subset of user's with full power bi access... they can then create their own dashboards from all / any part of your reports. You can then make that available in your application. So there is a sliding scale of how much you use it. To anybody who's making simple spreadsheets and then wants some charts... go download power bi desktop for free and click 'get data' and choose your excel sheet... make a nice chart etc. and then you can update the sheet and the report updates too! Given that, if the reports are for INTERNAL use only (not customers) you can, actually use power bi with no cost, I know of one huge organisation that's doing that.. and we're like great, but if you want all these 1000's of user's to access it, it's going to cost you... so the MS grand plan to take your money works in the end!
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
My experience of any report generator over the past 40ish years is to forget them. from a programming side they are hard and time consuming to write & document, and come up with anything that an end user can learn or use easily, (and most dont want to have to learn anything new anyway). I now take one of two methods when my systems don't give a user exactly what then want or they have a 'special' requirement. firstly i offer a service to write the report for them as an add-on or integrated option to an existing format and try to keep the price down, and secondly (and more popular) is to write a csv output dumping all the data they need, whereby they can use excel to re-jig it as they want, as most companies have people familiar with it. a lesser used option is for people to do it themselves either in sql server or access for example and i will assist in explaining schema's, but that's very few. I also dont like to use 3rd party add-ons as you not only have to learn and support them, which can be time consuming for little reward, but give you a great deal of pain updating, maintaining licences or whatever. GL
-
What goes around comes around, and justice grinds slowly. It appears I have some report generation in my future for a couple of projects. I know a limited Crystal Reports version used to ship with VS 6 (yeah, that far back). I'm curious what everyone *here* uses these days. What do you hate, what will you tolerate? I'd ask what do you love, but then, I've never heard of anyone loving a report generation tool. :) I have two needs - the first is to be able to generate ad hoc reports against a couple of internal databases. People want to play with generating their own reports, so I need something relatively simple to use. The second is more production oriented for a manufacturing system. They'll be a canned set of reports generated on an order by order basis. Yes, I did a google search, but all I get are myriads of pages listing the top 10 report tools and direct links to the company pages.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
MS ReportViewer control is database agnostic in local mode. Usable in a Web or Desktop application Get started with Report Viewer controls - SQL Server Reporting Services (SSRS) | Microsoft Docs[^] Microsoft RDLC Report Designer - Visual Studio Marketplace[^] Microsoft Reporting Services Projects - Visual Studio Marketplace[^] NuGet Gallery | Microsoft.ReportingServices.ReportViewerControl.WebForms 150.1427.0[^] NuGet Gallery | Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1427.0[^] Some advices: ReportViewer Tutorial[^]
-
Wow! You're still here, Charlie? Happy New Year - this is #17 for this site, isn't it? It's getting hard to find many of us old timers here... Good to see you still above ground!
Will Rogers never met me.
Still kicking - just busy busy. It was a long 2020. :) Wow, 17 years, I have to think who I was working for that far back. I was transitioning from server/mainframe development - openVMS and straight C - to the Windows desktop. Interestingly, that was the last time I was doing DB application development. The company loved their flat files. Ugh.
Charlie Gilley <italic>Stuck in a dysfunctional matrix from which I must escape... "Where liberty dwells, there is my country." B. Franklin, 1783 “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
