This is a SQL Server database with products table which serves as product catalog for a live website. Client wants to pull the data in that table down in some file format (Excel, pdf ). The table has an image column (image of the product), which stores path to the images on local hard disk.
The output file should also have images (photos) of the corresponding products.
I see SQL Server Reporting Services is already installed there on the server. I have never used it before but I know that Reporting services could be used to generate reports in pdf / excel / csv formats.
How do I pull the data down, which file format will better serve the purpose and could reporting service be of any use ?