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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by MattReed

  1. MattReed

    Data combination - beginner question

    Group by Machine, insert the Scrap field in the header, and put the weight field in the details section. You can then insert a sum in the header of the group. I suspect you could do this by using a Command as a datasource as well, unless these two tables are from different databases. You can...
  2. MattReed

    Crystal 9 - can't export to Excel

    Try installing the service pack again. You probably already did this multiple times, but I figured I'd throw it out anyway. I would try to figure out the .dll that it is complaining about. You could even go to the server that is working and bring a fresh copy of the dll over to the...
  3. MattReed

    How to concatinate several fields into one???

    I am going to make a lot of assumptions because of my ignorance to your situation. Any differences in your situation could totally change this answer. First thing... if you have added the Comments table to your datasource and linked it properly, then you are not getting all of the records from...
  4. MattReed

    How to mark copies as copies.

    There are other ways to do this, but you must really need the functionality and absolutely cannot use an external method of doing this. Let me know if you want me to go into detail... Matt
  5. MattReed

    Combining Groups in CR 8.5

    Could you give me a little more information on your situation? I have an idea, but I need a little more insight to be sure. Matt
  6. MattReed

    Crystal 9 - can't export to Excel

    I would check the Crystal Decisions website for a hotfix to resolve this issue. http://www.crystaldecisions.com hth, Matt
  7. MattReed

    Left Outer Join on 2 tables from different databases

    You could use subreports to get around this as well. Matt
  8. MattReed

    Record Selection Formulas

    synapsevampire is in a bad mood today, so I'm gonna let that one go! Try my formula. If it doesn't work, it is something else. I doubt it is the default value...unless you didn't pick the parameter value you meant to. Matt
  9. MattReed

    Record Selection Formulas

    Try this... If {?VendorNumber}<>&quot;All&quot; AND {?Job}<>&quot;All&quot; Then {APM_MASTER__DISTRIBUTION.Job} Like {?Job} & &quot;*&quot; AND {APM_MASTER__DISTRIBUTION.Vendor}={?VendorNumber} Else if {?VendorNumber}=&quot;All&quot; AND {?Job}=&quot;All&quot; Then True Else if {?VendorNumber}=...
  10. MattReed

    All Kinds of Export Problems

    Sounds like you may need to install a Hot Fix. Check the Crystal Decisions website. http://www.crystaldecisions.com Matt
  11. MattReed

    Mysterious Parameter Fields

    Crystal builds parameters when creating subreports. These allow the parent report to pass the linking field to the subreport. Did you try completely deleting the subreports from your parent report and recreate them?
  12. MattReed

    Export group totals to csv without detail lines.

    If that doesn't work, try using a command as a datasource and do the summations in SQL. Then when you get to Crystal with the data, the summations will be your detail lines.
  13. MattReed

    Text Export Formatting

    This will work...I hope! Make two formulas...one called Header and another called footer for example. Make the Header formula exactly like the header line you want in your export... {Field1} & &quot;,&quot; & {Field2} etc.... Do the same thing for your detail line. Now, Group by the key...
  14. MattReed

    Text Export Formatting

    Do you know what application they are trying to import into? What is the purpose of the import? The only reason I ask is becuase there may be a better way to approach this problem other than a text file import.
  15. MattReed

    Unfair treatment to those with children in IT?

    RosieB, make a good point. The only difference between a broken leg and child-rearing is that the broken leg doesn't ask for quarters for the arcade. If you think about it, your comment about &quot;commercial transaction&quot; actually disproves your own point. If it was just a commercial...

Part and Inventory Search

Back
Top