NAV RTC 2009 R2 - simple report question

Hi!

I’m trying to add a field to the 208 Sales Shipment report.

The field in question is: Sales Shipment Comment Line.

I’ve got the field working in the Classic report, but when I add a table in the RTC report containing the field, it outputs on page 2, and not in the list where I’ve added the table.

If I add a table header, then the header is displayed correctly on page one, and on page two both the header and data is displayed.

I’m at a loss as to what is wrong! As a work-around, I’ve added another list and put in before the original list, and then the data is printet as expected, though not where I originally inteded it to be located, however a blank page 2 is also printed…

I hope someone more experienced in the art of designing RTC reports could provide me some insight into what’s going wrong :slight_smile:

Best regards,

Michael

Welcome to DUG…

Can you show us the rdlc view?

Thank you, I’ve attatched a screenshot here.

/Michael

What exactly is your requirement and why did you add in the middle of report?

did you try by adding the table and fields at the end?

That’s a fair question :slight_smile:

I have tried adding the table different places on the list, and the result is exactly the same, header on page one and header and data on page two.

My intention is to have the table below the sales shipment lines, and only the data part of the table, as I’ve done in the list above the original list.

/Michael

then I suggest you to move the Bill to Address table down and add your table there…

And Check you have added fields in right section like body in table…you can check with adding back colour…

you can check the result set from About this report…

Thank you for your suggestions.

I’ve moved the Bill to Address table down and places the Sales Comment Line above.

I’ve tried adding a background colour to the table and on page 1 I can see the background colour, but NO text, on page 2 I can see the background colour and the text. My problem persist being that the data part of the table does not show on page 1, but only on page 2.

I can verify that the data is present in the About this report (and as seen on page 2).

I’ve attached screenshots of the RDL editor, and of the report output.

4812.rdl.bmp (4.85 MB)8713.page1.bmp (3.67 MB)5811.page2.bmp (3.67 MB)

/Michael

Bump… Anyone have any inputs?

/Michael

Solved!

I finally solved my simple problem…
It turned out to be a section indent problem. The section I’ve added was the last section on the classic report and therefore not included in the page loop section. When I moved the section upwards in the report and placed it below sales shipment line, everything worked just fine :slight_smile:

/Michael