Skip to main content
Answer

Expressions not showing up in Report Designer

  • February 12, 2025
  • 2 replies
  • 87 views

Forum|alt.badge.img

Hi! Sometimes in a report when I try to preview it, I’ll just get a blank data or a blank page, and other reports I’ll get data. Sometimes when I make a new report, my sub reports will show up, and sometimes they wont.

 

The only consistent thing is that expressions mess up, but text still displays

help!

Best answer by BenjaminCrisman

@lunarchickadee We’ll probably need some images and more specifics to be sure, but some reports require parameters to be filled in to populate data, so if you’re strictly working out of Report Designer you’ll need to account for that and put them in via the build schema to test the data output.

Same thing with the subreports, some can get report data transferred to it, but some require a parameter entered on the main report to get passed to the subreport. Typically when working with subreports I will add the subreport as a separate report to the site and test it individually, then once I know it’s working as expected and the correct data is shown I’ll incorporate it into the main report and verify it’s working. If it isn’t then usually this means something is off with the connection or something is not being fed to the subreport correctly, but I know that the subreport itself is ok.

Hope this helps but if not, please provide some specific examples

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • February 12, 2025

@lunarchickadee We’ll probably need some images and more specifics to be sure, but some reports require parameters to be filled in to populate data, so if you’re strictly working out of Report Designer you’ll need to account for that and put them in via the build schema to test the data output.

Same thing with the subreports, some can get report data transferred to it, but some require a parameter entered on the main report to get passed to the subreport. Typically when working with subreports I will add the subreport as a separate report to the site and test it individually, then once I know it’s working as expected and the correct data is shown I’ll incorporate it into the main report and verify it’s working. If it isn’t then usually this means something is off with the connection or something is not being fed to the subreport correctly, but I know that the subreport itself is ok.

Hope this helps but if not, please provide some specific examples


Forum|alt.badge.img
  • Author
  • Freshman II
  • February 12, 2025

I found out that it was two parts tripping me up.

  1. There was a leftover parameter pointing to nothing that caused nothing to show
  2. there was a text box that for some reason was causing an error and once it was gone everything else worked

So your advice definitely helped! Thanks