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
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
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
/Michael