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
Solved

Using Sharepoint as a repository for Crystal Reports

Posted on 2014-04-08
5
1,744 Views
Last Modified: 2014-05-01
Hello,
We are getting ready to implement sharepoint. I would like to use sharepoint as a repository to hold all of my reports where users can go to and and run these receiving the prompts and receiving the correct data.

1. is there a connector needed to run CRS.

2. where are the reports stored and does SharePoint just point to them in their current server?

3. these reports are pulling data from Sage 300 will the DSN's still work as they are or will we need to make new DSNs?

4. If we use a product like anterra to house all the data please let me know if you have any suggestions.

The main answer I need is how to connect the reports to SP and will they run as they would out of sage? also is there a similar answer when using SSRS?
0
Comment
Question by:mikeg95
  • 3
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39987095
Where are the reports stored now?

By CRS, I assume you mean Crystal Reports Server.
CRS stores the reports in its own database.  If you want to use SharePoint as a repository you wil be maintaining 2 copies of each report.

I believe you can run reports from CRS through a URL call which can be from SharePoint.

You probably will have to build your own web part for SharePoint.

What version of CRS?
What version of SharePoint?

If you move the reports the DSNs will have to be recreated on the SharePoint server and the reports changed to use the new connections.

mlmcc
0
 

Author Comment

by:mikeg95
ID: 39987160
The Crystal Reports are stored on the Sage 300 Application server.
we are using CRS XI release 2 for sage
and SP 2013.

are you familiar with Anterra? if we use Anterra's DSN then It should work fine in Sharepoint.
I guess what I am trying to ask is when you load the .rpt into sharepoint how does it run the report for the user versus opening up the design?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39987367
Currently there is no integration kit for SP2013 and Crystal
http://scn.sap.com/thread/3259264

According to the question at this link as of early March this year it still didn't work with SP2013
http://scn.sap.com/thread/3512989

I am not familiar with Anterra.

You don't load reports into SharePoint.  To view a report requires a viewing application.  That application can be linked from SharePoint.

mlmcc
0
 

Accepted Solution

by:
mikeg95 earned 0 total points
ID: 40018235
SAP offers a Sharepoint integration Kit that works with their latest CRS and Sharepoint 2013
0
 

Author Closing Comment

by:mikeg95
ID: 40034107
after calling SAP they informed me that I needed CRS and the Sharepoint integration Kit to complete this task
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Chrome SSRS print Functionality 1 60
SSRS - Image from DB has ugly blue border !? 8 40
SSRS 2013 - Overlapping reports 2 32
SSRS 2016 Rendering HTML tables 3 26
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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