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

  • Users: vieja
  • Order by date
  1. vieja

    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...
  2. vieja

    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 =...
  3. vieja

    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...
  4. vieja

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

Part and Inventory Search

Back
Top