Search results for query: *

How do I turn off the 'select distinct' feature for an object in the universe? I have tried changing the value for DISTINCT_VALUES to no value. Didn't work. I have tried removing the parameter altogether from the parameter list (of dynamic sql generation parameters). Even by removing it...

Thanks mdwyer for the post. I came to that desperate conclusion to but was hoping for a more elegant solution. I may have to just bite the bullet and do it this way. Thanks again.

I have the following query to find all CE users in our CE 9 environment: Select top 2500 SI_NAME from CI_SYSTEMOBJECTS where SI_PROGID = 'CrystalEnterprise.USER' order by si_name Currently we have around 2300 users. The query runs fine and returns the result set but the format is awful. I...

We are running Crystal Enterprise 9. Sometimes when people try to login to eportfolio, they get an error that says, "Overflow." I called Crystal and they told me to delete the user account and then add it back it. That works, but it seems to be a hokey workaround. Anyone ever seen this error...

The CMS is using the default MSDE db.

No. I have not stopped/restarted the CMS nor have I rebooted the CE server. I'd have to do that after hours since we have about 1,200 Crystal users...

Turkbear, Yes, I can disable the account. I guess there is more to this story that I should add. The two account that I was trying to delete had the same secLDAP: unit number (s). I had never seen that before. So I talked with our security team and had them run the LDAP master account...

We are running Crystal Enterprise 9.

I have a user account that I need to delete out of Crystal Enterprise. Our corporation uses LDAP authentication. I have deleted out two accounts from LDAP and only one of the accounts disappeared from CE. The other account is still there and fully enabled. I cannot seem to delete the...