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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Control break in field object contained in a textbox
I have a report which contains a large text box. Within the paragraph in the textbox is a field name. The problem I'm having is the following: When the report prints, it will often cut the field at the end of the line and continue it to the next line. So for example, if the data in the field...- vieja
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Left Outer Joins reporting off SQL Server
Ok - here is the SQL query: SELECT PRAE.EarnCode, PRAE.LimitOvrAmt, PREA.PRCo, PREA.Mth, PREA.EDLType, PREA.EDLCode, PREA.Amount, PREH.LastName, PREH.FirstName, PREC.Description FROM { oj ((Viewpoint.dbo.PRAE PRAE INNER JOIN Viewpoint.dbo.PREH PREH ON PRAE.PRCo =...- vieja
- Post #6
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Left Outer Joins reporting off SQL Server
Obviously I am a real novice. Maybe if I explain what I am trying to do, you can help me. I have 2 tables. Table A has some employees (not all employees) with limits for various earning types. Table B has amounts (and dates) for earnings, deductions, and liabilities for all employees. I...- vieja
- Post #3
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Left Outer Joins reporting off SQL Server
I am new to Crystal Reports. I have two tables which I want all items from Table A and matching items from Table B. I have used a left outer join for this purpose. However, if there are non existent values in Table B, what I end up with is an equal join (only those items in Table A which...- vieja
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 2 Data Access
