Recent content by JasonL99

I would rather not rely on a salesperson for advice but one of my biggest issues with Business Objects is the lack of reliable information. I have asked the same licensing question to many people (sales reps, managers, technical experts, etc) and never get the same answer. Our system is an...

Licensing is the issue with Crystal Reports Server XI. I was orignally going to use it but once I started talking with the Sales Rep at Business Objects they said I need the BOE CPU license.

We use crystal as the reporting tool for our web based ERP system. The CPU license for Business Objects Enterprise is fairly high, even if you only want the Crystal Reports functionality. It gets even higher if you want additional features such as OLAP tools, Office add-ins, dashboards, etc. I...

My company is looking to upgrade from Crystal Reports 8.5 and we were going to go with Business Objects XI until we found out how expensive it would be. Has anybody used Pentaho for their reporting needs? The price seems much more reasonable, especially for all of the tools it offers. I am just...

Sorry, by add the paramter field to the report I meant that if you are not getting any data on the report you should at least display the parameter on the report (by dragging it from the Field Explorer to the Page Header) so you can see if the parameter is getting populated correctly. The...

Here is an example of how I set parameters from ASP for CR 8.5 Set ParamDefCollection = Session("oRpt").Parameterfields Set session("Param") = ParamDefCollection Set MyParam1 = session("Param").Item(1) MyNewParamValue1 = Request.Form("Whse") Call...

We have a custom ERP system built using PHP and Sql Server. We would like to use Business Objects Enterprise with Crystal Reports for reporting. I am not sure how to tie our system with the enterprise system for our custom security model. Has anyone ever used PHP to do things like adding users...

I am not sure how to check if the data retrieval was successful. Here is some additional information: - using RDC to load and export the report - the pop-up screen gives me the option to select the parameters I set-up in my program (ie Paramater 1 combo box has the value "12345" but it is not...

I am in the process of upgrading our applications from Crystal Reports 8.5 to XI Release 2. One of our applications is a Visual Basic 6 program which runs every hour and exports reports to PDF format. It worked great in 8.5 but when I try it in XI as soon as I call the export function I get a...

We frequently get "erealloc(): Unable to allocate 1441792 bytes" errors in our error log. It seems that every time this happens a user of our application gets a page cannot be found error or their session data gets lost. Any idea of what causes this error or how to fix it? We are currently...

Create Procedure TestProd @Zone nvarchar(20)=NULL as select * from #TABLE1 where ((@Zone IS NULL) OR (Zone = @Zone))

Try WHERE ((@IdField = 0) OR (IdField = @IdField))

What online learning did you use?

I only have experience in version 8.5 but when I open subreports I have to use the report name and report file extension.

A stored procedure always returns a return code which is an int. It can also optionally return 0,1, or many resultsets and output parameters. I am using Crystal 8.5 and as far as I know a report can use the first resultset returned from a stored procedure but cannot use any other resultsets or...