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

  1. tomparko

    Crystal Reports/CE/CR Server???

    Thanks - this resource is spot on!
  2. tomparko

    Crystal Reports/CE/CR Server???

    Hello, I would like a bit of advice regarding Crystal Reports/CE/CR Server. I have developed a PHP web application that allows users to upload information to a MySQL database. From here I have developed a number of PHP pages that act as reports of the data that has been uploaded. However, I...
  3. tomparko

    Calendar

    Hello, I am developing a website based on: DreamweaverMX/MySQL/PHP I have a section on the website where customers can check our ‘availability’ (i.e when we are free to visit them). However, at the minute it is basically a simple form that allows them to send me a message to the MySQL...
  4. tomparko

    Date Formula

    Thanks for that lbass. It works perfect! Tom
  5. tomparko

    Date Formula

    Using Crystal 9 and Oracle 9i. In a table called MEETING there is a field called DATE (meeting.date) which is populated as follows: 01/01/2004 03/01/2004 05/01/2004 07/01/2004 09/01/2004 11/01/2004 13/01/2004 15/01/2004 And another table called APPOINTMENT links to the MEETING table. This...
  6. tomparko

    Moving Formula

    Thanks for the reply... Unfortunately this didn't work. I input the formula u you suggested and it came back with no errors, as expected. However, when we went back into the select expert formula it had returned to its original state with the line: {GOV_LINK.END_DATE} in {?End Date} to {?To...
  7. tomparko

    Moving Formula

    I am using Crystal 8.5 to run reports from the educational database, EMS. We have a report that uses the formula below in the Select Expert: {GOV_LINK.END_DATE} in {?End Date} to {?To end date} and if {?Select a Governor Type:} = "All" then {GOV_LINK.GOV_TYPE} in ["STF", "SPO", "REP", "PAR"...
  8. tomparko

    crystal syntax for the "where" clause

    Thank you all for the help. Its good to have help on hand!! From the advice by using alias we have found a solution to our problem. Keep an eye out - I will no doubt post other queries in the future. Tom
  9. tomparko

    crystal syntax for the "where" clause

    The tables we are using are as follows: Contact Log Clog_entity_link People_Lookup Contact Log links to Clog_entity_link which in turn links to People_Lookup. We would like to know the crystal syntax for the "where" clause or perhaps somebody knows a better way of structuring the formula. We...

Part and Inventory Search

Back
Top