Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Report Showing Missing Images Expand / Collapse
Author
Message
Posted Monday, June 17, 2013 3:01 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 40, Visits: 80
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?
Post #1464390
Posted Monday, June 17, 2013 3:04 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 365, Visits: 904
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
Post #1464391
Posted Monday, June 17, 2013 3:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 40, Visits: 80
Can you access the source of pictures on the file system?
Post #1464402
Posted Monday, June 17, 2013 3:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 31, 2013 3:09 PM
Points: 18, Visits: 60
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.
Post #1464414
Posted Monday, June 17, 2013 8:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 5:43 AM
Points: 40, Visits: 80
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.
Post #1464436
Posted Thursday, June 20, 2013 11:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 31, 2013 3:09 PM
Points: 18, Visits: 60
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?
Post #1465861
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse