IDEA: KIN-I-5057 Replace tired SSRS with a modern really web friendly document reporting tool

The need isn’t for BI reports or dashboards we already have countless options for those.

What I’m referring to are the traditional pieces of paper – Invoices, Quotes, Order Acknowledgments, etc. Programs like Power BI and Grow, among others, are designed to be viewed dynamically on screens.

What I really want is the ability to easily print well-designed, professional-looking documents from my system without the hassle and frustration.

8 Likes

NOOOOOOOO!!!

4 Likes

Still better than SSRS John! (though I agree with your sentiment)

2 Likes

There were rumors that Epicor was intending to replace SSRS for many of the reasons mentioned here. When I asked at Insights this year, I was told that they had considered it but ruled it out because there wasn’t any sort of defacto standard to replace it with.

It seems there’s no going back to Crystal and Microsoft has apparently given up on SSRS. Take my vote, but my outlook is bleak.

2 Likes

One thing I really like about SSRS is the ability to export to alternate formats Excel, CSV, etc. Our accounting department loves their auto-Excel reports. Crystal was never good at exporting to Excel.

Standards start somewhere! Come on @Edpicor let’s be avant guarde!! :clap:

3 Likes

Let’s go back to reporting like it was in Microsoft Access!

3 Likes

Hey, my VB6 knowledge translates almost 1 to 1 into VBA…

napoleon dynamite yes GIF

2 Likes

Microsoft has started to add paginated reports to PowerBI for some time now… Plan to migrate .rdl reports to Power BI - Power BI | Microsoft Learn

They are paginated reports inside PowerBI, but how that would work with Epicor… I have no idea :joy:

1 Like

That’s just a new name for SSRS Designer it looks and behaves exactly the same and it is just as bad :sweat_smile:

1 Like

As someone who has about 15+ years developing on the MSFT business intelligence stack. SSRS in Epicor is hot garbage with all the hoops to jump through to get data (any data, not even the correct data) to work on an Epicor SSRS report. You got my vote.

4 Likes

Am I the only one who likes SSRS? When I had to first learn it, I was crying like a big old baby. Now that I have been using it for a while, I actually prefer it over Crystal.

11 Likes

Yes, in the entire world you are the only one :joy::joy::joy:

Have you done anything advanced with it? Subreports, Page Breaking, etc? It is sooo bad at that. We have a packing slip report that works fine as long as you print a non specific number of packing slips…

You print 2 is fine

You print 8 is fine

You print 10,11,14? The pages break funny, and extend all over the place. It is completely arbitrary and inconsistent we’ve never been able to fix it.

5 Likes

I don’t hate it as much as others on the forums, but I am open to any improvement in the reporting area.

I am with @jkane I like it a lot better now, but page breaks… :face_vomiting:

I know Alex A. (SSRS guru from Epicor) had done some formulas to figure out exact page breaks.

1 Like

Yes, I have done lots of advanced things with it. I agree that there is a learning curve, but once you pass that, I have found it easier to do things than in Crystal. Also, now that I have to use Crystal again, I am finding some things that are harder to do in Crystal than in SSRS.

2 Likes

The trick to page breaks is the Advanced Menu and setting the properties of Keep Before and Keep After.

5 Likes

The Report Designer sucks there is so much they could improve but it’s abandoned by Microsoft. I’ve had to go into the report RDL file with NP++ to fix s***t so many times.

Yes, Quick Ship uses Crystal still and I’ve had to relearn how to use it. :rofl: I’ve already mentioned doing Excel exports is cake in SSRS but a PITA in Crystal.

Care to try and fix my report? #AskingForAFriend :joy::joy::joy:

We’ve tried everything we know. :poop:

3 Likes

Just like current SSRS, onsite only plus added shenanigans to deliver to SaaS users. Power BI Report Builder doesn’t speak HTTP, otherwise I’d be using it already!

2 Likes