+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Report to show titles of linked documents in Technical; I'm wanting a report to show me details of documents linked to students in the DMS. I cant for the ...
  1. #1
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    89
    Thank Post
    5
    Thanked 19 Times in 11 Posts
    Rep Power
    17

    Report to show titles of linked documents

    I'm wanting a report to show me details of documents linked to students in the DMS.
    I cant for the life of me find the right fields.

    If it can be done i would like: Document name, Date added.

    Anyone have any ideas?

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,462
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    I'd love to be proven wrong, but I don't think there is any way to run such a report from SIMS' reporting engine, at least I've never found it.

    On a related note, I've been trying to gain access to the infamous Business Objects to run reports outside of SIMS' capabilities for some months now, still hasn't happened.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,682
    Thank Post
    692
    Thanked 1,408 Times in 1,166 Posts
    Rep Power
    354
    Do you have access to the SQL via management studio?
    I haven't used this for a long time, but i still think it's valid, though i haven't double checked, it ran okay:
    Code:
    use sims
    select dm.attachment_name,
    dm.last_modification_date,
    dm.last_modified_by,
    dm.note,
    dm.summary,
    dm.entity_id,
    dm.created_by_id,
    per.surname,
    per.forename,
    stud.latest_adno
    from sims.stud_student stud join sims.dm_document_710 dm on dm.entity_id = stud.person_id
    join sims.sims_person per on dm.entity_id = per.person_id
    where stud.latest_adno = '001234' AND dm.attachment_name IS NOT NULL
    Will give you the latest modification date, which is for us normally when they get uploaded.
    All you have to do is fill in the admission number for the student. Or remove that clause and you'll get all students.
    The name might not be too usable as it includes what look like random characters at the start.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Assigning form reports to a head of year???????/
    By ChrisH in forum MIS Systems
    Replies: 5
    Last Post: 12th July 2011, 10:56 PM
  2. Replies: 1
    Last Post: 19th August 2010, 09:51 AM
  3. Saving edited Individual Reports to Linked Documents
    By sallie_wan in forum MIS Systems
    Replies: 10
    Last Post: 20th March 2010, 11:22 AM
  4. Task Bar icon to show level of user
    By garethedmondson in forum Windows
    Replies: 31
    Last Post: 16th March 2010, 10:25 PM
  5. Changing the path of my documents to a users home drive
    By hig in forum Windows Server 2000/2003
    Replies: 7
    Last Post: 20th April 2009, 09:41 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •