[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Running reports through Sharepoint

Posted on 2011-03-17
3
Medium Priority
?
383 Views
Last Modified: 2012-08-13
I have a SQL Server DATABASE with the wrong Collation (Latin) which I posted a previous message concerning not being able to load in Sharepoint.

I have now linked the database (table) to Microsoft Access and then linked again to a sharepoint list.    I am looking for some general advice on how i should go about running reports in sharepoint to querry this DB or list without sharepoint just loading Microsoft Access and giving a list of reports.

Any help appreciated.
Richard




0
Comment
Question by:RichardH1976
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:RichardH1976
ID: 35161512
Actually after some more research tonight.   I think I would be happy to just run Access reports directly from Sharepoint.    I can run a view but cannot find anyway to run a report directly through sharepoint.

There is information online that implies I can do this but struggling to implement it.

Richard


0
 
LVL 44

Accepted Solution

by:
zephyr_hex (Megan) earned 1500 total points
ID: 35325068
i would go with SSRS.  if it's the wrong collation, you may not be able to use sharepoint integration.  but you most certainly can still use SSRS and then display or link reports to sharepoint.
0
 

Author Closing Comment

by:RichardH1976
ID: 35358743
This was just a partial answer
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question