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 set up that property but it still doesn't seem to be working.

I am using .net version of Crystal Report that comes with visual studio.net. I created 3 formulas for groupheader, groupfooter and details section. Then i dragged this formulas in to their respective sections. Then i ran PO report but it doesn't add those extra lines. Thanks.

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

Thank for the reply. I want to display not the selected value of combobox into textbox but the corresponding SOPPhoneNumber value in textbox.

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

My actual database was in Filemaker Pro6. But i needed to convert it in Access. The data in the above two field(AI & CodeNo) has a multiple value in it. I've shown here only 3 fields. in fact this table has 10 fields in it. But only 3 field has a multiple value in it. The goal is to relate...

Hello Richard, Sorry for late reply. I was on travel. Thanks a lot for your response. Yes it is only one time conversion routine. Sorry AI field value doesn't have space after ",". All field value are defined as text data type and they vary in length. Suppose i am adding another field name...

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

Hi, Sorry!! Instead of replacing your formula with actual field name i.e.({vwRPTEmployeeBenefitPlan.SalaryLevel}), i was replacing it with (GroupName({vwRPTEmployeeBenefitPlan.SalaryLevel}). It works!! Thank you sir, Thanks for helping me!!

I would like to suppress line at the end of each group not at the end of the report. I have 3 groups. I tried your formula somehow didn't work. Thanks.

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.