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

Thanks, LBass. I don't know what I did wrong the 1st time, but I deleted parameter & formula & created them from scratch and all is well. Thank you for your patience and help:)

Thank you for that. Still have a problem. I have now got the following in the formula @completedcontracts: (({?Include Completed Contracts} = 'COMPLETED CONTRACTS ONLY' and {Ccs_Quotes.Ccs_Quo_Dec_Reason} = 'FIN') or ({?Include Completed Contracts} = 'EXCLUDE COMPLETED CONTRACTS' and...

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

Thanks lbass - I've managed to sort that by using 2 subreports but with a different table on SR2, so I got a different field-name for the document date. I have another problem that I am sure you can answer - see my new thread!

Thanks, lbass, Yes, I've already got those fields in GH#1a. I've tried to get round the Null issue with a formula in the sales sub report to say If IsNull (salesvaluefield) then 0 Else (salesvaluefield) but it made no difference.

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

Thanks very much, campsys. That should keep me quiet for a bit!

Not quite the problem - I have two dates in my data: Start Date and End Date for work on a Contract. I want the report to return a record for every date between them - I suppose I am asking Crystal to CREATE a range of sequential dates between any two given start and end dates. I hope this is...

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

Thank you - it works! I've been working on this report for MONTHS (one of our Developers said it couldn't be done, so it's a bit of a challenge for girl well stricken in years) and this was the very last bit to make the whole thing run.

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

Thank you lupins46 and lbass - together you helped me sort this. First, I deleted the sub-report which didn't resolve the problem. Then I tried a left outer join and that didn't either SO - I started building the main report from scratch to see when it went wrong. It was a select expert...

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

More info - if I start a new report with this table only, the conversion ToDate works fine. It must be to do with it being on the third linked table ???????

I've had another thought - don't know if it's relevant? The 'working' date field is from a leading table. The non-working one is from the third in a string of three tables - all equal links.

Definitely a DateTime field. So is the one in the sub-report - I also checked their their properties in SQL Enterprise Manager Design screen and they are identical.