title: How to create view to filter out certain results and group it in Oracle Reports?
body: <p>I'm actually working on Oracle reports. One of the situation I have is to create a parameter for the reports which is type of fees. I have a table called type_of_fees and one of the column is called <code>type_of_fees</code></p>
  
  <p>I have several records such as:</p>
  
  <ul>
  <li>monthly rental 1</li>
  <li>monthly rental 2 </li>
  <li>monthly rental 3</li>
  <li>1 month deposit</li>
  <li>2 months deposit</li>
  <li>Aircond charges</li>
  <li>Utility</li>
  <li>1 month advance
  -weekly rental</li>
  </ul>
  
  <p>For the parameter, I would like to have a list of values to choose from which I intend from the dropdown:</p>
  
  <ol>
  <li>Monthly Rental</li>
  <li>Deposits</li>
  <li>Airconditioning</li>
  <li>Utilities</li>
  <li>Others</li>
  </ol>
  
  <p>So I would like when user select monthly rental it will show types of monthly rental I got in the table _onthly rental 1,monthly rental 2, monthly rental 3.</p>
  
  <p>I would also like if other records such as the 1 month advance and weekly rental to be put under Others when selected. Now,if I'm not mistaken, I'm going to have to create a view to make things easier</p>
  
  <p>I would imagine needing columns like SELECTION_TYPE and TYPE_OF_FEES.</p>
  
  <p>how would i insert custom records such for the SELECTION TYPE which will show the appropriate type of fees?</p>
  
  <p>example of view intended:</p>
  
  <pre><code>----------------------------------
  selection_type | type_of_fees    |
  ----------------------------------
  Monthly Rental  | monthly rental 1
  ----------------------------------
  Monthly Rental  | monthly rental 2
  ----------------------------------
  Monthly Rental  | monthly rental 3
  ----------------------------------
  Deposits        | 1 month deposit
  ----------------------------------
  Deposits        | 2 months deposit
  ----------------------------------
  Airconditioning | Aircond charges
  ----------------------------------
  Utilities       | Utility
  ----------------------------------
  Others          | 1 month advance
  ----------------------------------
  Others          | weekly rental
  ----------------------------------
  </code></pre>
  
  <p>How do I create this? especially the part to create data for the <code>selection_type</code> column. I'm not very familiar in creating views.</p>
  
  <p>I have no problem querying out the data I intend to use but I just need to create the view so that I can use the selection_type to query out things easier:</p>
  
  <pre><code>SELECT DISTINCT TYPE_OF_FEES FROM TYPE_OF_FEES
  WHERE TYPE_OF_FEES LIKE '%deposit%'
  </code></pre>
  
  <p>By the way I'm on Oracle. Please if anyone could explain and help.</p>