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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cross reference listing of fields/formulas used in CR
Anyone know a way to get a cross reference listing of where a field, definition or formula is used in CR, both in main program and subreports? Either as a separate add-on tool from some software company or something already in CR. A newbie, I almost always use CR Wizardry instead of SQL...- franceshd
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
SQL running on and on and on
I inherited this program (1200+ report pages). Employees can have multiple positions/jobs(PREMPJOB.JOB_NO) with varying hours per day, days worked per year(PREMPJOB.CONTR_DAYS), percent worked(PREMPJOB.PERC_WKED), salary, etc. The end user says that only the 1st job per employee is being listed...- franceshd
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Need most recent check record per employee id- diff tables
I want to use the most recent paycheck per employee. But the table with the date does not contain the EmployeeNumber. PRCKHEAD = Check Header Table (main key = PR_RUN_ID) PRCKHEMP = Employee Check History Table (main key = EMPL_NO) The (non-SQL) GroupSelection is: {PRCKHEAD.CHECK_DATE} =...- franceshd
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 1 Formulas
-
mismatched keys
Created a user's report per specs with Wizard. Now they want to add data from another table. Thought it would be simple, but the new table key is a number in a STRING field while the original linked key is NUMERIC! When I tried to link, it gave "DATA TYPES ARE NOT COMPATIBLE". How can I SWITCH...- franceshd
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 2 Data Access
