Dynamic Prompt 1

[racskelly]

I'd like to have a prompt that goes live to the database and gets all the companies in the system that the user can then choose one or more of before running the report...

when i setup a dynamic parameter it only includes the first couple hundred...

Any ideas?

 

[synapsevampire]

It's probably limited by the registry setting, checkout:

http://technicalsupport.businessobj...c2017238&sliceId=&dialogID=19732193&stateId=1

0 19730438

This assumes that you meant to post concerning Crystal Enterprise or BOE, not in the formulas help section for Crystal Reports,unless all of your users are running Crystal reports???

Might even be:

http://technicalsupport.businessobj...c2018152&sliceId=&dialogID=19732211&stateId=1

0 19730475

-k

 

[racskelly]

Awesome synapsevampire... I wouldn't have thought of that!

It was the first one...the registry fix that did it... brilliant.

 

[racskelly]

Hey Synapse...

i had my file working...now all of a sudden my dynamic parameters are back to showing a limited data set...

It should be showing 10 possible values but its only showing 4 or so...any ideas?

 

[synapsevampire]

VooDoo, pure unadulterated VooDoo...

Something must have changed, perhaps connectivity, the database, indexes, joins...

-k

 

[racskelly]

man...you are a CR master!

bad join...good call.

 

[synapsevampire]

<chuckling>

This place is littered with Crystal experts, all of who astound me daily.

-k