We help IT Professionals succeed at work.

How do I build a report to select and view scanned images

160 Views
Last Modified: 2012-05-08
I'm trying to build a report which will allow a user to search for a specific person in a table which will display all existing scanned documents pertaining to them. I thought I could build a database table with the person's reference number and name, and the filepaths for all those scanned documents, then report from this setting a hyperlink to pull up that file.

This was a good idea in theory but not quite there. Unless someone can tell me otherwise, the only way I'm going to be able to do this is to upload all the possible files to report server. Is this true? If so, I have a big problem as the upload file button only allows me to upload one file at a time and I have 143,000 in the folder I'm trying to copy up!!! Can anyone suggest any alternative approaches please?

The other problem I'm having is that the images are all .TIF files. I can open the files up in Windows Picture and Fax Viewer but reporting services doesn't seem to recognize I have this on my pc. Do I need to convert them all to something like PDF first instead?  
Comment
Watch Question

Grffster, You could look at using Sharepoint? either WSS or MOSS, WSS 3.0 is free with a server 2003 license, MOSS Just add's on to the abilities of WSS

Commented:
The easiest approach is to use an Image Library that hosts your images. Add an additional column that associates the user. Then you can filter/group by this column. >100k items in a list is possible, but perhaps you'll notice some performance issues. This approach is done in 30minutes, multiple files upload is no problem.
Martin GriffithsIT Development Manager

Author

Commented:
I have a spreadsheet that holds a reference number, a person's name, and a file location. Would I be able to port this information across to WSS 3.0 (excuse my ignorance here, but is this like an image library mentioned above please?

Commented:
You can build up a SharePoint list from an Excel sheet or create your SharePoint list and copy&paste your Excel data in this list (it has to be "compatible" in some way). But this is not the imag library that I mentioned above, this is just a plain text list. This approach is feasible if you're just interested in the path to your images but not the images itself.

Another possibility could be (dirty hack!) put your images in a web accesible folder  (e.g. _layouts) and insert in the list an image link (e.g. <img src="_layouts/MyImages/image0001.jpg"/>). A document library is nothing more than a specialized list for such things.

Grffster,

Sharepoint allows you to build a list with attachments, in this case images.  You would then have your fields / meta data assigned so you can filter the list, search the list etc. SharePoint has some really powerful document management features.
Martin GriffithsIT Development Manager

Author

Commented:
Doesn't look like WSS 3.0 comes as part of the installation for Windows 2003 Server, so I'd have to download it and enter our Windows 2003 Server licence key correct?

If I was to use sharepoint I would need the functionality to bulk populate a list setting the meta data (?) so that the user could filter by person's name or reference. If I had to attach the fields/meta data for each individual image file (143,000 in total) it wouldn't be a feasible solution.

Would sharepoint deal with TIF files by the way?
Grrfster,

It's under the Add / Remove Programs it comes standard with 2003 but it is not installed.

How are you going to use the 143k pictures currently anyway? Do you  have a SQL table referencing them to the appropriate people?

Commented:
>  so I'd have to download it and enter our Windows 2003 Server licence key correct?

You've to download and install it, WSS is free (if you've Windows Server 2003/2008 licence).

> If I was to use sharepoint I would need the functionality to bulk populate a list setting the meta data (?)

You can construct a list from an Excel sheet if your meta data is stored in this list or you can build a small console app that does the job of creating new list items.



> Would sharepoint deal with TIF files by the way?

What do you exactly mean by "dealing with"? SharePoint can store and show tif images.




Commented:
> It's under the Add / Remove Programs it comes standard with 2003 but it is not installed.

Really? Oh, I've always downloaded and setup.exe(cuted) it ;)
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Martin GriffithsIT Development Manager

Author

Commented:
The spreadsheet looks something similiar to the attached. We would need to be able to search for any records for agreement  = an entered value, or against anyone with a name like an entered value (in sql speak like '%smith%' for example. This would then give us a list of all possible images allowing us to select and view whichever ones we want.
example.xls
Martin GriffithsIT Development Manager

Author

Commented:
Can't find WSS 3.0 in add/remove programs. Tried microsoft components too but, unless it's embedded within a particular install category I can't find it.

Commented:
> We would need to be able to search for any records for agreement  = an entered value, or against anyone with a name like an entered value

This can be done with the DataView web part.

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Martin GriffithsIT Development Manager

Author

Commented:
Ok, thanks. I'm going to have to take my director through this on friday now as he's away for the next couple of days. Will let you know how I get on then.
Martin GriffithsIT Development Manager

Author

Commented:
Well it turns out in the end that my reporting services report did actually start working once I'd added a windows share to the folder containing the scanned images! No need to therefore install WSS. Sure this would have worked though but may have been a hammer to crack open a nut.
Glad to hear it worked! I think I misunderstood the original question, I thought you were trying to upload the IMAGES into Reporting Services.
Martin GriffithsIT Development Manager

Author

Commented:
Well it wouldn't open so thought the only solution I had initially was to upload all the images into reporting services individually, which would have taken weeks seeing how many files there were.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.