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 Chris Miller 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. ppeettee

    CR9 SQL expression using fields from the report

    This is the actual SQl expression field Clients Attend YSessions that are part of an YActivity. the YActivity is in turn part of a team (YACTIVITY."YS_Team_Code") I need the first time they attended for that team (the report itself is grouped by team) (Select Min("Start_Date") from YSESSION...
  2. ppeettee

    CR9 SQL expression using fields from the report

    Thanks for the quick response, I'm using a sybase database and CR9.0 I actually posted a simplified example of the problem I am having and if I remove the table designation within the summary function I get an error "Column 'Start_Date' found in more than one table -- need a correlation name"...
  3. ppeettee

    CR9 SQL expression using fields from the report

    In CR8.5 you could do an SQL expression field that would return a different value for each record. For example a report showing a list of Films (film.id in the report) could have an SQL expression field to show the first date it was booked out. (Select Min(LT."Start_Date") from LENDING_TABLE LT...

Part and Inventory Search

Back
Top