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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Thuky

  1. Thuky

    Auto generate "haux" number

    Thanks all for trying to help me look for the right word. I meant hoax number as Gooser figured it out. Thanks, Gooser. I am trying to construct a form of ID that no one can gess what my next ID in the table. The ID can be a few letters mixed with a few numbers. Please help... Thank You.
  2. Thuky

    Auto generate "haux" number

    Hello, Happy Sunday!!! Can anyone please help me how to generate haux number (I'm not sure how to spell haux or haeux)? I don't want to auto generate ID for my table. Thanks a bunch in advance!!!
  3. Thuky

    Auto generate "haux" number

    Hello, Happy Sunday!!! Can anyone please help me how to generate haux number (I'm not sure how to spell haux or haeux)? I don't want to auto generate ID for my table. Thanks a bunch in advance!!!
  4. Thuky

    Run Multiple Reports w/ Names Changes In Report Title

    Hi MisterMo, I already got what I need. Thanks for your help.
  5. Thuky

    Run Multiple Reports w/ Name Changes In Report Title

    Hi lbass, I was working on group headers (as Madawc's hints) and got what I need already. I created 2 group headers for AgentName (1 for report header and 1 for group header). However for clarification, this my sample for reports for 2 agents generated at the same time right after I click...
  6. Thuky

    Run Multiple Reports w/ Name Changes In Report Title

    Hi Madawc, I am new to Crystal report, so I am slow on it and sorry for a late response. I tried your code, but I am not sure what to write my statement as you stated as "Continued...". The syntax check is asking for a boolean to return. I did try True and even false, but didn't help to make...
  7. Thuky

    Run Multiple Reports w/ Names Changes In Report Title

    Hi MisterMo, My tables are stored in SQL server 2000. Table relationship: select loanNo, LoanAmount, AgentFName +' '+ agentLName from Loans left outer join agents on loans.agentID = Agents.AgentID left outer join Mangers on loans.MgrID = managers.mgrID Also, I made a mistake when I showed...
  8. Thuky

    Run Multiple Reports w/ Name Changes In Report Title

    I made a mistake when I showed you what I have so far, I need the page header to show on every page, not the report header to show on every page. I corrected as below: Here is what I have so far: Report Header: Funded loans Page Header (need to show on every page): Loan Numumber, Loan Amount...
  9. Thuky

    Run Multiple Reports w/ Name Changes In Report Title

    Hi, I having working on a report but get so stuck. Need help please. I am working on a crystal report (version 10). The criteria as followed: 1. When a manager runs a report, it should pull out multiple reports on the screen. Let say if the manager has 3 agents, he should see 3 seperate...
  10. Thuky

    Run Multiple Reports w/ Names Changes In Report Title

    Hi, I having working on a report but get so stuck. Need help please. I am working on a crystal report (version 10). The criteria as followed: 1. When a manager runs a report, it should pull out multiple reports on the screen. Let say if the manager has 3 agents, he should see 3 seperate...
  11. Thuky

    Show Label Vertically and Total Amount each Page

    Hi BSman, I forgot to tell you that it worked great. Thanks!!!
  12. Thuky

    Show Label Vertically and Total Amount each Page

    Hi Everyone, Normally, we show label horizontally. Is there a way to make the label rotate counter-clock 90 degree? I check yes for property Vertical, but it turns clockwise instead. One more thing is there a way to sum amount on each page? Thanks for any help.
  13. Thuky

    Split Names

    Hi Glasgow, According to the code below: CODE SELECT LastName= CASE WHEN CHARINDEX(',',FullName)<>0 THEN LEFT(FullName,CHARINDEX(',',FullName)-1) ELSE RIGHT(FullName,CHARINDEX(' ',REVERSE(FullName))) END It works perfect for Lee, Terry. However, the Else case (ELSE...
  14. Thuky

    Function To Drop Decimal numbers

    Thanks for all your helps. I am very appreciated.
  15. Thuky

    Split Names

    Hi Everyone, I need a quick help. I have to split last name from a column that stores the whole name (first name and last name). The following names like: Lee, Terry Mary A. Sanchez Stacey Smith Lynn Mary & Henson I really appreciate for any help.
See more

Part and Inventory Search

Back
Top