Web Elements WESelectCascade V2

[Former Member]

Hello,

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.,

"Value1|Value2|Value3..."

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

"||Value1|value1A|value1B|value1C||Value2|value2A|value2B||Value3|value3A|value3B...""

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.

Sincerely,

Namita

[JWiseman · Accepted solution]

hello,

all of the controls can be used in conjunction with live data. see the webelementsdcp.rpt that is in the main webelements22.zip 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.

jw

[Former Member · Accepted solution]

Thanks a bunch for your help. That worked like a charm! The only issue that I now have is the third level of list of values is way too big. I think I've hit a point where the list is so big and it won't display anything. How do I over come that please?

Thank you in advance!

Sincerely,

Namita

[JWiseman · Accepted solution]

hmm...if you run the report in the crystal reports designer, do you get an error saying that the formula is too big? as these are custom functions they are bound by crystal's 64k per formula output limit.

if you are getting this error, the things you can do are keep every control in a separate formula...i know that some of the samples have several controls in one formula, but if you're running against live data this may become an issue...so break out every control into a separate formula.

if you're not getting an error, what is the behaviour that you are experiencing in infoview? is there an error in the bottom left of your browser?

jw

[Former Member · Accepted solution]

Well, we tried to see what values are being passed with the third set of cascade prompt. When we pulled the object into the report, we got zero results. If we put a value that we know is going to be less than the previous values, it works fine and shows what it's passing. So, the functions itself doesn't give an error, but when running in infoview we get the following error:

An error has occured in the script on this page.

Expected identifier

something with the DHTMLViewer.jsp

because of the set of data it's returning.

[JWiseman · Accepted solution]

paste this link into your browser and go through this list to ensure that everything is set up correctly...

http://diamond.businessobjects.com/node/2846#comment-2873

[Former Member · Accepted solution]

Jamie,

I hadn't installed XI R2 and that's why i was getting errors. It works now, but I'm not getting all the correct values for each option for the first value. So, in the database we have:

Value1

- ValA

- ValB

- ValC

- ValD

Value2

- ValB

- ValC

- ValD

and what I'm getting in the drop down for Value1 is 'ValA' and 'ValD'. And I get ValB, C and D for Value2. Another example would be, if we take a city called Fair Oaks and it belongs California and Virginia. Currently, it's showing Fair Oaks for only California and not Virginia. Is there anything I can do to get Fair Oaks for both VA and CA?

Thank you in advance.

Namita

[JWiseman · Accepted solution]

i'm guessing that you are using version 2 of webelements by the initial subject line and by this behvaviour...

if you're not using 2.2 please upgrade that report to 2.2...in previous versions there was an issue with name conflicts wherein if a name existed in more than one subgroup that only the first subgroup would be recognized causing issues with the values in the next level.

[Former Member · Accepted solution]

Jamie,

I am trying to save my custom fuctions to the repository, but I keep getting an error that says, "You do not have edit right on: "Repository root folder"". Would you happen to know what needs to be done in the CMC side to give me rights to be able to edit and publish custom fuctions to the repo? Thanks in advance!

Sincerely,

Namita

[JWiseman · Accepted solution]

hello Namita,

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

jw

====================

KBase Article ID:c2018907

Article refers to:Crystal Reports XI

Symptom

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?

Resolution

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.

====================

NOTES:

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.

====================

[Former Member]

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?

Thanks,

Namita

[JWiseman]

hello Namita,

there is a WETreeMenu control in the Menus folder of webelements.

if you go to the main download page at

http://diamond.businessobjects.com/node/255

you can grab a copy of the 2.3 suite which has the control.

also, if you go to the crystal reports web pack page you can download a sample light reporting portal which uses this control.

http://diamond.businessobjects.com/node/1839

i hope that this helps out,

jw