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 dencom 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: marlow1208
  • Content: Threads
  • Order by date
  1. marlow1208

    ToText formula returns "Bad Number Format String" error

    I am using the following formula and get a "Bad Number Format String" error: If month(currentdate) = 1 then ToText((year(currentdate)- 1),"yyyy") else ToText(year(currentdate),"yyyy") If I remove the formatting argument on the second line of code as the following, it works: If...
  2. marlow1208

    Passing Values from Subreport to Main Report

    I am attempting to pass values from subreports to the main report and the resulting values are 0 rather that the correct value. Where is my error? I am using a main report that contains 4 subreports. Each subreport contains a formula that creates a shared variable. The formula in each...
  3. marlow1208

    Connection to an Excel spreadsheet in Database Expert

    I am trying to create a connection to an Excel spreadsheet in the database expert in Crystal Reports 11. When I create the connection, Crystal does not recognize the worksheet in the spreadsheet, but only says "Add a Command" below the connection. What am I doing wrong?
  4. marlow1208

    Select Expert Formula question

    I have members in a table that are assigned a HMP Code, but a member can show up in the table several times with differnt HMP Codes. I would like to extract members who have a record with HMP code "fchfen", but exclude those members who also have a record with an HMP Code of "fepedb". I am...

Part and Inventory Search

Back
Top