Passing Variables from Sub Report not resetting value when no Value in subreport - Acumatica Report Designer

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

LoganG — Mon, 02 Mar 2020 23:43:13 +0000

@jen-tran a bit late, but if this helps you: What I've figured out from a recent project is that you can only have one subreport per-section. To fix your problem you should add 3 footer sections, move the sub reports into 1 and 2, then put the display part in 3. Then you can access the 2 subreport parameters in the 3rd section with out having the 2nd one break.

For everyone else, another strange rule I've found. You can only seem to pass values of sub report variables from the section they exist in. For instance if you create a variable in the detail section, but want to sent the sum of that back from the footer section. It will not work. You will have to create a new variable for the footer section, assign the summed value to it, then pass that back to the main report.

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

Tim Rodman — Mon, 10 Feb 2020 00:24:14 +0000

Did your Summit training idea work?

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

jentran — Thu, 30 Jan 2020 02:30:59 +0000

@timrodman

Yes I was thinking it’s a bug and I did open a ticket but they are getting difficult not willing to do it without a SOW $750 to look at this since it’s deemed custom report. Thanks for looking into it though. Hoping I can ask during training at summit :)

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

Tim Rodman — Thu, 30 Jan 2020 02:03:54 +0000

I just took a look and was able to reproduce the problem in my environment. The variable field displays 0, but the subreport (once I make it visible) displays the correct value. I think you might need an Acumatica support case on this one.

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

MichaelHansen — Sat, 04 Jan 2020 01:05:30 +0000

The Master report has both Subs set to FALSE for visible. That should be set to TRUE, although you do have it visible for Excel, so it'd show if you export to Excel, but not in the web-browser.

But you said you're seeing a 0... Would you mind posting your other sub-report? It's been a bit since I've hit sub-report variables and they're a bit finnicky, it'd be nice to compare your files. Other than the FALSE visibility flag, this looks reasonable to me, assuming you are indeed checking a file with the discount code CCFEE.

Wish I had more help to give you... Once you post your second sub, I'll review this again unless Tim/Shawn beat me to it.

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

jentran — Sat, 04 Jan 2020 00:08:50 +0000

Hi guys,
I'm having an issue with passing a subreport variable to the main report as well. Hoping someone can spot out what I'm doing wrong. I have 2 subreports in the standard sales order report footer. One for total payment to account for multiple payments scenario. And the other one to break out discounts from regular discounts and a specific negative discount for credit card processing fee. The $PMT_TOTALPMT is working just fine but I don't know why the $DISC_CCFEE doesn't work. Both subreports print ok as subreports but $DISC_CCFEE won't work in a subreport variable. It keeps producing zero value. I have tweaked it so many different ways but still can't get to work for CCFEE.

SO641010.rpx

sodisc.rpx

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

Tim Rodman — Fri, 08 Feb 2019 02:49:07 +0000

Are you sure that any records are printing in the Subreport? It doesn't look like it from the last screenshot. Since you put the variable in the detailSection1 of the Subreport, it will only calculate if the Subreport pulls data. It doesn't look like any data rows from the Subreport are printing in your screenshot.

I just posted an example of calling a Subreport variable from a Main report here:
https://www.augforums.com/augforums/acumatica-report-designer/reset-group-on-a-sub-report/#post-3548

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

Tim Rodman — Fri, 03 Aug 2018 10:29:26 +0000

Hi @iskandar,

I believe the variable in the Subreport only gets set if there are records. In your screenshot, the Transfers subreport section is empty for every GL Account. Can you find a page that actually has some records in the Transfers section? Then we'll know for sure whether the variable is actually getting set in the Subreport.

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

Iskandar — Thu, 26 Jul 2018 03:49:23 +0000

Hi everyone, I don't really understand about passing variable from sub report. So i wanna try it and i edit reports from Julian, adding a variable in to Sub report but the result is always zero. I mean i make string variable and the value is "For Test" but why the result is zero, Can anyone help?.

Thank You

gl61ax10ForTest.rpx

ap654501ForTest.rpx

RE: Passing Variables from Sub Report not resetting value when no Value in subreport

Tim Rodman — Mon, 23 Jul 2018 20:53:36 +0000

Hi Ahmed,

Have you tried placing the variable below the Subreport in the Main report to see if that makes a difference? Can you attach the .rpx file for both reports (the Main report and the Subreport)?