First of all, we have to download the right report to edit. Because it is a subreport we first navigate to the reports on the reportserver http://localhost/Reports and press the "show details" button in order to display all hidden items as well.
Next, when I chose "Properties", I downloaded the .rdl file to the system by pressing the "edit" link.
Next, I have opened visual studio, created a new "Report server project" and added the downloaded report.
Next, I added a column to the ds_BasicProfile dataset by adding: (select top(1) documentbody as Image from filteredannotationwhere mimetype = 'image/pjpeg'and objectid = @AcctID ) as image, to the query.
The design needed to be changed as well, so I moved the left columns a bit to the bottom and added an image and modified the image's value to =System.Convert.FromBase64String(First(Fields!image.Value, "ds_BasicProfile")) to show the image representation of the stored text.
Geen opmerkingen:
Een reactie posten