Search results for query: *

Using CR 8.5 Developer Edition. I have over 70 reports based on an MS-SQL Server 7.0 database. Sadly, someone has renamed a couple of fields in a table which many of my reports reference, either directly or in formulae. Is there a way in which I can rename the field in my Crystal reports without...

I am using MS-SQL Server 7.0 as the backend of an Accounts and Order Processing application. The SQL Server has a "control" database called "PM" and a database for each "company" or data set called "PM01", "PM02", etc. The "PM" database...

CR 8.5 Developer Edition, reporting on an MS-SQL Server 7.0 database. I have a report which takes 2 or 3 seconds to run using the SQL Server database driver, p2ssql.dll. If I switch the same report to using the ODBC driver, p2sodbc.dll, it takes at around 40 seconds to run when the report is...

Using CR 8.5 Developer Edition on Windows 2000 to query an MS-SQL 7.0 database via ODBC (p2sodbc.dll). In order to obtain the desired results from a report I have had to edit the WHERE clause of the generated SQL SELECT statement. The report works fine, but only for one database. Our data is...

I'm using CR 8.5 Developer Edition on Windows 2000. I have to produce a report which lists transactions from an MS-SQL database where the account number is common and the value is equal and opposite. For example, given the data below... Record A/C Value ------ --- ------ 1 001...

Using CR 8.5 Developer Edition on Windows 2000. I have a report which I wish to allow the user to sort in one of three ways - by account number, this year's turnover, or last year's turnover. I know, and have proved, that this can be done by using a formula to select the appropriate database...

Using Crystal Reports 8.5 Developer Edition on Windows 2000. Main report includes one subreport which consists of a single formula driven field. When previewing the main report, the value calculated by the formula in the subreport shows on the first row of the main report, but no value (ie...

Using CR v8.5.0.217 Developer Edition on Windows 2000. I have a report which contains a two subreports, each called from the Detail section. Each subreport displays a single numeric value using the following formula: if isnull({NLhistory.year_no}) then 0 else select {?CurrentPeriod}...

I have a problem passing data from a subreport to the main report via a shared variable. I am using CR 8.5.0.217 Developer Edition on Windows 2000. Main report has following formulae: Report Header: -------------- {@Year1YTDActualRunningTotalReset} WhilePrintingRecords; Global CurrencyVar...

I want to refresh the title of a browse window every time the user makes a change to particular column on any record. To be more specific, the browse window shows stock items which the user selects for shipping. The user wants to see the total value of the items as they are selected. I figured I...