Printing Notes - sometimes repeats first note, and not other

Shaggs

I am printing notes for an unposted sales invoice. I am only printing it in the RTC, and am displaying using the code:

=IIf(IsNothing(Fields!RecordLink_Note.Value),"", System.Text.Encoding.UTF8.GetString(Fields!RecordLink_Note.Value))

in the textbox (in RTC report layout).

For the most part, this works fine.

I have found, however, that sometimes it does not come out right, depending on the content of the notes.

If I have one note only, it works fine.
If I have two notes, where the text component is the same, but number component is different, it only prints the first one twice. For example, if the notes are "Order 1234" and "Order 1235", it will print "Order 1234" twice.
If I hvae two notes, where the text component is different, it prints fine. For example, the Notes "Order 1234" and "Order 1235 - Urgent" will print fine (both will print).

This seems like such an odd bug. I had to show it to a colleague, to ensure I wasnt going insane.

Does anyone have any experience with this? How I can resolve this?

bonzie

Have you placed the textbox in the right data item sections?

Because i have experience with this and based on my experience that happened because I put the textbox in the wrong sections (Classic not in Layout).

Hope this helps



Cheers

Shaggs

bonzie wrote:

Have you placed the textbox in the right data item sections?

Yes - the textbox with "Note" in it is in the right section. I am quite convinced (after considerable testing) that the issue is the contents of the notes.

kine

Use the function "About this report" to see the data sent to the report...

Shaggs

kine wrote:

Use the function "About this report" to see the data sent to the report...

Already tried that. Nothing out of the ordinary. Of course, the actual notes text is sent as a binary (so it just appears as an asterix), so I cant tell if that is right or wrong.