Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bmacdo

    Left Outer Join Not Working

    Alas, I get the same incomplete rows. Brad
  2. bmacdo

    Left Outer Join Not Working

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

    Left Outer Join Not Working

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

    Left Outer Join Not Working

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

    Left Outer Join Not Working

    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"...
  6. bmacdo

    Left Outer Join Not Working

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

    Left Outer Join Not Working

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

    Left Outer Join Not Working

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

    Various Exceptions in Single Report

    You are the bomb. Gracias.
  10. bmacdo

    Various Exceptions in Single Report

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

    Various Exceptions in Single Report

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

    Excluding Values in Dynamic Parameter Field

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

    Identifying Particular Report Users

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

    Changing Default Excel Version in Export

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

    Field " not found

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

    Field " not found

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

    Inconsistent Formula Results At Different Locations

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

    Inconsistent Formula Results At Different Locations

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

    Combining Missing Data Reports Into One

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

    Combining Missing Data Reports Into One

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

Part and Inventory Search

Back
Top