What is the status of report generation these days?
-
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."
Just so long as you're not planning to use .NET Core or .NET 5 - there's still no sign of SSRS support for those platforms. :sigh:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
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
Have you looked into OpenXML? I use it to generate Excel files, and read them too but it can do more than just Excel. How to: Create a spreadsheet document by providing a file name (Open XML SDK) | Microsoft Docs[^]
Find me on twitter @dthompsonza
-
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 find Developer Express Reporting XtraReporting to meet all my needs and more. Has a user configurable mode so users can customize and save their own versions. Has a report server. Powerful designer. Worth a look. Not cheap but good tools are worth it.
-
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
We use CRW (Crystal Report Writer) for our Windows desktop application. We use it 3 different ways: 1) have our own UI for parameters that are passed to the RPT file 2) run a RPT file directly, only passing in the connection string. 3) generate data external to the RPT file, then pass in the dataset to the RPT. Either way, we have a common dialog for displaying the results that all 3 methods use. We also provide a custom reports option. A user can use CRW to create any custom report they want, drop the RPT into a specific folder, and the program will show its name in a drop-down list for them to run it. However, 100% of the time they pay us to do the custom report for them. I like CRW because of it's ease of use for beginners, yet powerful enough for whatever I want to do. Bond Keep all things as simple as possible, but no simpler. -said someone, somewhere
-
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 use ActiveReports. I find it significantly easier to use than Crystal reports. Does everything I want, including export to Excel, and email. I am have been using it since VB6, and now C#.
Oh well...
-
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
Hi. If you don't mind using a standalone software for reporting, i recommend you to try [DBxtra](https://dbxtra.com/), it's easy to use (drag and drop!), and let you edit queries if you know what you're doing (SQL code). Disclaimer: I work for them.
"Science fiction is any idea that occurs in the head and doesn’t exist yet, but soon will, and will change everything for everybody, and nothing will ever be the same again." Ray Bradbury
-
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 built a data warehouse and taught my users Excel Pivot Tables. Once they get it, I am never bothered for reports again. For ad-hoc queries, this is great. I use SSRS for pre-defined reports. It is so easy to use, to update and deploy reports.
Outside of a dog, a book is a man's best friend; inside of a dog, it's too dark to read. -- Groucho Marx
-
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 have been using Microsoft Reporting Services local RDLC, migrated from the server using RDL, migrated from Crystal, and am about to just create reports in MVC views.
-
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
But what are your tools? :)
"Qulatiy is Job #1"
-
We've built multiple dashboards in Metabase and love the a) ease with which users can create simple queries, and b) how a good SQL writer can make complex queries with lots of joins and unions and c) how it turns the results into graphs and pivots. And since we run it on our servers, it's free.
-
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
charlieg wrote:
It was a long 2020
That it was! If 2020 Was A Scented Candle[^]
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
-
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
hi, I highly recommend you have a look at List & Label from combit (German company). It is a commercial tool and suits you needs from easy to use based on simply hooking (almost any!!!) a datasource to it until high end drill down reports as seen by commercial BI tools. Customization options for end users are second to none. I love the tool and hate the companies restrictions in controlling their licenses. Don't get me wrong - I support regular license fees! But the way they limit and control it is a little bit to much for my understanding. However, I am using it for nearly 15 years in a large number of commercial products. And each year they come up with a new version with valuable features. best regards Michael Lutz M. A. Health Management www.BITsoftNet.de
-
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
This is why I love CodeProject. So many ideas and people willing to share them. Professionals all. My contract company is very selective in how it spends s/w $$. If a manager hears "free", they are all in. Corporate wise, they are gung-ho for using Microsoft out the wazoo. I won't mention the time I asked for a Linux VM. Heads exploded, others turned 360 degrees, and objects started moving on their own. lol. For the ad-hoc query case, Excel will work for me. For the production system I need to develop, the others are possible solutions. Thanks again
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
-
hi, I highly recommend you have a look at List & Label from combit (German company). It is a commercial tool and suits you needs from easy to use based on simply hooking (almost any!!!) a datasource to it until high end drill down reports as seen by commercial BI tools. Customization options for end users are second to none. I love the tool and hate the companies restrictions in controlling their licenses. Don't get me wrong - I support regular license fees! But the way they limit and control it is a little bit to much for my understanding. However, I am using it for nearly 15 years in a large number of commercial products. And each year they come up with a new version with valuable features. best regards Michael Lutz M. A. Health Management www.BITsoftNet.de
"hate the companies restrictions in controlling their licenses" I understand that. The customer I am supporting must use software from a European company. The other customer again uses s/w from a European customer. Both of the companies' licensing process are a real PITA. Had one customer have all their servers stolen with the license USB dongle still in it. Company had to buy another full license. Real hard asses.
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
-
Have you considered using Excel for some of the reports? You can put complex queries directly in it or build views to support the users. We do that for many one offs that will be reused frequently.
No, but I will. This weekend's project. Thanks
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[^]
I've been using FastReport VCL (Delphi) forever. I like that the reports are in XML, we were able to transform a ton of reports simply. It has a Client Side Report Designer, if needed (We have shipped it a couple of times). It has a server based solution as well... And of course, there is the .NET version, which I assume you are interested in. We have also leveraged the SCRIPTING language to get some VERY custom reports, and cause report page links to open records in our application!! Kinda cool features, IMO. [https://www.fast-report.com/en/product/fast-report-net/\](https://www.fast-report.com/en/product/fast-report-net/)
-
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
Let me ask, what do the users want? Are they looking for the data, specific page layout, etc? I've started delivering 2 types of reports. Grid Reports (Simply a dynamic grid result of a query you can manipulate and save to Excel), AND real Reports created with a designer (FastReports). It depends on what they need, and how they intend to use them. The grid tools I have will do subtotals, and allow the users to dynamically group things, and apply their own additional filters. The core concept is: Query + Bind Variables [Filters, etc] -> Results. I like the "default" the bind variables with appropriate values, and therefore use a UNION of select "VarName","VarVal" expressions (select 'Year' as VarName, Year(now()) as VarVal) and then display that in an editable vertical grid for the user... Then apply them to the base query. It lets me put all the report queries/params in the database, and makes it easy to add without updating the program...
-
I've been using FastReport VCL (Delphi) forever. I like that the reports are in XML, we were able to transform a ton of reports simply. It has a Client Side Report Designer, if needed (We have shipped it a couple of times). It has a server based solution as well... And of course, there is the .NET version, which I assume you are interested in. We have also leveraged the SCRIPTING language to get some VERY custom reports, and cause report page links to open records in our application!! Kinda cool features, IMO. [https://www.fast-report.com/en/product/fast-report-net/\](https://www.fast-report.com/en/product/fast-report-net/)
Thanks Kirk, useful information! You are right, my interests are in the open-source .NET version, haven't done much with it but I like to be prepared when the day comes that reporting is needed :-\
-
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[^]
Unfortunately it doesn't work in .NET Core.
Check out my blog at http://msdev.pro/
