Link to home
Start Free TrialLog in
Avatar of rjohnson01
rjohnson01

asked on

passing parameters dynamically from a sql stored procedure to a crystal report

there is a limitation of 50 choices in a parameter picklist in viewing a crystal report through a browser. my client has to be able to select from about 1500 choices in a parameter picklist. crystal has no resolution for this problem, so with that in mind i'm trying to use an asp form to pass the parameter to the .rpt file.

i have read through many of the threads, and see the same link to a dead url.

can anyone provide me with some sample code or at least theoretical advice for how to do this. after speaking with crystal, i thought i understood the concept so here goes:
1.) create an asp form
2.) create a results page
3.) pass the results directly to the .rpt file from the url

when i do this the browser opens up a crystal form asking for the parameter. please help!!!

thanks,
roger
rjohnson@eas-i.net
Avatar of rjohnson01
rjohnson01

ASKER

PS- the picklist has to be read from a sql stored procedure external to crystal. i can't hard code values in the crystal .rpt file because of the max 50 choices via the browser.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Are you saying that you can have 1500 parameters or 1500 possible values for parameter?

Lady Linet
there are only a few parameters but one of them has 1500 choices in the picklist, which is why i need to use an asp page to dynamically show the list (via SQL stored procedure). the limitation is 50 choices when using the parameter in crystal via browser to show the number of choices.
As a user if I had to select from 1500 I would be vry frustrated.

mlmcc
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial