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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.