1000's of values into a Parameter....

[giggles7840]

I have a request for a report. they want a way to be able to enter in 1000 values (number) into a parameter and not have to do it one at a time. Basically, copy and paste it from their one doc into the parameter. Since crystal params treat values one at a time I was wondering if anyone had any suggestions for an alternative way. The datasource will be coming from a SP.

I was thinking maybe there was a way to have crystal refer to a text file or convert the number field to a text field and then drop it in as one long string......

any help is appreciated.

 

[synapsevampire]

All of this might be possible, depending upon the version of Crystal and the database being used.

Consider that technical informnation is required to make a sound architectural decision.

You may be better served to have the SP read from this text file, or import the text file into the database, or better yet, publicly draw and quarter the person that decided that a text file is a good way to generate data and write the filtering criteria directly to the database.

If you're executing this report from external code then you might create a SQL statement using the text file and query the database, then pass the recordset to Crystal.

-k

 

[BurnsORegan]

There is another way.....

Check out this site for CViewPick and CViewManager

http://www.chelseatech.co.nz

Dynamic Parameter defaults.....

BurnsORegan

 

[giggles7840]

yeah im not buying any new products.....

 

[ReneeC]

You can do this if you want it to be static, but to dynamically update it then you would have to go with a 3rd party vendor or code something yourself with ASP.

For static, save the exported data as a txt file and import it as a picklist into the default of the parameter field. Then your dropdown list box will have the exported data in there.

 

[dgillz]

Can you not make do with a range parameter?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com