Search results for query: *

Using 8.5, I have a compiled report which contains 2 subreports. One s/report is for costs which are displayed on the main report via a shared variable. I have tested the compiled report on a PC here that does not have Crystal installed, using the client's data & all is well. BUT on the...

CRW 8.5 via ODBC to a SQL database. I have 2 subreports successfully returning group totals to my main report (sub-reports necessary due to strnage d/base structure). Both the main reports and sub-reports are grouped by contract and linked by the contract number field. In the sub reports (one...

My report is on contracts. I need to give the user a parameter to select from: All CONTRACTS, COMPLETED CONTRACTS ONLY, EXCLUDE COMPLETED CONTRACTS. The field that controls this is {Ccs_Quotes.Ccs_Quo_Dec_Reason} which has a value 'FIN' for completed and 'WON' for uncompleted. I created the...

My main report contains contract info that I need, but not the full details of costs & sales. As I need parameters on document date ranges, I am using one sub-report to calculate costs and another to calculate sales & am returning totals to the main report via shared variables. Both subreports...

CR v9 of SQL db via ODBC. Report to show costs where a sales invoice has been issued in a given date range - report to show cost summary, but with optional drill-down to cost details. Due to database structure, I can't link the tables showing detailed sales and costs. I have a container...

CR9 (off SQL via ODBC): In my database I have a Start and End date. Can I can get the report to show all the individual dates in that range, even if the 'between' dates are not stored in the database? For example, with a Start date of 1st Jan 2005 and End date of 5th Jan 2005, I want to...

Version 9: Main report holds details of building contracts, subreport calculates value of costs. I am using variables to bring through running totals from the subreport to my main report. I have declared the variable in the main report: Shared NumberVar MatSubVariable; then am using it in GF#1...

v 9 off a SQL database. My report is on sales and costs, grouped by contract number. The main report is on sales, and has two tables: Ccs_Quotes which holds the contract details and Ccs_Sil_Invoice_Line, which holds the invoice details. A parameter limits sales records to <= date and a...

CRW v9. Purpose of report to show sales and costs per job, and to highlight where costs are incurred but no sales invoice issued (and vice versa). Database constraints mean I have to use container report (for sales) and subreport for costs. I have them joined on job number. The report is...

Using Crystal 8.5 with SQLServer via ODBC. - I have a subreport with a date in the detail line and in that report I changed the Report Options to convert Date-Time to Date successfully - and can therefore use Select Expert on a date parameter. I've done exactly the same in the main report (the...

Two linked tables (Contracts and Sales Invoices) Formula 1 says &quot;if invoice date is in ?Current Period Start to ?Current Period End, then show invoice values for that period. Else return 0 Formula 2 says the same but for ?Previous Period start and end. I added the Sales Invoice a second...

My report is to show costs on a building contract. Because of table linking problems, I'm having to use 3 subreports to show the detail lines of my report. I have no total on the subreports, but variables as shown below. The main report is grouped by Contract No (GH#1), then Section1 1(GH#2)...

My Quantum Fireball lct 10.2 has a fried Philips chip. I'm trying to find one on Ebay or similar so I can swap the controller card to retrieve data - does it have to be exatly the same, or would a different size (say 15) do the same job?

Version 9.0 Report gets its data from 3 subreports which are in Detail sections b, c & d of the container report. (Detail a contains text headings which are common to all 3 sub-reports). Container report has 4 groups to sort this data into sections & sub-sections. When printed, if the...

I have a report containing 3 subreports. I need to put a parameter for &quot;transactions dated up to&quot; in the main report, but the transaction dates are held in the subreports. Step by step guide for a numpty, please?

When installing a particular program on just one W2K PC, I get an error message which I am almost certain is caused by an unregistered dll on the PC in question. To save going through manually registering each one, does anyone know of a utility which will give me a list of unregistered dlls?

I need to create a formula in a sub-report using a field from a table in the main report (if it helps, the formula is to ensure credit notes are treated as negative values thus: IF {mainreportfield}= &quot;credit note&quot; then (0-{subreportfield}) else {subreportfield}). If I add the...

I've compiled & distributed a report (with sub-report). Works perfectly on copy of my clients data on my W2K PC, & another W2K which does not have CRW installed. On client's (W98) PC (no CRW installed), all the records from the sub-report are duplicated. Only other issue was that during...