Skip to main content
Question

Report Designer field shown above row

  • January 13, 2021
  • 3 replies
  • 146 views

Forum|alt.badge.img+6

Hi,

 

I tried to update our Purchase Order lay-out with Report Designer, but the results are disappointing.

I want to show the edited description of the charge on the PO lay-out.

These are the charges I want to show: 

Two charges of the same Charge Type

I have put the fields on the lay-out in Report Designer

This is the result

‘Transport To Location’ is not on the correct line.

How can I resolve this issue?

This topic has been closed for comments

paul harland
Superhero (Employee)
Forum|alt.badge.img+24

hi @bnzKarin 

In this report there are multiple rows in the report definition that represent the same PO line.  They are often hidden with conditions.

The technique i relied on was to set a different background colour on each row, then run the report, to be confident which row needed to be edited.

 


Forum|alt.badge.img+6
  • Do Gooder (Customer)
  • January 14, 2021

Hi @paul harland,

 

Thanks for your response.

I tried your technique, I even set different colours to each field to see the results in the report.

I see that the same line is used for all the fields. Do you have more suggestions? 

 


paul harland
Superhero (Employee)
Forum|alt.badge.img+24

Hi @bnzKarin 

That seems to suggest that your data is not structured as you would hope.  It looks like the Custom field value is not associated with the actual charge line, but is existing as its own line.

The next thing i would try is to export a sample of the data XML file from Report Archive and review that to see where the custom field value is sitting.


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