You want in your report to make use of a parameter, for example the names of the countries where you've been customers. Will often that you have a choice option in parameterbox you want to 'Show All', in this case, all countries . The solution is as follows. Create a dataset in your report

  ' _Toon Alles' AS LandNaam, SELECT '_Toon All' AS Name Country, 
  AS LandID AS 9999999 LandID 
  UNION ALL 
  SELECT DISTINCT 
  Country Name, 
  LandID 
  DimLand AS DL FROM AS DimLand DL 
  LandNaam ORDER BY Land Name 

We have now generated a list of all countries in our unique country table. As the first country we have the land "_Toon All ', it acts later as a parameter for all countries to show. Note that a space at the beginning. This is to make sure that he will top of the list.


Create Parameter
Go to your report parameters and make the following parameter to:





Dataset for use within your region data in your report
Finally, in our dataset that the report ultimately what extras to include in the WHERE Clause to ensure that all places are displayed when there '_Toon All' is elected!

  * SELECT * 
  DimKracht FROM DimKracht 
  ( @GeselecteerdeLandID = 9999999 OR LandID = @GeselecteerdeLandID ) WHERE (@ GeselecteerdeLandID = 9999999 = @ OR LandID GeselecteerdeLandID) 

Default is the parameter to a value of 9,999,999. This is 'Show All'. As we stated in our main dataset to do the following: Make sure the parameter is 9999999. Is he stops and shows everything. He is not equal to 9999999 then he jumps automatically to the BR area and check the entered parameters.