| Author |
 Topic  |
|
|
anavagomez
29 Posts |
 Posted - 08/01/2012 : 14:43:46
|
Hello,
I would like to know a couple of things. First, how is crystal reports enable on report portal?
And, if installing/ enabling crystal reports, will I be able to download a crystal reports in excel format, not just the raw data, but if the crystal report contains a chart, will the chart also be downloaded?
Thank you.  |
|
|
admin
1635 Posts |
Posted - 08/01/2012 : 16:00:53
|
Once the Crystal Report server component is installed on the web server, you will be able publish Crystal Reports into ReportPortal by going to Design > SQL Reports > Crystal Reports.
http://www.reportportal.com/help/crystal/install.htm
Yes, when exporting a Crystal Reports to Excel you will be able to exports data, charts and images. You can try doing this yourself on the Demo server:
http://www.reportportal.us/ReportPortal
Look under "Crystal Reports" Folder |
 |
|
|
anavagomez
29 Posts |
Posted - 08/02/2012 : 09:13:03
|
Will there be any browser compatibility issues, or the functionality will be the same for all or most browsers?
Thank you much for all the information. |
|
|
|
admin
1635 Posts |
Posted - 08/02/2012 : 13:07:04
|
| ReportPortal runs on Internet Explorer 5.5 or higher, Firefox, Safari or Chrome. |
|
|
|
anavagomez
29 Posts |
Posted - 08/14/2012 : 15:13:00
|
We were able to install CR plug-in, but now I am experiencing errors when trying to open a report that takes a string input parameters field named VendorID.
This is the error that appear when opening the report:
The types of the parameter field and parameter field current values are not compatible.
CrystalReportViewer -
Error: Object reference not set to an instance of an object.
Any ideas?
Thank you much.
|
|
|
|
anavagomez
29 Posts |
Posted - 08/14/2012 : 15:31:10
|
| Can the CR used parameteres in report portal? |
|
|
|
admin
1635 Posts |
|
|
anavagomez
29 Posts |
Posted - 08/15/2012 : 08:11:41
|
The issues with the parameters was that my date range was set up as one field on crystal, I changed that to two fields (start and End) and then I was able to see the 2 filters.
But, now when I set the two filters and click on view, I get a new error:
Failed to load database information. Error in File C:\Windows\TEMP\1840 {B044146E-A3D4-4EC9-9099-533B932A2487}.rpt: Failed to load database information.
CrystalReportViewer -
Error: Object reference not set to an instance of an object.
I have sent the screen shot to the email address I was provided with. |
|
|
|
anavagomez
29 Posts |
Posted - 08/15/2012 : 08:31:22
|
I am getting a little further but still not able to view the report.
My problem at first, was that I was using a jdbc connection and the server did not have that dll for crystal.
I changed the connection to an OLE DB and I was able to pass that error.
Now, when I click view, I get a screen that reads:
The report you requested requires further information.
Server Name: correctly filled
Database Name: Empty
User Name: correctly filled
Password: correctly filled
checkbox "Use integrated Security"
button "Log On"
I am not able to type the database name. The field seems to be disabled.
But if I check the checkbox, then the database name gets filled automatically. Weird.
Then I click Log On, but nothing happens. It just stays on the same page.
I am at a lost right now. Your insight would be of great help.
Thank you.
|
|
|
|
admin
1635 Posts |
Posted - 08/15/2012 : 10:06:11
|
The error (The report you requested requires further information.) indicates that information form RP connection (RGMFG) could not be passed to the report. Please open your Crystal report and make sure its connection has “Use Integrated Security” unchecked.
Please go to Admin > Connections > and select RGMFG. Which the Type and Database Type are used? Does the connection has user name and password set? Please click Test to make sure the connection information is valid.
Please see this example: http://www.reportportal.com/help/crystal/example.htm |
|
|
|
anavagomez
29 Posts |
Posted - 08/15/2012 : 10:48:41
|
RGMFG is a SQL OLEDB type connection
SQL Server 2000 is the db type
user name and password are set, click on test and got Success!
and on the CR report, user integrated security is unchecked. |
|
|
|
admin
1635 Posts |
|
|
anavagomez
29 Posts |
Posted - 08/15/2012 : 12:59:14
|
I uploaded a new report and now I get a:
Load report failed.
Please give anonymous user or everyone read/write access to: C:\Windows\TEMP
I logged on to the server and found out that anonymous and iis_iusr, as well as everyone already have read, write, and modify permissions.
What could be causing this issue? |
|
|
|
admin
1635 Posts |
Posted - 08/15/2012 : 21:24:43
|
| The “Load report failed” error might be caused by a number of factors. In most cases it is cased by file access issue. However, in your case it might be caused something else. Please click “Clear Cache” button and try again. |
|
|
|
anavagomez
29 Posts |
Posted - 08/16/2012 : 12:01:53
|
Not sure what happened.
I was able to make the reports work and started uploading them one by one. Everything worked fine.
On the last report I uploaded, nothing special about the report, but something got messed up. I got message:
Load report failed.
Please give anonymous user or everyone read/write access to: C:\Windows\TEMP
And when going back to view the reports that were working, I got an error:
InitCrystal(): Load report failed., File: C:\Windows\TEMP\ReportPortal\1858.rpt
What could have caused this? I just uploaded the report and things went all bad.
|
|
|
|
anavagomez
29 Posts |
Posted - 08/16/2012 : 12:50:07
|
Is it possible to change the defulat upload directory of the crystal reports?
so it does not go to the TEMP directory.
Thanks. |
|
|
|
anavagomez
29 Posts |
Posted - 08/17/2012 : 10:41:19
|
Reports are working again now. Something buggy with using the TEMP directory I guess.
Question, when using a list field/filter that is using a SQL query, how can a default value of (perhaps) "Select User" can be assigned?
I tried to do it on the Default Value field, but it does not work.
Thank you much. |
|
|
|
admin
1635 Posts |
Posted - 08/17/2012 : 18:51:14
|
| Please contact support@ReportPortal.com. We will give you the hot fix that will give you the ability to change the temp folder and the ability to set the Default Value. |
|
|
|
anavagomez
29 Posts |
Posted - 08/23/2012 : 13:50:36
|
WE installed the hot fix, changed the default temp folder to
D:\ReportPortal\reports
After uploading about 10 reports, now I can not view, them nor upload them.
I get:
InitCrystal(): Thread was being aborted., File: D:\ReportPortal\reports\1867.rpt
I go to the directory, and I can see the file there. Not sure what is going on.
|
|
|
|
anavagomez
29 Posts |
Posted - 08/23/2012 : 13:52:44
|
I forgot to mention that this only happens with the crystal reports functionality.
SQL Reports, Cube reports, charts, all that works fine.
Thank you. |
|
|
|
admin
1635 Posts |
|
| |
Topic |
|
Report Portal
How to enable Crystal Reports
