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 SkipVought 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. 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...
  16. MattReed

    Unfair treatment to those with children in IT?

    If you are keeping up your end of the bargain, then my previous response is somewhat flawed. I would think that it would be a foolish notion that anyone could have a child and not have it interfere with their job, at least a little bit. Sometimes I feel that employers are held up to...
  17. MattReed

    Unfair treatment to those with children in IT?

    Management should not be forced to conform to changes in your personal life. I'm sorry that I have to disagree with THE REST OF THE WORLD, but I don't think they should have to. You did not have a child when they hired you. You admint that you are not meeting some of the requirements that...
  18. MattReed

    Exchange 5.5 to Exchange 2003 migration on new server

    I just finished a Ex 2000 to 2003 upgrade, and everything went great. I have heard that the move from 5.5 to 2000 is a sticky one, so I would guess that you should expect some troubles moving from 5.5 to 2003. I would purchase a book to help me through it. One good thing, I have read that if...
  19. MattReed

    Access - when will it run out of steam?

    You must remember too that Access has file size and table size limits, which I believe are both 2 GB. Watch the size of your file. If you start to get close to 2 GB, I would suggest using a more robust DBMS like MySQL or MS SQL Server.
  20. MattReed

    How Do I insert a Sum into this formula?

    Right Click on the formula when it is placed on the report and select &quot;format field&quot;. Check Suppress. This should hide the results of the form, and still allow you to make totals off of it. If you click the &quot;X+2 button with the pencil on it&quot; , you can enter a boolean...

Part and Inventory Search

Back
Top