Skip to Content
author's profile photo
Former Member

Problems displaying parameters selected at runtime in report

Post Author: foghat

CA Forum: General

Hi all,I am having issues getting the parameters selected at runtime to display correctly in my report. I am trying to display them in the report header. I am using Crystal XI and am using a cascading dynamic prompt created in our repository. I have a cascading prompt called country_region where first the country is picked, and after

the country selection is made, a list of regions for that country is displayed. The user can pick multiple regions. I try adding the country_region prompt value(s) to the report by placing the country_region parameter field into the report header. I have 2 issues with the display1. The country selected does not display at all, only the region selected.2. If more than one region is selected, only the first region displays. I've tried playing with the field properties, but have had no luck.Is there any way to get all the regions selected to display and is there a was to also display the country? I have also tried creating just a region parameter and get the same results as in point 2 above when selecting multiple values.Anyone have any thoughts?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 04:17 PM

    Post Author: SKodidine

    CA Forum: General

    1. Open your report and edit your parameter from within the report.

    2. In the edit window of the parameter, you should see a heading that says 'click to create parameter' Click next to country and it will create a parameter.

    3. Close the parameter edit window and create a formula with:

    {?country-region-country_id} & chrw(13) &

    join({?country-region-region_id},', ');

    4. Place the formula where you need it and right click on it and under format, check the box next to 'Can Grow'.

    One thing to note though is depending on how you set up the parameters, you might get the IDs rather than the descriptions for Country and Region.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 05:44 PM

    Post Author: foghat

    CA Forum: General

    thanks. At step 3, when I try save the forumula the following error is raised; -


    Crystal Reports--


    This array must be subscripted. For example: Array [i].--


    OK -


    Any thoughts?

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 01:20 AM

    Post Author: SKodidine

    CA Forum: General

    Try the solution suggested in this post:

    http://technicalsupport.businessobjects.com/cs/forums/thread/3278.aspx

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 22, 2007 at 02:26 PM

    Post Author: foghat

    CA Forum: General

    Thanks for the link, the very last suggestion in that thread worked great, and so simple compared to the other suggestions: Just create a formula with this, that is that:"Parameters Chosen Are: " & Join({?My Parameter},",") Similar to the first suggestion above. I am using Crystal XI and it just didn't like something about the above syntax.

    Add comment
    10|10000 characters needed characters exceeded