Recent content by SomeHelp

I support an environment which runs CE10 servers and BOEXI servers. I have users needing auditing information and usage statistics on their reports and users. Unfortunately it appears that CE10 and BOEXI only tracks report usage if the report is going to RPT format. Most of my users reports are...

Thanks for your feedback. I figured support was better for Windows than for Unix. I have seen that with other BI tools I support as well.

My team is planning to upgrade our entire company (20,000+ users) to BOEXI R2 SP4 (premium license) and I am trying to decide best way to go as far as using IIS or WebSphere as app server for our BO clustered environment. Also, we are trying to decide on whether to deploy our environment to...

I have always ran all CE10 and BOEXI services on Windows 2003 Enterprise servers I support under a Windows AD account which is in the Administrators group. Is it possible to run CE10 and BOEXI services under a Windows AD account which is not part of the Administrators group? The company I work...

The issue has been resolved. The problem had to do with the fact that after we applied the DST patches, we did not reboot the server, but only stopped and restarted the CE services. For most hotfixes and service packs those usually do not require a reboot of the server, but only a bounce of the...

I am running CE10 SP5 on Windows 2003 Enterprise Edition server and since the DST updates were applied last week, the export button in the DHTML and Adv. DHTML Viewers has stopped working. All DST patches were applied according to BO's DST page located at...

Here is solution that I am going to use: Basic Syntax - Formula Name: @GetPhNumber dim intIndexA as number dim intIndexB as number dim intKeepLoopA as boolean dim intKeepLoopB as boolean Dim curChar As String Dim lenInput As number Dim stopPos As number Dim intStartPos as number Dim...

I have found that depending on where your Windows AD Domain groups are located in the Windows Domain tree will impact how quickly your Windows AD Authentication is updated in CE 10.0 SP4. I believe it works same way in BOXI R1 and R2 as well. We have a group of over 10,000 users in a particular...

There is no text which always proceeds or follows the phone number. Most of the time there is only a phone number in the text, but there can be other numbers. Sometimes there is no phone number at all within the text. I would say 90% of the time there is a phone number within the text and no...

I am using Crystal Reports 10.0 SP4 on a Windows 2000 desktop. The report has a string field that can have a length of 512 characters. This is a free-form text field and the telephone number can occur anywhere within this field. Since this is free-form text field, the phone numbers can be...

From my experience, you have to manually perform an UPDATE on the Windows AD authentication tab. There is probably a way to create an automated script to do this, but I have not went down that path yet...

This usually happens because the report was stopped prematurly before it completes to success. I have seen this often on big reports that have been running for one or two hours and then the user stops or deletes the job in the CMC. Sometimes these get cleaned up by CE, but many times they do...

You can use Query Builder application, which can be found on the User Launchpad under Client Samples. This query pulls email addresses from the CMS database and will display the email address of Crystal Enterprise users. SELECT SI_EMAIL_ADDRESS FROM CI_SYSTEMOBJECTS WHERE SI_PROGID...

I use the Query Builder application to run 2 queries against the CMS database. The first query pulls all the users si_id based on the group si_id and the second query I use the user si_id's captured from the first query to pull the users full name and description information: First Query...

Check to see what Windows account your CE services are running under LOCAL_SYSTEM or AD\USER_ACCOUNT. If you are running under a LOCAL_SYSTEM account, you should change to an AD\USER_ACCOUNT account that has access to network. On CE server put this account in Admin Group and then Change CE...