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...

I've fixed it. The record selection formula included an SQL Expression, thus: {%AbsoluteValue} abs(PLitems.total) In the Record Selection formula: {%AbsoluteValue} = abs({?MyParameter}) Although this resulted in the desired addition to the WHERE clause of the SQL SELECT statement, it appears...

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...

Sorry, I should add the following information... 1. The "PM001" prefix has been set by the System Administrator as part of the ODBC driver configuration as most installations of our application will have at least company number 001. This cannot be changed. 2. I removed the...

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...

Thanks, dgillz. According to the logic in the old report that I'm trying to replicate, there is no field that ties the records together. All that the old report does is attempt to find a record for the same account number but with an equal and opposite value. If it finds (any) one it prints the...

Thanks for all of your responses. I will try to implement your suggestions to see if I get the desired results. To answer your questions... dgillz: Yes, I do want the sum of the value of the printed records to be zero, but the sum of records for any given account number may not be zero. I still...

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...

Thanks for that, but I cannot change or add to the SQL Server configuration. We're going to leave the report sorting locally as we do not expect it to contain a large amount of data. If there is a noticable performance penalty then we'll address it (somehow)... Regards, Shaun

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...

Hmmm... I don't yet know why but checking the "Can Grow" option on the Format Subreport dialog seems to have resolved the problem. Don't know why this should work as the subreport area on the main report is the same size as the field on the subreport ????? Shaun

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...

I've fixed it but I don't know how !? I created the report again from scratch and now it works. Thanks anyway... Shaun

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}...

Shared variables produce the same result, ie, zero (or whatever value I initialize the Year1YTDActualRunningTotal variable with in the {@Year1YTDActualRunningTotalReset} formula). Any more ideas anyone...? Shaun

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...

You could try the FoxFire! Report Writer from Micromega Systems'. I work for a company that develops accounting software in FoxPro 2.6 and we use the above Report Writer. Shaun Donaldson System Corporation plc http://www.syscor.co.uk

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...