title: Crystal Reports - Dynamic Cascading Parameter based on another parameter
body: <p>I'm using Crystal Reports 2008 and have a cascading parameter that pulls data from a table that has ~35,000 rows.  It creates entries off of 5-6 different columns which can total about 12,000 rows.  The values that are returned are not static and change due to re-orgs and such that happen once a month or so (such as some name changes and so forth).</p>
  
  <pre><code>Effective Date, Area, region, state, city, store, employee
  </code></pre>
  
  <p>Is there a way to pull the corresponding set of 12,000 records based on the period without turning the "table" into a 100,000+ behemoth that would take several minutes to pick parameters?</p>
  
  <p>I would like to have it pick the period the data is for (Effective Date), then pass that value to the stored proc that drives the dynamic cascading parameter.</p>
  
  <p>EDIT:</p>
  
  <p>Here is a sample of what my data looks like</p>
  
  <pre><code>EffectiveDt   Area       Region   State   City     Store        StoreID
  5-1-13        Northwest  NW-1     OR      Bend     KMart#1153   1153-42
  5-12-13       Northwest  NW-1     OR      Bend     KMart#1124   1124-31
  5-11-13       Northwest  NW-2     CA      Faar     Burgerss     8245
  6-5-13        Northwest  NW-1     OR      Bend     KMart        1153-42
  6-12-13       Southwest  SW-4     AZ      Hawt     Bally        9352
  6-17-13       Midwest    MW-3     OK      Windy    Nails        3524-1
  </code></pre>
  
  <p>So I do not want to have to try to add Effective Date in the complete set.  The Effective date sort of drives what is picked and I want to pass that in without including the effective date in the cascading parameter set.  </p>
  
  <p>The parameter list the user has to pick from would look like:
      Northwest
      Southwest
      Midwest</p>
  
  <p>Then drive to each lower level from that.  </p>
  
  <p>I'm confused on how to base this cascading parameter list without adding another column with the effective date. </p>
  
  <p>Thanks</p>