Subreport working in groupFooterSection1 but Sales figures incomplete

Hi William,

I’ve played around with the subreport and have got it printing the CR Relations.

I’ve amended the TargetNoteID variable to the following:

=Concat($TargetNoteID ,[CRRelation.TargetNoteID_Description], '{br}')

This removed the zero.

Hope this helps.

I’ve tried using your solution with just the values in the subreport that were in the original submission, but all that shows up is a blank page. I feel that we are close, but seem to be missing something. Thank you for sticking with me on this and I appreciate the extra help.

An interesting sidenote: When I add the subreport to the main report, I get an error: 

I do have the same settings in the main report and the subreport settings have been taken out. The subreport parameters from the main report are the SOOrder.OrderType (RQ) and the SOOrder.OrderNbr (RefNbr, RQ000864).

Hi ​@wmatthews1877 , To resolve “Response is not well-formed XML”, can you rename the subreportid with proper acumatica reportid format, instead of “SO641000Sub2.rpx” .

It worked perfectly except there is one extra line as shown below:

I am thinking that maybe the ‘{br}’ may be causing this? I am going to take that bit of code out to see what happens. Thank you.

Hi ​@wmatthews1877 , Still you have 0 in the first line before RA, RM000735. You can use VisibleExpr to hide 0 from the display

Nope, that last duplicated line still shows up. I’ve normaled it back up and I didn’t notice it before but the zero is still there at the beginning of the RA.

I’ll see what I can do for that. Any suggestions as how to get rid of that third line?

In subreport, check the grouping condition once. The group should created for TargetNoteID ,[CRRelation.TargetNoteID_Description]

In the grouping section I only see one group:

Also on another note, I’ve tried using a =IF(LEFT(Concat($TargetNoteID ,[CRRelation.TargetNoteID_Description], 1 = 0, ''), Concat($TargetNoteID ,[CRRelation.TargetNoteID_Description], '{br}'))) but this just made a mess out of things.

Sorry, getting an “Open server settings Response is not well formed” again in the subreport using the same parameters.

I added back the [CRRelation.TargetNoteID], it worked but the lines shows as the first line on top, then a bunch of CR-LF, and all three lines repeated. I then substituted the [CRRelation.TargetNoteID] with the CRRelation.TargetNoteID_Description] and received the “Open server settings Response is not well formed”.

Can you please share your subreport to review

My user says for now the 0 is okay, but I will need to continue working on the two issues:

1. Take the 0 out of the line.
2. Take out the third line since it’s a repeat.

I appreciate the help, as this solution should work with another report that I have. I will continue to work on resolving issue a & b.