Link to home
Start Free TrialLog in
Avatar of nreich
nreichFlag for United States of America

asked on

How to publish crystal reports on intranet (It is share point)

Hi

we purchased new Crystal Reports 2013, developed few reports and ran them. Now how to publish them on intranet.

Prior to this version, we used crystal 9 and users used to access them on intranet. How to do the same with this newer version.

Thanks
Avatar of vasto
vasto
Flag of United States of America image

I am not clear what is your goal. Do you have SharePoint server and you want to make the reports available there or you want to make these reports available to your users in the local network (intranet) ?
Avatar of nreich

ASKER

We have SharePoint 3.0 WSS Intranet and want them to be available there.
This will require custom coding. You need to add SharePoint tag.  It is not very likely a Crystal report developer to know how to create a web part
A simple and inexpensive approach is to use one of the 3rd-party Crystal Reports Schedulers (see list at http://kenhamady.com/bookmarks.html) to schedule exporting the report to PDF, Excel, HTML, etc. and any desired frequency and loading the resulting files to Sharepoint.

If the scheduler doesn't provide a direct option to export to Sharepoint, you can:
* Use a mapped drive (see http://webdogs.org/step-16-mapping-a-sharepoint-web-drive/).
* Use FTP or SFTP upload options
* Use a tool such as WebDrive (~$70): http://sites.fastspring.com/south/product/webdrive?action=adds
ASKER CERTIFIED SOLUTION
Avatar of vasto
vasto
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of nreich

ASKER

Your are right. The 1st point is our goal. that is what happening now with our existing Crystall 9 reports.

When we run the report on our sharepoint the url comes up is as below.

https://crystal.OurDomain.com/Reports/Sales/OurReport.rpt?apsuser=User&apsauthtype=secEnterprise&user0=ctaccess&password0=ima&init=actx

Now, how to follow the same with CR2013.

Thanks in advance.
Avatar of Mike McCracken
Mike McCracken

That looks like you were using Crystal Enterprise to run the reports.

You may need to use Crystal Server to get the same capability

mlmcc
Avatar of nreich

ASKER

Thank you mlmcc.

Is there any other way to run CR2013 reports on our sharepoint website without going for cystal server.

thanks in advance
Vasto gave you several options

mlmcc
Avatar of nreich

ASKER

In addition to these excellent solutions, we also purchased a product called ReCrystallize to help us create aspx files from the rpt files to use and imbed within our SharePoint site.

Thanks everyone for your awesome and quick replies.