• Home
  • Blog
  • Creating simPRO Reports, Graphs and Dashboards
Hari Iyer | SyncEzy

Hari Iyer | SyncEzy

CEO
  • Reading Icon 8 Min Read
  • Reading Icon Nov 03, 2022
simPRO-Reports-in-Power-BI

There are some powerful reasons why you should use Power BI to create reports from your simPRO data. By accessing your Jobs, Projects, tasks and sub-task data in Power BI, you’ll be able to create powerful reports, graphs, charts and dashboards from your simPRO data.

How do you create reports in simPRO?

To generate simPRO reports, follow the below steps.

To generate a report:

  1. Go to Reports  > View Reports.
  2. Click the applicable reporting category in the menu to the left.
    • Alternatively, the report may be one of simPRO‘s Most Common Reports.
  3. Read the report descriptions to determine if a report is suitable to your needs.
  4. Click the title of the report you wish to generate.
  5. Select from the available filters and click Search.

After you have generated the report, you can download it as a spreadsheet in CSV format, viewable in Microsoft Excel and other spreadsheet software.

Assigned_Stock_download_thumb_0_0

By using a direct integration with Power BI, you can have a live data feed of information used to power your reports. This saves on downloading and uploading CSV data and using out-dated data in your meetings and reporting.

The Most Common Reports in simPRO include:

most-common-reports_thumb_0_0
How do you create comprehensive reports from simPRO data?

In order to create more comprehensive reports from your simPRO Jobs, Projects, tasks and sub-task data, you’ll need to use the simPRO to Power BI integration in order to sync simPRO data across to Power BI. This integration will sync across the entire 510 tables of data from simPRO to your Power BI account where you can use the data to build reports like sales per year for every job/quote, jobs by status and the top customers based on number of jobs scheduled.

Once you have the data across into Power BI, you can create reports using the Power BI Service or via their Power BI Desktop app.

How to create simPRO reports in Power BI using their Power BI service

There are several ways to create reports quickly in the Power BI service. Instead of downloading the Power BI Desktop app and importing the data, you can paste data straight into Power BI on the web, and Power BI automatically generates visuals for you.

New to creating in Power BI? Try reading Reports in Power BI for some quick background information.

quick-create

In the navigation pane in the Power BI service, you can select the Create button that opens a page where you can select your data source. It’s also accessible from the New report button on Home.

create-entry-point

Currently, we only support creating a report based on an existing dataset, or pasting or manually entering data directly in a table. Over time you’ll see other sources, such as uploading an Excel file.

create-source-options

When you choose to paste or manually enter data, you get a grid that you can start to type into. You can also paste data by using Ctrl + V or the context menu.

create-enter-data-window

You can use the context menu to add and remove columns. If your pasted data includes a header row, select Use first row as headers to automatically promote the first row to the header row. Power BI automatically detects the data types, but you have the option to set them manually. Select the Data type button next to the column name.

change-data-type

As you go through the creation process, Power BI creates a new dataset for you, and autogenerates a summarized view of your data. These autogenerated visuals propel you from raw data to insights faster than ever.

select-data-fields-generate-new-visuals

Changing the data you see in the report is easy, too. Use the Your data pane to add or remove fields from the report. Select and deselect fields to update what you want to measure and analyze. Power BI automatically plots meaningful charts based on your field selection. Read Interact with autogenerated “quick” reports to see all the ways you explore and modify these reports.

Switch to full edit experience

If you want to switch to a full edit experience, select the Edit button in the menu bar. Be aware though, that once you save the report in the full edit experience, you can’t go back to the quick edit view.

edit-entry-point

Looking to create reports from simPRO data on your desktop?

How to create simPRO reports in Power BI using their Power BI Report Server

You can store and manage Power BI reports on premises in the Power BI Report Server web portal, just as you can store Power BI reports in the cloud in the Power BI service. You create and edit reports in Power BI Desktop, and publish them to the web portal. Then report readers in your organisation can view them in a browser or in a Power BI mobile app on a mobile device.

report-server-powerbi-report

Here are four quick steps to get you started.

Step 1: Install Power BI Desktop for Power BI Report Server

If you’ve already created Power BI reports in Power BI Desktop, then you’re almost ready to create Power BI reports for Power BI Report Server. We recommend installing the version of Power BI Desktop for Power BI Report Server so you know the server and the app are always in sync. You can have both versions of Power BI Desktop on the same computer.

  1. In the report server web portal, select the Download arrow > Power BI Desktop.Or go to the Power BI Report Server home page and select Advanced download options.
  2. In the Download Center page, select Download.
  3. Depending on your computer, select:
    • PBIDesktopRS.msi (the 32-bit version) or
    • PBIDesktopRS_x64.msi (the 64-bit version).
  4. After you download the installer, run the Power BI Desktop Setup Wizard.
  5. At the end of the installation, check Start Power BI Desktop now.It starts automatically and you’re ready to go. You can tell you have the right version because Power BI Desktop (January 2021) is in the title bar.
  6. If you’re not familiar with Power BI Desktop, consider watching the videos on the welcome screen.
Step 2: Select a data source

You can connect to a variety of data sources. Read more about connecting to data sources.

  1. From the welcome screen, select Get Data.Or on the Home tab, select Get Data.
  2. Select your data source — in this example, Analysis Services.
  3. Fill in Server, and optionally, Database. Make sure Connect live is selected > OK.
  4. Choose the report server where you’ll save your reports.
Step 3: Design your report

Here’s the fun part: You get to create visuals that illustrate your data.

For example, you could create a funnel chart of customers and group values by yearly income.

report-server-create-funnel
  1. In Visualizations, select Funnel chart.
  2. Drag the field to be counted to the Values well. If it’s not a numeric field, Power BI Desktop automatically makes it a Count of the value.
  3. Drag the field to group on to the Group well.

 Note: Some visuals such as paginated report visual will only work on the Power BI service only. Rendering these visuals on Power BI Report Server will give an “Unsupported visual” error.

Step 4: Save your report to the report server

When your report is ready, you save it to the Power BI Report Server you chose in Step 2.

  1. On the File menu, select Save as > Power BI Report Server.
  2. Now you can view it in the web portal.

Note: If you choose to edit the report in the future, the report data you see in the desktop will always be the cached data from when the report was initially created. To view the latest data when editing the report, you must refresh the data in your Power BI Desktop application.

Got questions about simPRO reporting & dashboards?

If you’re looking for a more robust solution than simPRO’s in-built reporting, speak to our integration specialists about how connecting simPRO to Power BI can help you see your business data in a more comprehensive way.

Author

Hari Iyer | SyncEzy
Hari Iyer | SyncEzy
CEO

Hari Iyer is the Founder and CEO of SyncEzy, a pioneering company at the forefront of data integration and automation solutions. With a deep understanding of the power of technology and a passion for solving complex business challenges, Hari has emerged as a visionary leader in the industry. His relentless pursuit of excellence and commitment to delivering tangible results have earned SyncEzy a loyal global clientele.

He is not only a successful entrepreneur but also an active contributor to the technology community, sharing his insights through thought leadership articles, speaking engagements, and mentorship programs. Hari’s ability to navigate the complexities of remote work serves as an inspiration for leaders, highlighting the importance of flexibility, work-life balance, and a results-oriented approach in today’s evolving work landscape.

Under his guidance, SyncEzy has gained widespread recognition for its deep integration solutions that seamlessly connect software applications, eliminate data silos, and enhance operational efficiency.

When not working, Hari is trying to be a better father, reading tech news, playing FPS games, and not exercising as he should.