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 Mike Lewis 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: *

  • Users: mmm76
  • Order by date
  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...

Part and Inventory Search

Back
Top