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 Westi 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. Pegasys2K

    I can't locate my "portrait" table in CR 8.5 to insert pictures

    I probably don't have the security settings to see the table. Atleast thats what my coworker thinks as well. I hope that there is a way to right a formula in order to insert these employees portraits beside their name. In the book it shows the table name as portrait and the following under...
  2. Pegasys2K

    I can't locate my "portrait" table in CR 8.5 to insert pictures

    Thanks for the reply! However, it looks like I have to look further into the SQL and ODBC in order to figure this one out because it's not part of the CR 8.5 tables that I have already. The sad part is, I know nothing about SQL or ODBC. I guess the tech who set up all the other tables didn't...
  3. Pegasys2K

    I can't locate my "portrait" table in CR 8.5 to insert pictures

    Hi lbass, It's me again and I am confused as to why one of my tables in CR 8.5 isn't listed, it's called: portrait. I found the SQL script file where it is listed as Cr_portrait along with all the other script files which are listed in CR for me to select from when I make my other reports. I...
  4. Pegasys2K

    How to filter a table using an if,then,else statement

    Hi lb! Who's da Man? Da Bass Man!!! > {lb} I finally inserted the group the way it was supposed to be then I used the that formula of yours and it was magic to me. I can't thank you enough. I think my headache is finally subsiding. Lastly, yes my main goal was to produce a report of all of...
  5. Pegasys2K

    How to filter a table using an if,then,else statement

    Allow me to clarify this statement: The badge number and badge proximity number can both be the same numbers or different numbers in one cardholder's profile but no two cardholders can have the same badge # nor have the same proximity number as another cardholder therefore each badge # and prox...
  6. Pegasys2K

    How to filter a table using an if,then,else statement

    IM sorry for the confusion,I've only took a 2 day course on crystal reports 8.5 and I've had about a year of reading help files when time was available. So IM definetly a newby. IM using Crystal Reports 8.5 and the database is ODBC/SQL Example Data and Expected ouput is the following for...
  7. Pegasys2K

    How to filter a table using an if,then,else statement

    IM sure your formula would of worked have I given more of a landscape view of my tables. There are 3 tables in which I can get data from, i.e. company,cardholder,and badge. I add company name into my report from that table, I add {cardholder_lname} + "," + {cardholder_fname} from Cardholder...
  8. Pegasys2K

    How to filter a table using an if,then,else statement

    I forgot tell you, IM using Crystal Reports 8.5 Thanks!
  9. Pegasys2K

    How to filter a table using an if,then,else statement

    I have a table called Disabled which holds two numbers: 0 and 1 0 = Active 1= Disabled I can find all my active profiles because the rule is that every profile can only have one Active instance but have multiple Disabled instances within it. So, I have two types: one has just disabled...

Part and Inventory Search

Back
Top