MEMO FIELD issue on Reports

(0) Share

Report

Posted on by Ann2015

1,128

I have added a Memo type field on a report and the field is showing no data even though I have data.

How can i display the memo in the report?

I have the same question (0)

All responses (10)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Ann2015,

You have to provide more information here especially how you created the field and what you expect it doing.

Also some info on the code used will help.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report

The field is UserMemo. I am trying to display this field on a report.

Thanks you.

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Did you try adding simple string field , does it show data ? Deploy report and start SSRS service , if its happening on dev VM and see if it helps.

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report

where do I start SSRS service ? I am in D365 F&O.

Thanks!

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Service is on your development VM. Did you debug ur DP class , assuming you are using DP class to populate this field to see if the field has value ? Make sure that value is properly assigned using debugger. If you see value is assigned properly in the code and you still don't see value on report then restarting service might help.

Was this reply helpful? Yes No
WillWU 22,363 on at

Like (0)

Report

Hi Ann,

You can duplicate your report like this.

And debug your DP class to confirm if the field have values in data source .

Then check the control has chosen the right field .

Best regards,

Will

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report

I did debug it this way and the fields has no value, but there is data in the tables. Not sure why I am unable to see the data. SO I am wondering if the datatype memo is the issue?

If I add a str field and assigned a different value then the data gets populated, its only the "memo" field type that is causing the issue.

Thanks.

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

If you are not getting value for your field in your DP class when you debug then problem exist in your code where you fetch the value.

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report

I found an issue in the DP class and now I get the value but it still doesn't show on the report. SO I am wondering if the datatype memo is the issue?

Was this reply helpful? Yes No
Ann2015 1,128 on at

Like (0)

Report

Thank you all, I figured out the issue now.

The DP class was throwing some errors and now the value is populated.

Was this reply helpful? Yes No