Default Parameter Value Limitations????

[jaguar00]

Hi all! Using CR10 & SQL Server 2000.

I have a parameter where the user will choose a customer from the default values from the customer name field from the customer table. The problem is that when I go into set the default values it only lists customers A-C instead of all the customers A-Z. Is there a limitation to the amount of records it will pull in?

Any and all answers are greatly appreciated.

 

[IdoMillet]

See:

http://support.businessobjects.com/library/kbase/articles/c2006602.asp

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[vidru]

Or this, if the Registry settings are different between 9 and 10:

http://support.businessobjects.com/library/kbase/articles/c2014948.asp

-dave

 

[jaguar00]

Well...so much for an easy fix. I'm so green with all this stuff I'll have to find a different way to go about it.

What about this...my users actually synchronize data pertaining to their territory from our server and run reports remotely on their own machines. Unfortunately when they sync they get all customers in the customer name field instead of just their own. Could I somehow run the customer parameter based upon their own territory without having them choose their territory first?

Confused yet? Any suggestions???
Thanks!

 

[IdoMillet]

I'm not aware of how you can do this in Crystal.

There's at least one 3rd-party Crystal reports viewer (see list at:

http://www.kenhamady.com/bookmarks.html)

that provides this functionality (cascading/dynamic parameters).

Cheers,
- Ido


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jaguar00]

Thanks so much!

 

[synapsevampire]

You might use a table in the SQL Server database to join to which limits the rows each user can see in the database.

An ugly way to go about it though.

-k