Image reporting from table related to asp dot net or mvc

Omer Ayna

In 1 to 1 related product and picture tables, the relationship id is pictureid. On the side with multiple pictures, picture paths are hidden in the picture variable. It looks like /picturedirectory/h.jpg. The pictures are physically present in the picturedirectory folder. I want to extract the picture or pictures from the id of a product with microsoft.reportviewer. It means printing from the picture table. The pictures are in the pictures folder. I could not find asp net dot net and asp net mvc examples regarding this. Best regards

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana2y ago
Accepted answer
If you have the image paths stored in your database and the images are physically present in a directory, you can display these images in your ReportViewer control by setting the image source to “External” and providing the image path. Here’s how you can do it:
1. In your RDLC report, add an Image control where you want to display the image.
2. Set the Image control’s Source property to “External”. This tells the ReportViewer control that the image is not embedded in the report, but is available at an external location1.
3. Set the Value property of the Image control to the field in your dataset that contains the image path1.
4. In your code-behind file, enable external images in the ReportViewer control12. Here’s an example:
```
this.ReportViewer1.LocalReport.EnableExternalImages = true;
```
1. If your image paths are not absolute (i.e., they are relative to your application’s root), you may need to convert them to absolute paths before setting them as the Value of the Image control1. You can do this in your code-behind file when you are retrieving the data from the database.
Please replace the placeholders with your actual data.

Thanks

Jayraj Chhaya2y ago

To extract pictures from the picture table based on the product ID using Microsoft ReportViewer in a Dot Net MVC application, you can follow these steps:

Retrieve the picture path(s) associated with the product ID from the database.
Pass the picture path(s) to the ReportViewer control to display the image(s) in the report.

// Assume you have the product ID stored in productId variable
int productId = 1;

// Retrieve picture path(s) from the database based on the productId
var picturePaths = db.Pictures.Where(p => p.ProductId == productId).Select(p => p.Path).ToList();

// Pass the picturePaths to the ReportViewer control
ReportDataSource reportDataSource = new ReportDataSource("PicturesDataSet", picturePaths);
ReportViewer1.LocalReport.DataSources.Add(reportDataSource);
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/ProductPicturesReport.rdlc");
ReportViewer1.LocalReport.Refresh();

Ensure that you have a report (ProductPicturesReport.rdlc) set up with an image control bound to the picture path(s) dataset.

Omer Ayna2y ago
I am looking for a code to list the expression stored in the imagepath variable in the image table from the physical image file folder according to the imageid relationship from the product id to the image table linked to it in multiple related tables.