Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Report Showing Missing Images


Report Showing Missing Images

Author
Message
mysorian
mysorian
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 101
You need to use only this in your report:
Hidden= Fields!Picture.Value is Nothing

Have you tried to set the visibility property of the image?
eric.muller
eric.muller
Mr or Mrs. 500
Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)

Group: General Forum Members
Points: 562 Visits: 1306
Mysorian, I think you may have misunderstood the OP's actual question. It's not that he wants to hide the image if it doesn't exist, but he wants to write a report that tells him who has an image and who doesn't, which he currently can only see by looking at the report with the pictures and seeing who has a red "x".

You're taking a good stab at answering the wrong question ;-)
mysorian
mysorian
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 101
Can you access the source of pictures on the file system?
dedeod
dedeod
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 61
Yes, I can access the files and create a file of employee id number to compare outside of SQL. I was hoping for a solution that Report Manager based so our security staff could run the report at any time and see who does not have a badge.
mysorian
mysorian
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 101
If you can access the file system why don't you write a program to access the FileSystemObject and find files which are empty for the badge image field? This way you can get a report independant of SSRS.
Report Manager uses Report Builder to modify the report.

This is just an hypothetical method: Create a linked report with Photo(badge) as the parameter and create two folders Badge and No badge. Using this parameter you may be able to populate the nobadge folder. Report Manager can create linked reports.
dedeod
dedeod
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 61
I know how to create linked reports in Report Manager but I don't understand what you mean by creating a parameter for Badge or No Badge. How is that going to filter for those?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search