Search results for query: *

Alas, I get the same incomplete rows. Brad

Thanks very much! I am trying the above now and will report back. Brad

That is correct. "NYC123" is for testing purposes, an arbitrary single site. When I overcome my left outer join issue, I want to substitute it with a formula that will prompt for single machines. Someone else will run the report for those individual machines one by one. I planned to create...

For what it's worth, I tried running the same Select in MS-SQL Management Studio and got the exact same incomplete result set as I do in Crystal. Brad

Pete, Sorry again for the delay. I was out on med. PTO last week. I am not allowed to use the literal table and field names or values in a public forum, but the current selection formula using aliases is as follows: isnull({Installed.Machine_Name}) or {Installed.Machine_Name} = "NYC123"...

Sorry for the delay of my reply. Yes, I made sure the Machine Type was secondary to the NULL test and also taking out entirely, but the selection criteria did not pull all the records from the Possible parts list as it should. Thanks for your assistance, Brad

Thank you, Pete. I can see this is the right direction for me to go in as it looks better with the machine type selection removed (but for getting extraneous machine types), but when I put machine type back in, it goes hinky again. Brad

Using Crystal 11 & hoping I am in the right forum and this is coherent...(it's been awhile) I am trying to create a comparison using a left outer join, which is not working. What I have forgotten is whether or not I can use any selection criteria on the outer joined table at all, even if I...

You are the bomb. Gracias.

The report is to assist service providers assuring their services are billed and credited. And, no, the missing data would ideally be printed all on the same row for client, not in batches by the missing field. WRT "a formula that checks for sets of missing data, e.g., so that anyone missing...

Using Crystal 11 off MS-SQL Server… I am tasked with modifying an existing report that lists in a visit-based date range exceptions in a billing process, e.g. checks for missing approvals, etc. I am to note additionally other missing data, e.g. no personal residence or no primary diagnosis...

using Crystal 11 w/MS-SQL Server... I want to enable clients to choose a parameter department dynamically. The table w/departments contains expired department values, however. Without resorting to a static list, is there any way to exclude from the presented parameter value list those...

Reporting with Crystal v.10, off MS-SQL Server data... Is there a way in Crystal to determine which users are running reports in a networked folder? We want to cull reports that aren't being used. Brad Macdonald

Reporting with Crystal v.10, off MS-SQL Server data... Does anyone know of a way to update the default version for Excel among the Crystal Export options? It's still showing MS Excel 97-2000 although we have upgraded to MS Office Excel 2007. Thanks, Brad Macdonald

Thanks! Oddly, the error cleared w/o my fixing it, but I hadn't used RDF before and believe it will be useful in the future. Brad

Reporting with Crystal v.10, off MS-SQL Server data... Our SA was asked to delete some fields from a particular table. I deleted the fields from the Crystal Report that had been using them. Following that, the report is displaying a non-fatal error: 'Field " not found.' I can find no stray...

Turns out we were entering a different date range and one of us was entering a range that caused the report to malfunction. Sorry for getting the problem wrong.

Reporting with Crystal v.10, off MS-SQL Server data... This afternoon my boss showed me a report I've heavily modified. An error was evident, where in groups of "facility type" with only one facility, the daily average column in the "facility type" GF row did not agree with the daily average...

After looking at the thing backwards and forwards, I scrapped it and redid. And now the subreports to execute in the manner I intended. I am pretty sure it was a linkage problem, as the group dynamic originally was as lbass recommended and I did not change them when I rewrote it. Thank you...

I have a school parameter in the container report w/subreport links on school. Sorry I neglected to mention that. I am still getting the running-through of the schools in each missing-data type category (intake, education etc) rather than all the missing data types running through an...