Search results for query: *

I'm using the date:seconds function (from the EXSLT date and time functions) to obtain the number of seconds in a duration string, but I'm getting incorrect results. For example, for the following xslt code, I would expect the result to be 85904. Instead, I'm getting a result 1000 times...

Hello. I have created a Crystal report that uses an Oracle function as its datasource. Here is the function call that is contained in a Command object in the Crystal report file: select t.* from TABLE(rvx_gtb_voucher('{?ParamType}',{?ResID},'{?EmbarkDateFrom}','{?EmbarkDateTo}','{?Ship}'))...

I created a Crystal report (version 11) which has an Oracle stored procedure as its datasource. The stored procedure contains 2 static date parameters. The Crystal report runs fine when run in the Crystal Report software. But when I run it in Crystal Viewer, I am prompted twice to enter the...

I have a Crystal report that has an Oracle stored procedure as its datasource. I've adjusted the stored procedure parameters in the Crystal Report file to contain dynamic values (from either a database view or a Command object query). The report runs correctly when run from the Crystal Report...

Hello. I've created a CRv11 report against data in an Oracle view. The report contains a dynamic parameter which uses a select query in a Crystal Command Object to provide a list of parameter values. Then I published the report to the Crystal Server. We want the report query to be run by...

I want to display a value from a dataset within my report header. I placed the value in a hidden textbox named "FacilityName" which contains this expression: =First(Fields!FacilityName.Value, "dsFacility") In the report header, the expression is: =ReportItems!FacilityName.Value The problem...

I'm trying to implement a callback in Asp.net 1.1. When I do a simple test it works correctly, so I know I have all the pieces in place. The problem I'm having is in the RaiseCallBackEvent method in the server code. Since there is no postback, how do I access textbox values changed on the UI...

Is there a way to programmatically open a select list in javascript? I have a javascript function that populates a select list with new options when the selectlist is first clicked. But then it closes the list, so the user has to click again to open the list to select an item. To avoid the...

Hi. I'm having trouble loading a SqlServer DTS package from ASP.net. Here is the C# code: DTS.Package2Class oDTS = new DTS.Package2Class(); object pVarPersistStgOfHost = null; oDTS.LoadFromSQLServer("MYSERVER", "username"...

Hi. I'm having trouble loading a DTS package from ASP.net. Here is the C# code: DTS.Package2Class oDTS = new DTS.Package2Class(); object pVarPersistStgOfHost = null; oDTS.LoadFromSQLServer("MYSERVER", "username", "password",DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,null,null,null...

Hi. I have an OnUpdate method that is triggered from a datagrid. The problem is that when the event is triggered, the code in the OnUpdate method runs twice in succession. I traced it through, and after it finished the last line of code, it immediately starts again on the 1st line. I made...

Is there a way to trigger a Crystal Enterprise custom event from ASP or ASP.net? If so, is there any sample code available (VBScript or C#)? Thank you.

I'm just starting to try using the ASP.net Mobile controls, and I've been able to bind an ObjectList control to a dataset to render a table containing rows of data with 3 columns of information. When I view it from a browser on my desktop, it looks fine. But when trying to view the data from a...

I'm using Crystal ver 9.2, and am able to generate a report in the crystal viewer in ASP.net. But there's an error when I select either Print or Export from the viewer toolbar. This is because the viewer appends a string to the original querystring, so the new url produced looks like this...

I have a Crystal Ver 8 main report (crosstab) that contains an on-demand subreport (not a crosstab). (Both use stored procedures.) The main report has 2 date parameters (start & end dates). The subreport is linked to the main report through these 2 date parameters. In addition, the subreport...

I'm trying to use Response.ContentType to display an ASP page as a Word document. In the page, I'm trying to display data from an ADO recordset. The page DOES load as a Word document, but no values from the recordset show on the page. (I know that the recordset does contain data, because if...

In the record selection formula, I need a way to filter out records that have specific text entered in a particular database field. But the database field I'm looking at is a memo field, which can't be used in Crystal formulas. Does anyone know of a way around this? Thanks. -Evelyn

I have Crystal reports (V8) running in the Crystal viewer (crviewer.dll version 8.0.0.371) of an ASP application. It was working fine on Windows 2000 PCs. But now one of the PCs just got upgraded to WindowsXP, and now we get an error when trying to run the reports on it: "Error: ActiveX...

I have an ASP application displaying Crystal reports in the viewer with reports that were created in Crystal V8. On a PC running Office XP, I am unable to display the report. I get a blank view window and an error: "ActiveX component can't create object: 'WebReportBroker.WebReportBroker'...

I have a Crystal v8 report which contains 3 subreports, each in a separate report footer section of the main report. I'm passing in 2 parameters which are used by the selection formulas in each of the reports. I notice when the main report has no records to display in its detail section, then...