Publishing Crystal Reports in ePortfolio 1

[Betz]

Report developed in CR 9.0 Data from SQLServer. When in Crystal Reports, report generates successfully. When same report is published in ePortfolio, user receives the following error.

There was an error retrieving data from the server: “Failed to open a rowset. File c248.rpt”

Is this caused on the Crystal Reports side, or is it an error caused by SQLServer?

 

[synapsevampire]

The error is generated when publishing the report, or did you mean when executing the report?

If it's during publishing as you stated, then you may have a service that isn't running, or the MSDE database.

If running try applying the service pack:

http://support.businessobjects.com/downloads/updates/service_packs/enterprise.asp

This type of error can also be caused by having checked the File->Save data with report within Crystal Reports, amongst other things.

-k

 

[Betz]

Thanks.

Error is generated when executing the report.

We don't typically save data with a report, but I double checked to be sure it didn't get checked.

Could this be about permissions settings in ePortfolio?

 

[synapsevampire]

It could be that you didn't complete the database and/or the parametrs tab.

If a user can see the report, and they have the option to schedule or run, then they already have permission.

Note that your post states that it happens when it's published, hence my *guessing* at the solution.

Now I'd guess that you're new to CE, and you haven't provided the appropriate credentials/parametr info, or the report is using a data source such as ODBC which isn't on the CE server.

-k

 

[Betz]

Thanks for the guidance.

Error is generated when executing the report. Not publishing.

I am not the ePortfolio administrator - hence lack of knowledge on that end. Right now I am trying to troubleshoot this error to see if it is from my end (I develop and publish CR to Enterprise) or is it on the SQLServer or ePortfolio administration end. It seems that, since the report executes find in CR, that it is on the other end, but I have no concrete knowledge to base that on.

Can you tell me what database and/or parameter tabs you refer to? Is that in ePortfolio or CR?

 

[synapsevampire]

In ePortfolio.

Ask the adminstrator to verify that the login and parametrs are set.

Also make sure that the CE server has the same ODBC connectivity set up.

-k