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

Web Elements WESelectCascade V2


We are in the process of creating a few web elements and for the most part it's going well. But there is one issue that we are coming across when creating a WESelectCascade web element. The issue is, when creating values for each drop down, we have to hard code all the values, e.g.,


and for the corresponding values for the above, it's ...


The issue is, we have about 20 subset values for each first level of values and that becomes very tedious and hard to maintaine. Is there anyway of getting the values directly from the database vs. having to hard code the values?

Please help!

Thank you in advance.



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 08, 2007 at 04:50 AM


    all of the controls can be used in conjunction with live data. see the webelementsdcp.rpt that is in the main download. it runs against the xtreme database that ships with crystal reports.

    the flow is like this: you have a subreport in a report header that has all of the fields that you are using in one cascade set. these fields are grouped into the hierarchy that you plan on using for the cascade set. just copy the syntax from the sample report to roll up your data.

    this subreport can be thought of as the query that you would normally run on a jsp / asp page that is used to create the javascript arrays containing the select values.

    the rolled up values are passed to the main report as a shared variable which in turn is used directly in the control.


    Add a comment
    10|10000 characters needed characters exceeded

    • hello Namita,

      i've pasted a kbase article below that will help you out with this.



      KBase Article ID:c2018907

      Article refers to:Crystal Reports XI


      In Crystal Reports XI, when you attempt to save a custom function to the Repository the following error message appears:

      "Repository Root Folder has not been created or is not visible to you. Please contact your Administrator"

      How do you resolve this error message?


      To resolve this error message use the following steps:

      1. Logon to Business View Manger as an Administrator and start the 'Repository Explorer' under the 'View' menu.

      2. Add user 'View' and 'Edit' rights to the Custom Functions folder under Root.



      u2022 'Edit' rights allow the users to delete a custom function from Repository. Users who don't need to save a custom function into the Repository should have only "View" right to the Custom Functions folder.


  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2008 at 04:58 AM

    Hi Jamie!

    I wanted to find out, is there something in web elements that i can use to get a collapsible navigation menu or in Xcelsius?



    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.