+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, Taking ownership of reports [Solved] in Technical; Some time ago a user had a problem with their SIMS account. Their account had to be removed and recreated. ...
  1. #1
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    618
    Thank Post
    41
    Thanked 45 Times in 39 Posts
    Rep Power
    27

    Taking ownership of reports [Solved]

    Some time ago a user had a problem with their SIMS account. Their account had to be removed and recreated. However, under their old account they had created some reports - nice complicated ones that relied on the output of other reports. These reports require editing but, obviously, SIMS wants to save them as something completely different because they no longer belong to the user. This will throw template and other things into disarray.

    So... instead of recreating the reports completely from scratch (long job), I was wondering if there was any way of taking ownership of reports so you can edit them freely and overwrite them. Or, just transferring the reports from one user to the other.

    Or... do they have to be done all over again

  2. #2
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Just open the Report in Design View and then do a 'Save As .......' The new report will then be 'owned' by you!

  3. #3
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    618
    Thank Post
    41
    Thanked 45 Times in 39 Posts
    Rep Power
    27
    I know that route. Problem is, there's that many templates and other bits associated with the various reports, it messes everything up when I do a "Save As...". It's something I'll have to do if I don't find a way of just transferring ownership. That's a last resort kind of thing.

  4. #4
    MicrodigitUK's Avatar
    Join Date
    May 2007
    Location
    Wiltshire
    Posts
    332
    Thank Post
    37
    Thanked 54 Times in 50 Posts
    Rep Power
    24
    Save a new copy with a new name. Make new user with same name as the old one. Use that user to deleat the original. Then rename the new copy back to the original name. Job done.....

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    I understand the issue entirely, there are some procedures on SupportNet to follow in a forum thread or two about how best to 'clone' reports. I think a thread here as well, both probably with input from Sivadam.

    Usually do a Save As, then immediately open the template file associated with it and resave with no changes and then exit and save the report again. This 'should' make a copy of the template and associate with the new report so that neither end up with broken connections. I'm not sure what you've got that is complicated, but it's the built in template that should be the biggest worry.

    What i would do first is to export the report individually, to a folder and tick the check box to take associated templates with it. This means you have a backup. On restore this will be assigned to the system rather than another user. Now you can edit and try to clone this one without affecting your original.

    I know a while back, and i think even now with Office 2010, just opening a template on a system that's not correctly setup with permissions / or the right version of office, could break the template. Certainly the case with individual report templates.

    Hope that helps.

    EDIT: So yes, you do have to recreate reports essentially, there isn't even a global delete permission, so you have to be logged in as that user to delete too. Normally, it's possible to reinstate an old user, change the password and then do edits / deletes if necessary. Not sure what happens if you totally delete the account, though it's not really possible, it only goes inactive. The new user even if the name is changed should still have ownership of the reports, under the new login details. Can't they access?
    Last edited by vikpaw; 24th November 2010 at 09:02 AM. Reason: addition

  6. #6
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    The main issues that arise re. Templates are usually associated with Mail Merge Reports. If the instructions are followed correctly as per the Reporting Handbook - Page 39, 'Editing the Report Mail Merge Document' then issues should not arise.

    So, please regard this as an addendum to my statement above!

  7. #7

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    If the issue is deleting the original ones (not sure if this has been picked up) then at last check you had to go in as the original user, which often meant recreating or reactivating the original user account in SIMS, then deleting that way.

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    There is a routine now for deleted old SIMS users private documents.

  9. #9

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,197
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    Quote Originally Posted by matt40k View Post
    There is a routine now for deleted old SIMS users private documents.
    There is? I've missed that. I'll take a look later.

  10. #10

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Does that include report in the reports setion matt? I honestly don't know but would like to know.

    I know there is the facility to interact with documents uploaded to SIMS that has been there for a bit now.

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Quote Originally Posted by GREED View Post
    Does that include report in the reports setion matt? I honestly don't know but would like to know.

    I know there is the facility to interact with documents uploaded to SIMS that has been there for a bit now.
    I don't think it's for reports, it's for orphaned docs in the document storage, which could technically be a template from a data report, but the actual report definition wont delete unless the user does it. Unless there is a new feature that has been kept very hush hush. . . .?

  12. #12

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    I doubt it, many many people were asking for that for years without success!

  13. #13
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    618
    Thank Post
    41
    Thanked 45 Times in 39 Posts
    Rep Power
    27
    Thanks for the tips. I'll work on it this morning.

  14. #14
    WithoutMotive's Avatar
    Join Date
    Feb 2006
    Location
    Wigan, UK
    Posts
    618
    Thank Post
    41
    Thanked 45 Times in 39 Posts
    Rep Power
    27
    I did as vikpaw suggested and managed to make myself the new owner of these particular reports. Edited the bits that needed it. Exported. Imported. Everything works and the report is owned by the system. Thankfully, no changes will need to be made in future.

    Thanks again, peeps.

  15. #15

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Take a backup of complex reports (ie ones that have complex templates), as SIMS probably still has the editing templates problem whereby it will over write one template from one report with another, very frustrating!!!

    I took backups of all important reports so they could just be reimported should they go wrong!

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Replies: 3
    Last Post: 14th September 2010, 03:12 PM
  2. file ownership
    By ful56_uk in forum Windows
    Replies: 7
    Last Post: 28th September 2009, 07:51 AM
  3. Wikipedia Ownership
    By karldenton in forum General Chat
    Replies: 16
    Last Post: 25th April 2009, 02:18 AM
  4. Ownership and Permissions
    By TechSupp in forum How do you do....it?
    Replies: 2
    Last Post: 5th October 2007, 10:38 PM
  5. SIMS.Net - problem importing new reports [SOLVED]
    By Irazmus in forum MIS Systems
    Replies: 31
    Last Post: 12th October 2006, 02:02 PM

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
  •