Hi, I want to show comments on Sales order lines in a RDLC report.
Below is structure of my report code.
header
{
line
{
}
// here i have added new data item
dataitem(SalesCommentLine; "Sales Comment Line")
{
DataItemLink = "No." = FIELD("Document No."), "Document Type" = FIELD("Document Type"), "Document Line no." = field("Line no.");
column(CommentsLine; "Comment")
{
}
}
}
After running the report I am getting below error message:
Rendering output for the report failed and the following error occurred: The Value expression for the text box ‘Textbox73’ refers to the field ‘LineComments’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
I have tried another solution:
I created a text variable, stored value in this variable in OnAfterGetRecord(). I am getting correct value in this variable. I have then added this variable as a column in Line dataset. But after running report I am not getting any value on my report.
Any help in this regard?
