I have a sql report that shows the general information about a person (name, address &) and the notes, with the date entered and initials of the officer who wrote the note, when I run the report it returns all the information I am asking for but once the report is published the notes along with the date and initials no longer show up. All of this information is one view created for this report. I tried to creating a new dataset that pulled the information I wanted form the notes table, Select * From Notes Where OfficerInitials = @OfficerInitials, and I had the same results. The only thing in the table that we saw as odd was that the notes data type is nvarchar(2700), within the data set I converted notes to varchar(max) but it still didnt show in the published report. Nothing form that table shows up in the published report. Does anyone have any ideas on what could be causing this problem?

Thank you for your help
Nick