Search results for query: *

I have order and orderdetail tables. one to many relationship. On report, Orders are grouped by first State and city. Tax for each order is defined in tax field in orders table. Suppose customer orders five items. OrderNo. tax Orderdetail 100 $20 Pipes 100...

Hi all, I would like to implement this in crystal report.net using VB.net using code. I have created purchase order report. I would like to create four dropdowns or comboboxes on form. four dropdown contain vendor, PO date, Purchasing agent, and price. I also have a command button on the...

I am creating a purchase order report. Page header has a company logo and text "Purchase Order". I have a one group on Purchase order number. Now for any particular purchase order for example, if it has got lot of items in detail section then it rolls down to next page. In this case page...

I have a purchase order report. I want set minimum no. of records to display in detail section even if the records doesn't exist. For example, Set the limit to display 15 records. Some purchase order might have 15 items. Then it will display all 15 items. if some purchase orders doesn't have...

Hi everyone, I have a table(tblSOP) with three fields. SOPID, SOPName, SOPPhoneNumber, SOPCode I already have a combobox populated from SOPName field. Now when i click and choose value in combobox, the corresponding SOPPhoneNumber should appear in textbox(txtPhone). How to write script for...

Hi everyone, I have a table(tblSOP) with four fields. SOPID, SOPName, SOPPhoneNumber, SOPCode I already have a combobox populated from SOPName field. Now when i click and choose value in combobox, the corresponding SOPPhoneNumber should appear in textbox(txtPhone). How to write script for...

I have a multivalue field in access. The values in this field are: er4fa,iuds45,dfa34 fas2,fdpeee3,ffa2 How can i seperate this values and turned them into fields or columns in Access using VBA code?

Suppose I have a table with fields: First Last STEVEN MAKI JAMES FURNISH MONICA GARCIA I need to keep only first letter of each name in capital, rest not in capital. i.e. Steve Maki James Furnish Monica Garcia Is...

Hello Everyone, I have a table with a list of Business Locations (BL) and for each BL, there may be multiple Account IDs (AI). For each unique BL, there is a row for AIs. It looks something like this: BL AIs 12345 135790, 124680, 567321 54321 975315, 456123...

Hi everyone, Need some help with the formula. dim Terms as number Terms = TONUMBER(RIGHT({vwRPTPurchaseOrder.Terms}, 2)) formula = DateAdd("d", Terms, vwRPTPurchaseOrder.RequestDate}) 'Extracts last two letter or number 'If it it a number then add in to the Request date. If they are letters...

I have a group with two detail sections. Detail section a has all fields in it. Detail section b has dotted line in it. I would like to supress the dotted line after the last record is hit in the group. How can i do that? Thanks in advance.