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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you saying that you can have 1500 parameters or 1500 possible values for parameter?
Lady Linet
Lady Linet
ASKER
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
mlmcc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER