Dynamically fill Combobox in HTML forms from dataset values

[deleted_user]

Hi,
i've build a Stored Process based on the "Sample: Multiple Output Formats" stored process. I want to extend this by adding filter capabilities using html selectboxes.

Depending on the selected dataset, i want to fill the corresponding filter selectboxes.

For example, after selecting a dataset, i want to fill the filter selextbox with the names of all fields of this dataset.

Any ideas how to do this
- with bare jsp scripts?
- with ajax techniques?

Thanks

[Cynthia_sas]

Hi:
You may wish to work with SAS Tech Support on this task. There are several different ways to do what you want to do and Tech Support has the people with the expertise to point you in the right direction, depending on whether you want SAS to generate the second form or whether you want to use Web Services or servlets or .... .

Reviewing the web application at this documentation site:
http://support.sas.com/rnd/itech/doc9/dev_guide/stprocess/sesssamp.html may give you some ideas of what a SAS solution to build the forms would look like.

cynthia

[deleted_user]

Hi Ralph,

of course if you don't want to create a complex GUI , ajax and stored process via SAS Stored Process Web application is a good (and easy to implement) way ...

BR,

Greg

[deleted_user]

I have a question along the same lines...

I'm interested in writing a simple custom GUI to running stored procs that pull the parameters dynamically from another data source (using ASP.NET). I already have a proof of concept, which actually works just fine. However, there is one major step that I cannot determine how to skirt.

The ASP.NET/HTML interface I have is actually inserted into our information delivery portal as a link. Therefore, whenever someone clicks the link, it opens up the interface right within the IDP. The user can choose options and click submit to see their report. The problem comes about right there. The user is then asked to authenticate again. That leads me to believe that whenever a user runs a stored proc from the IDP via SAS's interface, there is some way that SAS takes care of that authentication in the background.

Here comes the question:
What can I do with my little ASP.NET page to take care of that authentication? The user had already been authenticated through the IDP and I'd rather them not be asked to authenticate again.

Any suggestions, solutions, documentation?

Thanks in advance!