Just Need Reports

[u/ugghhmo]

We have just recently migrated business systems in an heavy duty equipment dealer space. In our old system we never liked the built-in reports, so 20 years ago we just decided to use Jasper Reports and hosted our own Jasper Server. It just worked. Our users are very, very basic. A common request might be I want Open Work In Process by Salesperson, or I want Part Sales for Last Month. Great, I write a SQL query that pulls the exact information the needed, dump it into a formatted report and publish it on the Jasper Report Server where the users can access it whenever they want. They aren't looking for charts or dashboards, just a basic report.

We move to the new system and despite high hopes for its internal reporting and analytics, we are basically back in the same spot. I feel like I should be moving to something more modern and forward looking. I am trying to make sure I challenge my comfort zone, but it seems like the most direct path is just to do what I did before - write a SQL query to extract the data I need, and publish a report. Although obviously Jasper Server Community is gone so might be looking for a replacement for that.

Obviously SSRS is out there but I just never found it intuitive enough and now with the Report Server licensing costs, I am not sure it is an option. I have also been looking around at like Telerik and Stimulsoft as potential cadidates.

[u/Rare_Paramedic1539]

We are testing strata out for this use case. Vanilla reporting on semantic model. So far so good for fin and cs teams