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!

Register Log in
  • Congratulations strongm 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 mmm76

  1. mmm76

    Running total final result displayed in page header

    Hi, I have created a report that is tracking number of calls recieved based on a customer id and the type of call. I have a running total that is working to show the amount of calls. I wanted to be able to bring the last value in the running total to my page header so when the user opened the...
  2. mmm76

    Crystal Reports Error

    Hi, I am running a pretty complicated report in Crystal reports. When I run the report I get an error message that says Database Connection Error: '57011:[IBM][CLI Driver][DB2/6000] SQL0968C. The file system is full. SQLSTATE=57011 [Database Vendor Code -968]'. I googled this and I did find...
  3. mmm76

    NthLargest Formula being used in the select expert

    Hi, Does anyone know of I way I can use an Nthlargest formula in my select expert? I need the largest term date for a benefit based on a class but then I need to narrow down my report to those benefits after a certain term date. Thanks in advance for any help.
  4. mmm76

    Formatting number for Substitute Formula

    Thank you Skip - appreciate it!
  5. mmm76

    Formatting number for Substitute Formula

    I am trying to remove the decimal points from a number in excel. I am using this formula - =Substitute(A1,".",""). It seems to work but if my original number is 17.20 the substitute formula removes the last 0. In order for all my numbers to be formatted correctly I need to have that ending 0...
  6. mmm76

    Sub-Reports being exported

    Sorry I am new to the site and wasn't sure where to post. I will remember for the future.
  7. mmm76

    Multiple types in one field

    Hi, We have 4 different qualifiers in one field in a table. For example SSNs, HSN, MDR, and MED reference numbers all in one table. I am trying to pull a list of people and their corresponding SSNs but I want to include all people even people with out SSN's. The report is pulling only people...
  8. mmm76

    export to excel all on the same row

    LB - have you ever tried exporting a sub report to Access? I did what you recommended in this post and it worked. But my report is too big for excel - any suggestions? Thank!
  9. mmm76

    Exporting Sub-reports

    Hi, I have a report with 10+ sub-reports that I need to get out of Crystal and into MS access. Does anyone know if this is possible and if so how it can be done? Thanks!
  10. mmm76

    Sub-Reports being exported

    I have a report with lots of subreports (10+) and I need to export it in some way that all the subreports come over. Do you know how this can work? I have asked around here and no one seems to know. I didn't know if this is a work around that could help me with this. Any information would be...
See more

Part and Inventory Search

Back
Top