Re: Parm forms in Portal and SQR

[Eric Dimick Eastman <erice@ONTKO.COM>]

Nicolas,

I forgot to respond to the second half of your question.  The Portal
documentation refers to "Multi-page Smart Forms" but there isn't much
information about how they work.  I think that you can specify the
SmartCut to a parameter form as the ACTION of  another form and use the
values submitted by the first form in the second, but I don't know the
details.  We might end up going down that road at some point, so if you
get something working I would definitely be interested.

Your problem of showing a list of cities for the selected states is not
well suited to our solution for limiting one selection by another
because you would have to include in your form a list of all the cities
in the US with their associated states.  That could top 5,000 cities and
150 K.  It might work for you but I can't guarantee that performance and
download times would be acceptable.

Hope this helps,
Eric

PS. I cross posted both of my responses to rm-users@sqrug.com which is
probably a more appropriate forum for this type of Portal Specific
discussion.


Nicolas Moscaritolo wrote:

> Has anyone created parameter forms in Portal for SQR? If so, do you have any
> which allow for MULTIPLE PARAMETER selection AND/OR CASCADING PARMS. For
> example, If the parameter is STATE, I would like the user to be able to
> select 2 or more states. For cascading, If the selected state was MA, the
> next parameter would be a list of cities within the state MA.
>
> Any samples would be great.
>
>
>