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 gkittelson 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. DilbertAsok

    Noob question - what do the colour flags in Database Expert signify?

    As per the picture - what do the yellow, red, blue, yellow/red, etc colours mean within the different tables mean? Presumably something to do with the linking options?
  2. DilbertAsok

    "{?Pm" in Select Expert

    That makes sense, thanks. I have since noticed that I can set the link between the subreport and the main report when I first go Insert>SubReport, but can I amend this link at a later stage? As it is my subreport was very simple so I just deleted it & made another, but this would be good to...
  3. DilbertAsok

    "{?Pm" in Select Expert

    Hi, I'm making changes to a Crytal Report that was written by someone else, and within the Select Expert section there is the following formula: {TABLE1.CODE} = {?Pm-TABLE2.CODE} What does the ?Pm mean or do? Thanks,
  4. DilbertAsok

    Format a number within a text string

    Perfect - thanks! I was sure it was something around totext or tonumber but couldn't fix the conditions at the end!
  5. DilbertAsok

    Format a number within a text string

    Using the formula: IF {XXX.XXX} = "2 NYS" THEN "Not yet started: "&DistinctCount ({XXX}, {XXX.XXX}) ELSE [formula then continues with other IF statements] The output of the above line looks like: "Not yet started: 7.00", but as the output will always be an integer the decimal places are...

Part and Inventory Search

Back
Top