I am hoping that someone can assist me with this one. I am trying to upload documents into SQL Server to include as a subreport within my crystal report. I have the file (in this case a text file) uploaded to an image field in the database.
I create the DataSet as a xsd file and I can view the file_data field as a base64Binary field, but when I try to add the field to a report it is not visible and won't allow me to add it to the report (when I view the dataset it says the field is a System.Byte[]).
**Background on issue... the report is a listing of tasks... and different locations like to use different forms to complete the task so I allow the users to upload their own files (txt,pdf,word) into the sql database. When the crystal report prints.. it will print a listing of the task in the parent report and the form they will use to complete the task in the subreport hence the the issue.
I create the DataSet as a xsd file and I can view the file_data field as a base64Binary field, but when I try to add the field to a report it is not visible and won't allow me to add it to the report (when I view the dataset it says the field is a System.Byte[]).
**Background on issue... the report is a listing of tasks... and different locations like to use different forms to complete the task so I allow the users to upload their own files (txt,pdf,word) into the sql database. When the crystal report prints.. it will print a listing of the task in the parent report and the form they will use to complete the task in the subreport hence the the issue.