Im struggeling to make Reporting Services to do as I want. I have a list of categories, which again have a list of products.
Category 1
- Item 1.1
- Item 1.2
...
Category 2
- Item 2.1
- Item 2.2
...
Each category have their own image, and the image is shown correctly. I have set the Size->Display property on the image to Fit propotional since the images have different size.
When there are many item lines, this works fine. The image fits the width and height. The problem occur when there is only one item in the category. Then the image is scaled down to a tiny image that fits one line.
I would like it to fit the width of the column, but it shall have a variable height.
I know I could have solved this by setting the display property to Original size and then manually resized all the images to have the same max width as the width of my column. But I do not want to resize the images outisde Reporting Services.
Any thoughts, maybe I can use some kind of VB snippet?