Picture/Image report for Net Display

No reports that will make this happen for you out of the box, but here is an SQL Query;

SELECT * FROM Item WHERE PictureName ''

This will show you all of the items that have a picture associated to them. The PictureName is just that, the name of a file. The path to that file is dictated by the contents of the Pictures property located in RMS SO Administrator -> File Configuration -> Paths.

Hope this helps.

Thanks that worked can you tell me how I can I add PictureName to the default price list report in manager is there away I can add it to a the column to show image path names

Thanks Al

"Ryan" wrote:

By and large, you should be able to copy a field like AccountNumber, change AccountNumber to PictureName and you should be set for adding it to a report. As far as the full path, that would be tricky, at best and, I believe, impossible if you want it to be auto updated if you change it in Administrator.

I added this to item sales report and it works thanks

Begin Column FieldName = "Item.PictureName" DrillDownFieldName = "" DrillDownReportName = "" Title = "PictureName" VBDataType = vbString Formula = "" ColHidden = True ColNotDisplayable = False FilterDisabled = False ColWidth = 1140 GroupMethod = groupmethodNone ColFormat = "" End Column

"AL" wrote: