AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register

Acumatica Reports – Report Designer (5%) and Excel / Power BI (95%)

May 5, 2015 by Tim Rodman

Last week I mentioned the recent announcement by Acumatica which connects Acumatica to Microsoft Excel, Power BI, Power Pivot, and Power Query.

Then I made my case for why I think that Excel and the “Power” tools are a big deal.

What about Report Designer?

But where does the Report Designer in Acumatica fit into all of this?

I personally think that Report Designer is still needed, but only for 5% of your reporting needs.

Report Designer is good for things that you will need to print directly out Acumatica like Sales Orders, Purchase Orders, Customer Invoices, Customer Statements, Vendor Checks, and Shipping Paperwork.

As for the other 95% of your reporting needs, I personally don’t think that Report Designer is the best tool.

And it’s not a knock against Report Designer specifically. I know that Report Designer is still kind of new so it can behave strangely sometimes and there are some bugs to work through. But I also don’t think that Crystal or SSRS are the best tools for the 95% either, even though they are very mature reporting tools.

The main knock against reporting tools like Report Designer, Crystal, and SSRS is that they don’t respond well to questions. If you know exactly how you want your report to look like and you know that you aren’t going to change your mind, then they are ok. And that’s the case for things like AP Check reports. But most reports don’t work that way. Most reports are living documents that constantly need to be revised.

Exploring your data

Once you see actual numbers on a report, you start asking questions and you want to slice and dice based on different parameters.

Once a report becomes popular, others begin to ask for additional things to be added so the report can serve the needs of multiple departments. The report continues to evolve as it moves through the organization.

Changing reports in Report Designer, Crystal, or SSRS is like working with hardened concrete. And it can be very difficult to change concrete once it has hardened.

Changing reports in Excel and Power BI is more like working with clay. You can easily make changes to the report as you find yourself asking questions about your data.

So, I think that Excel and Power BI should be the tools of choice for 95% of your reporting needs.

Next Tuesday…

I’ll stop waxing philosophical about Excel. We can roll up our sleeves and get to work building some actual reports.

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica BI, Acumatica Blog, Acumatica Business Intelligence, Acumatica Excel, Acumatica Excel Connector, Acumatica Excel Reporting, Acumatica Learning, Acumatica OData, Acumatica Reporting, Acumatica Reports, Acumatica Reports in Excel, Acumatica Training, Microsoft Excel, Power BI, Power Pivot, Power Query

By using this website, you agree to our Terms of Use (click here)

Online Members

Recent Blog Posts

  • Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View January 26, 2021
  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    @ahmedbahar I am experiencing the same issue. I am on 2...

    By Adam-McGuinnes, 2 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I have the same issue and I use SubReport (in your case...

    By Idrus, 13 hours ago

  • RE: Is the Parameter Schema Field Mandatory?

    I think it's required. Without it, Acumatica doesn't kn...

    By Tim Rodman, 15 hours ago

  • RE: Can a customer Cross Reference for a parent account feed automatically to child accounts?

    @daniel I always like going simpler myself whenever pos...

    By Tim Rodman, 15 hours ago

  • RE: Carrier VDA Shipping Label (VDA 4994)

    Someone out there might have one, but I don't unfortuna...

    By Tim Rodman, 15 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I am attempting several different methods. The issue i...

    By Rick Taylor, 21 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    Are you just putting all the text in a single text box ...

    By megan.friesen, 22 hours ago

  • RE: Kensium Shopify versus Acumatica Shopify

    Hi Carl, Acumatica purchased the Shopify Connector, B...

    By Tyler Mullen, 1 day ago

  • How to add multiple pages of contract terms to the Sales Order printed form

    The customer would like to add their contract terms to ...

    By Rick Taylor, 1 day ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.