Populating Combobox runtime using query

Comments

• AlexTZ

  June 2010 edited 2:41PM

  Hello,
  
  Use data filtering feature:
  http://fast-report.com/documentation/UserM...rhowitworks.htm
  
  Some report examples can be found in Demo.exe under the "Dialogs" category.
• shailu

  June 2010 edited 2:41PM

  That I already checked.
  I think you are not getting my query.
  
  Here is my requirement.
  
  I have database named DB and have table CustomerMaster in that table i have "FirstName" and "lastName" filelds which I want to populated into the combobox place in dialog form.
  e.g
  Shailesh Bartakke
  Vinay Pujari
  
  is it possible?
• AlexTZ

  June 2010 edited 2:41PM

  The easiest way to do this is to create a new calculated column in the CustomerMaster datasource. This column will return the full name. To do this:
  - go to the "Data" window;
  - select the "CustomerMaster" datasource;
  - right-click it and select "New Calculated Column";
  - in the "Properties" window, set up the following properties of a column:
  Name = FullName
  DataType = String
  Expression = [CustomerMaster.FirstName] + " " + [CustomerMaster.LastName]
  
  Now you can use this column in the combobox. Put a combobox on the form and set its DataColumn property to CustomerMaster.FullName.
• shailu

  June 2010 edited 2:41PM

  Hoorrrey!!!!!!!!!!!!!
  
  Gr8
  DONE
• Farhan

  April 2018 edited 2:41PM

  Hi
  Can I've the complete code please and steps
  I've a combo box . showing all the Regions which I like to select but ,It only allow me to select one.
  firstly does the ComboBox allow to select Multiple values If Yes please adivse How ?
  
  If not I can ListBox but can I've the code with the choice if the user can select 'All Regions' or 'Specific'
  

  wrote:

  If RegionRadioButton.Checked = True Then
  i = RegionNameComboBox.SelectedIndex
  RegionID = RegionIDComboBox.Items.Item(i)
  MsgBox(RegionID)
  Report.SetParameterValue("RegionID", RegionID)
  MsgBox("LastCheck",RegionID)
  End IF

  
  Many thanks
• ipong

  April 2018 edited 2:41PM

  create your own select command
  
  https://www.fast-report.com/en/forum/index....c=14113&hl=