+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
MIS Systems Thread, Advanced Reports in Excel in Technical; It's annoying because I know what I want to do and how to do it, but SIMS isn't able to ...
  1. #16
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,214
    Thank Post
    454
    Thanked 176 Times in 173 Posts
    Blog Entries
    3
    Rep Power
    64
    It's annoying because I know what I want to do and how to do it, but SIMS isn't able to cope with it

    I discovered later on that the report I was trying to run would never run because it had too many subreports (the screenshot I've attached here Advanced Reports in Excel) and just gave an error so a marksheet seems to be the only way to do it.

    Unless those of you who have been on the advanced reporting course can suggest a better way of pulling out data of 25 Aspects using the standard SIMS reports?

  2. #17

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,850
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    You can pull data out of the result field we do it to make proof reading sheets. You can also filter by name and or resultset . A good naming convention helps.

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. [SIMS] Sims Report in Word/Excel changes date format
    By Chunks_ in forum MIS Systems
    Replies: 10
    Last Post: 25th August 2012, 12:39 PM
  2. [SIMS] SIMs reports and Macros in Excel
    By GillNash in forum MIS Systems
    Replies: 12
    Last Post: 6th December 2011, 12:00 PM
  3. need to extract text from a string in excel
    By projector1 in forum How do you do....it?
    Replies: 7
    Last Post: 14th February 2007, 01:41 PM
  4. Replies: 3
    Last Post: 10th March 2006, 01:54 PM
  5. Web query in Excel
    By pinemarten in forum How do you do....it?
    Replies: 2
    Last Post: 20th January 2006, 09:22 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
  •