Results 1 to 6 of 6

Thread: Which Database to use

  1. #1
    Join Date
    Mar 2014
    Posts
    2

    Which Database to use

    Hi,
    I am looking at ways that I can deliver reports once a month. Currently these reports are being sent out via e-mail, however, this solution is not working very well.

    It was been decided that it would work better if these reports, around 1000 reports in PDF and Xlsx. were uploaded to a database where individual users can have access to view them.

    I need to limit access to users to ensure that they can only see certain reports, therefore some type of limited rights or permissions would need to be set up for each user, and there would also need to be some sort of auditing tool, to see who is viewing these reports and when they are being viewed.

    If you have any suggestions it would be very much appreciated, as I have little knowledge of what is available to me for this.
    Thanks in advance
    Rob

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you check MS reporting service?

  3. #3
    Join Date
    Mar 2014
    Posts
    2
    Hi rmiao

    Thanks for your reply.

    I am very new to this and I am not sure what is best to use, I have read a little about MS reporting, but I would not be sure how I would get started.

    Do you have a suggestions, or any good places for resources to get further information

    Rob

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938

  5. #5
    Join Date
    May 2014
    Posts
    3
    Definitely I would check SQL Server Reporting Services from Microsoft, as the most popular solution. Apart of SSRS, there are also some alternatives as Crystal Reports, for example.

  6. #6
    Join Date
    Feb 2015
    Posts
    2
    Quote Originally Posted by Robert110 View Post
    Hi,

    I need to limit access to users to ensure that they can only see certain reports, therefore some type of limited rights or permissions would need to be set up for each user, and there would also need to be some sort of auditing tool, to see who is viewing these reports and when they are being viewed.

    Rob
    I thought this tool from Datapine might be helpful to you. It delivers scheduled reports and gives select people limited access to your dashboard. It isn't free but I think it might work if you don't have top knowledge of DBs and SQL.

    www.datapine.com

    Good luck, H.

Posting Permissions

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