Databases
StackOverflow2013
Postsdbo
POCrystal Reports - Dynamic Cascading Parameter based on another parameter
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCrystal Reports - Dynamic Cascading Parameter based on another parameter
    primarykey
    data
    text
    <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>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1238918
    1. USuser1238918
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCrystal Reports - Dynamic Cascading Parameter based on another parameter
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you expand on `5-6 different columns which can total about 12,000 rows`?
      singulars
      1. POCrystal Reports - Dynamic Cascading Parameter based on another parameter
      1. USbendataclear
    2. COFrom my experience if your cascading parameter datasource also has parameters, you need to prompt for those on your own and then push the data into the report. This is what I had to do using the CrystalReportViewer web control...it might not be required on the Desktop version.
      singulars
      1. POCrystal Reports - Dynamic Cascading Parameter based on another parameter
      1. USdotjoe
    3. COWill the report be published to BusinessObjects Enterprise?
      singulars
      1. POCrystal Reports - Dynamic Cascading Parameter based on another parameter
      1. UScraig
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload