Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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.

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

Thanks for all your helps. I am very appreciated.

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.

Thanks, amorous for your help!

Hi all, Can anyone let me know what function to drop decimal numbers? For example the number is 200.75 and when I run my stored procedure, it should pull out only 200 (it will not pull out the decimal point and numbers after). Thanks!!!

It works great!!! Thanks a lot, Nathan!

Hi, I need some quick help. As you know that we can pull out data within a time period that we want like: Between @StartDate and @EndDate. Is there a way to search borrowers by the first letter of names like FROM A TO M or from any letter to a letter that we want to search for? Any help will...

Ok, I have 2 frames: 1 frame contains combo box 1 and text box 1 for info in my master table. The other frame that contains combo box 2 and text box 2 for info in my detail table. Also, I have only 1 set of ADD,EDIT, and SAVE of buttons for controls on those 2 frames. When I click on frame 1...