Search results for query: *

In CR, I have users select start date and end date and build query using this date range to populate a reporting table. What I like to do is display this start date and end date in report header. How can I do this? Thanks.

In CR, I have 3 groups. Group by Customer id, Contact id, Order id. Below Group by Order id, I want to display Order#, Item Desc. I would like to display by Item Desc in ascending order. Currently it is displayed by Order#. How can I do this? Thanks.

I got two sub reports Text_PageHeader and FaxCoverLetter in a report. Text_PageHeader is in Page Header section and FaxCoverLetter is in group Footer section. FaxCoverLetter will always be in new page. Currently Text_PageHeader sub-report appears in every page, but I want to suppress this...

How do I correctly calculate age from data of birth in CR? I can do following in Access but CR doesn't recognize the format function. Thanks. DateDiff("yyyy",{my_age.birth_dte} , Now())+Int(format(Now(),"mmdd")<Format({my_age.birth_dte},"mmdd"))

I have problem with string concatenation that I need some help with. In the following SQL, I concatenate the contact first name and last name. I fill it in dataset and bind it to datagrid. The problem is if there's no contact name, it inserts a blank string (i.e. a space that I used in...

In listview control, when I hover mouse between the column headers, it displays black object (square). I tried changing the cursor property, and played with various properties, it didn't help. Any suggestions will be appreciated very much. Thanks.

how can I get Amount summary from sub-report to group header in main report? Thanks.

How can I add items in cb? I used following code in the form load event, but when I click the dropdown list, it shows blank items. However, I can select the blank item. Then it shows the text of the item. Strange, can somebody explain why it's doing this? Thanks...

I have two fields (Supplier_desc & item_desc) inside Text Object. If Supplier is "Cuba" or has any following conditions, how can I suppress just the supplier_desc field and not item desc in the text object? Thanks. The Text object is in detail section. I right clicked the text object, right...

I display list of items in the CR. The item_description field is in the detail section. I would like to display a certain item (i.e. Orange) always on top in the report. How would I able to do this? eg. my item list has: apple, orange, peach, mango, strawberry In the report, I would like it...

I want to display phone no. and fax no. in Page header section for a Customer Contact. Currently I cannot display both at the same time. Here is my table layout. Table name: t_contact_phone Fields: contact_phone_id (identity field) contact_id phone_type_id (1= Permanent, 2= Temp, 3 =...

I want to display phone no. and fax no. in Page header section for a Customer Contact. Currently I cannot display both at the same time. Here is my table layout. Table name: t_contact_phone Fields: contact_phone_id (identity field) contact_id phone_type_id (1= Permanent, 2= Temp, 3 =...

How can I dynamically build Select Case statement from the table? eg. if t_customer table has 4 customers where first_name are: Sam David Mike Jeremy Then I would like to build select case statement for these 4 persons. i.e. Select case f_name case "Sam" case...

I tried to clear cell value in datagrid which is binded to a dataset but it doesn't go away. How do I do this? Thanks. For Each row In ds.Tables(0).Rows If reqId = row("req_id") Then row("unit_cost") = DBNull.Value ds.AcceptChanges() End If Next

I am trying to bind combobox to a datatable (i.e.. dtInvoice). It's not working as I thought. It won't bind and display the correct value. When I check the data table, it has value (i.e. inv_status_id = 1) required for binding. Any suggestions are welcome. Thanks...

How can I do rounding to the nearest tenth? eg. 35 would be 40 34 would be 30 55.62 would be 60 54.50 would be 50 The same would be true for negative numbers. Thanks.

On a datagrid, I have columns request quantity and grant quantity. If user enters grant qty greater than request quantity, I want to display message "Grant Qty cannot be greater than Request Qty" and clear grant qty value and put the focus on that column. I tried setting grant qty to be...

I got about 8 tab pages in the tabcontrol. Each tab page contains information about customer and vendors that user has to select/fill out. I would like to change the color of the tabpage to different color when user has finished editing/changing anything in that tabpage. The idea is to let...

Currently I display a letter in CR. I have to display fax cover letter in the next page. How can I attach fax cover letter in the same CR report? Any suggestion is welcome. Thanks.

I want to display the running Total Amount of the detail section in the Group header or page header. In the detail section, I display item and item price. I want to calculate total of all the item price and display the total in header section. I have grouped the item by Vendor. The Running...