Forum Discussion
Report - Image Background in preview grey
- Dec 11, 2023Thanks. I am also going to ask a colleague who is much more involved with managing images to take a look at this problem.
Good morning George_Hepworth ,
i normally do not store the images directly in the database. But this is how the customer wants it to be. And it is an sql server as backend. The number of images will stay below 500-600. At the moment these are roughly 300.
I used the same settings as you did:
In the report view everything looks nice
But in the preview it does not. And the problem is that the preview is how it looks as pdf.
Ah, you didn't mention that the Back End is in SQL Server.
The only other thing I can think of would be to use the Format event of the report section where the image control is. You can make the image control visible or not visible, depending on whether there is an image in the image control.
In the screenshots, there are other display differences between the report view and print preview appearance of the images.
What image format is used? jpg, png or something else?
- MikkoRieseDec 11, 2023Copper ContributorI tried it and it works like charme.
Thanks a lot - MikkoRieseDec 11, 2023Copper ContributorThe sub report is not visible in the preview. As it contains no data, but it is vible in the report view. This is ok.
I use png format.
I will try to hide the image box if no image is there.
I let you know if it works.- George_HepworthDec 11, 2023Silver ContributorThanks. I am also going to ask a colleague who is much more involved with managing images to take a look at this problem.
- MikkoRieseDec 13, 2023Copper ContributorHello
i removed all the grouping from the report (as a copy report).
And now the pictures look as they should.
But now the data of the sub-reports can not be hold together.
Do you know if i can disble page breaks via vba?
Then i could place page breaks between the subreports and disable them depending of the amount of data within the subreports