+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, Sims and Crystal in Technical; Is it possible to connect a Sims database to Crystal reports (9) If so - How? I'm quite new to ...
  1. #1

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Sims and Crystal

    Is it possible to connect a Sims database to Crystal reports (9)

    If so - How? I'm quite new to many things computing so please be as basic as possible if this can be done.

    Thanks

  2. #2

    Join Date
    Sep 2008
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yes this is possible but you need to have access to the sims sql database.
    When you have this all you need to to is link it as an sql data source in crystal. I would check with capita / your LA if they are happy with you doing this as i know sometimes they get funny about it.

    I would recomend that you use the command reporter tool that is included with sims to get the data you require and output it to a csv that you then use that in crystal.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Hi Sarah,

    Sounds like you don't actually want to use crystal, I would look at the reporting engine in SIMS .net. Focus | Reports. Which will pull out any information a school will ever likely need. Your LEA will use Crystal on the ONE\EMS system, which is basically a large (LEA-style) "sims" system.

    Regards,

  4. #4

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Sorry i should have given a bit more info. I work for an la and want to teach myself crystal and if i can attach it to the training data set of sims to practise with. But i've tried to see how you attach it and it has me completely stumped

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Sorry, never heard of anyone wanting to nor needing to run crystal reports against the SIMS database. They use crystal on the ONE system, but that's different. That's only now going .net!!

    What are you trying to pull out of SIMS?

  6. #6

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Nothing specific i just want a familiar dataset to play around with to learn how to use crystal to report

  7. #7

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,522
    Thank Post
    374
    Thanked 677 Times in 551 Posts
    Rep Power
    166
    Ask on SupportNet (Local Authority forums --> One: Crystal Reports).

  8. #8

    Join Date
    Apr 2009
    Posts
    10
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    All my forums on supportnet are for sims, i don't have a forum for One



SHARE:
+ Post New Thread

Similar Threads

  1. Crystal Palace school what to see your VM setup
    By nicholab in forum Thin Client and Virtual Machines
    Replies: 9
    Last Post: 24th April 2009, 11:05 PM
  2. 'Back saving' with Crystal Reports
    By Ric_ in forum MIS Systems
    Replies: 1
    Last Post: 16th January 2009, 10:42 AM
  3. Access, Crystal or EMS developer - 6 month contract yorks
    By SpecialAgent in forum Educational IT Jobs
    Replies: 0
    Last Post: 21st October 2008, 04:24 PM
  4. Crystal ICT Channel
    By conehead in forum Educational Software
    Replies: 13
    Last Post: 14th May 2008, 07:04 PM
  5. Sherston - Crystal ICT (autologin)
    By contink in forum Scripts
    Replies: 4
    Last Post: 12th May 2008, 10:08 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
  •