Best reporting tool - low cost

Barry Dunlap
Barry Dunlap used Ask the Experts™
on
I have had very disappointing results with Microsoft Report Builder and SSRS.  Neither have even printed a simple results of a query.  Report Builder 3 was a sad experience. So I just downloaded Crystal Reports 2016 trial and DevExpress Reports trial.  I was told that the learning curve for DevX is extremely difficult, so I will delete that one.  I don't need complex reporting, just results of stored procs, some complex with as many as 7 tables in a series of joins.

What reporting software do you guys recommend?

Barry D
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Microsoft Access, simple and easy to use.  Can link to almost any data source, can use SQL Server views or stored procedures and is super easy to configure.

I do use SSRS for some of my clients who need a web based tool, but for most of my clients, Access is the way to go.

Author

Commented:
I was thinking that Access might be  my answer.  Can a C# Windows Form app control the Access report or would I have to use Access Reporting directly in an instance of Access?
I would think that  Access 2019 would function very well with SQL Server 2014 Express and have the most refined ability to work with stored procedures and a well-designed relational DB.
How would you compare Access reporting vs Crystal Reports.  (For one thing, Access is cheaper at about $100 vs $500 for Crystal).

Dale, thanks for your reply
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Crystal Reports  has a free version that can be used with Visual Studio.  Basic learning curve is no worse than MS Access reporting.  You can use stored procedures.

It can be downloaded from here
https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

Here is a link to an application that can be used with any type of dataset since it opens it in the application and pushes it to the report
https://www.emoreau.com/Entries/Articles/2016/10/Crystal-Reports-for-Net-revisited-10-years-later.aspx

mlmcc
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I downloaded and installed CR Developer.  It asked for a product key.  After searching on how to get a key, it appears now that Developer is not free and costs more than single-user Crystal.

If I have found faulty info and you know of recent free installs, please tell me how to get a product key.

Thanks,
BD
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Did you download from
https://origin.softwaredownloads.sap.com/public/file/0020000000898892019

CR Download
It has been free in the past so unless something changed recently, I think you may have downloaded the wrong product.

I read through various pages and don't see anything that indicates it need a key.  DId you get any emails from SAP/Crystal that might have the key in them?

I don't have Visual Studio installed on any of my machines so even if I download the install package, I can't install it to see what you are seeing.  Can you provide a screen shot of the Crystal page you are seeing or is the key required when you install?

mlmcc

Author

Commented:
Since Crystal Reports on Visual Studio would lock up so often, I have decided to do what Dale Fye recommended.  Thank you mike for recommending CRonVS.  The failure is a SAP problem.  SAP never responded to my email describing the issues I had with Crystal.

I will try Access and its reporting tool.  I could not get Access using ODBC to link to tables in SQL Server 2014.  Each time I tried it only 5 of 20+ tables were found.

Then I found an article that said to use Access VBA.  The article also provided the VBA code to go against SQL Server.  Hope that solves my problem.

Barry
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
Barry,

You could also try using my Linked Table Manager for Access and SQL Server to link the tables from SQL Server to your Access database.  You can download it for free from my website.  It is a zip file containing 2 files(one contains instructions for installing the add-in, the other is the .accda file).

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial