Skip to main content
Solved

Creating a new report


ALEXSLUSSER15
Freshman II
Forum|alt.badge.img

How does one create a fully new report? I’m making a tweaked version of an existing report, but need to create a new report on the site, and I’m not sure how.

Thanks for any help.

Best answer by BenjaminCrisman

@ALEXSLUSSER15 What did you end up finding on this?

If you have only saved your report locally, then you need to open the report and save to the server (give it a version name and click to save as new version).

Then it should be accessible via the site and Report Designer.

View original
Did this topic help you find an answer to your question?

10 replies

estebanperalta54
Captain II
Forum|alt.badge.img+4

Hi @ALEXSLUSSER15 you would need to create a space in Acumatica to be able to save your report to it. You can go to the Site Map and Specify a new ScreenID, Title, URL, Workspace, and Category:

 

Then on report designer you can open the existing report and save as into the new screen:

 

Hope this helps!


Forum|alt.badge.img+3

Hello @ALEXSLUSSER15 

We can create the new report by using the report designer tool. And after that, you can save it to the server and publish it to the system by adding a new report to the site map.

Below help documentation that might help.

Overview of Reporting

https://help-2022r2.acumatica.com/Help?ScreenId=ShowWiki&pageid=d99733eb-ec44-45c6-b1cb-5ddf24780563

S150 REPORT DESIGNER training

https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • March 7, 2023

It’s easiest to start with a generic inquiry that provides the data, parameters, and filters that you need. After creating that inquiry, click the ellipsis on the GI screen and export the GI as a report. 

Next under the site map screen, add a new line to the site map which will be where your report “lives” in Acumatica. Follow the documentation for how to best save this new web page or copy the logic from other pages in the site map.

Next, save the report from report designer to this new location. You should now be able to access this report from within Acumatica

From there you just need to create the report in report designer. You may struggle with report grouping, so you may want to look into the documentation around that. 


ALEXSLUSSER15
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 67 replies
  • March 7, 2023
estebanperalta54 wrote:

Hi @ALEXSLUSSER15 you would need to create a space in Acumatica to be able to save your report to it. You can go to the Site Map and Specify a new ScreenID, Title, URL, Workspace, and Category:

 

Then on report designer you can open the existing report and save as into the new screen:

 

Hope this helps!

@estebanperalta54 I’ve added a new report to the site map and tried to save to the server but when I try and access the report on the sitemap it gives an error that the rpx extension is needed, despite both the report file and the report on the site map having the rpx extension.


estebanperalta54
Captain II
Forum|alt.badge.img+4

@ALEXSLUSSER15 Interesting, I just tried it now and saved successfully. Are you sure your URL is correct? Were you able to save the Site Map correctly making sure the screen ID is updated on the URL:

 


ALEXSLUSSER15
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 67 replies
  • March 7, 2023
estebanperalta54 wrote:

@ALEXSLUSSER15Interesting, I just tried it now and saved successfully. Are you sure your URL is correct? Were you able to save the Site Map correctly making sure the screen ID is updated on the URL:

 

@estebanperalta54 Yeah, I double checked everything. It should be working, but I still get the error of rpx extension being missing.

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2548 replies
  • March 28, 2023

Hi @ALEXSLUSSER15  were you able to find a solution? Thank you!


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 621 replies
  • Answer
  • September 8, 2023

@ALEXSLUSSER15 What did you end up finding on this?

If you have only saved your report locally, then you need to open the report and save to the server (give it a version name and click to save as new version).

Then it should be accessible via the site and Report Designer.


Forum|alt.badge.img
  • Freshman II
  • 22 replies
  • June 13, 2024

Regarding adding a new report and 24R1, after you add a new report to the site map you will need to address user security. It seems the new report started out with revoked for all user roles. I know with new generic inquiries you have the opportunity to set some initial security as you publish to the UI but I haven’t seen anything similar through report designer.


  • Jr Varsity I
  • 8 replies
  • September 4, 2024

@philr75 Thank you so much!  I’ve been banging my head against my keyboard for half an hour wondering why my report isn’t visible.  What a pain you are, 24R1...


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings