Skip to Content
author's profile photo Former Member
Former Member

Cascading dynamic parameters (Crystal 2008)

I am currently using Crystal Reports 2008, but I am having and issue with cascading dynamic parameters. I have searched the internet high and low but cannot seem to find the answer to resolve my problem.

I main aim is that when a customer account is selected from the first drop down box you can select the site addresses linked to that account number in the second drop down box.

I can create a dynamic parameter based on fields in the same table as in the xtreme database with county, city etc. However, I have two separate tables, Customer and siteaddr. Within these tables they both have a field call acnt_nbr which is a unique number.

The siteaddr table is linked to the customer table on the acnt_nbr field by a left outer join. Each site address in the siteaddr has a unique number field.

I have tried to create the cascading dynamic parameter but because the field names are the same you get the error u201Ceach field can only be used once, but the field is being use multiple times u201Cacnt_nbru201D.

I found a trick to get round this by doing the following when creating a parameter

Adding customer acnt_nbr field to the value field, then clicked to create parameter.

Add site acnt_nbr to the value field then clicked ok but didnu2019t click on the create parameter.

I then renamed the parameter, went to edit and then for the site acnt_nbr field in value clicked to create parameter.

In field explorer you then get two parameters, I then used the select expert to assign the customer acnt_nbr to the first parameter and siteaddr acnt_nbr to the second parameter

The first drop down box works correctly and returns all the customer account numberu2019s. However, the second parameter just returns u2026 and not a list of site addresses linked to the account number.

Any help would be greatly appreicated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2010 at 10:24 PM

    If I understand correctly, this is the scenario:

    Customer Table- field acnt_nbr

    Site AddressTable - field acnt_nbr, siteaddress_nbr

    You can left join the above 2 tables by linking the fields acnt_nbr

    What needs to happen is:

    When create the dynamic parameter,

    - in the Value column, select acnt_nbr from Customer table, in the Parameter column, click it to create parameter.

    - in the Value column, below acnt_nbr, select siteaddress_nbr, in the Parameter column, click it to create parameter.

    After clicking OK, you will find that 2 parameters are created automatically.

    Is that the steps you have taken?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2010 at 08:57 AM

    Does anyone know how I can send a picture showing this error and maybe get a fix/update for Crystal 2008?

    Edited by: Peter.Jackson on Oct 26, 2010 10:57 AM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.