Recent content by acarruth

Andrew, It is the process of having the second CMS connect to the system database of the first CMS that initiates the clustering. This is well documented in the deployment guides. Refer to page 117 of the "Business Objects Deployment and Configuration Guide" (xir2_bip_deploy_en.pdf). To add...

Got it. Turns out the DBA removed CREATE/ALTER TABLE priveleges from the account used to connect to the database. When a new CMS joins the cluster, it needs to add another column to CMS_IdNumbers5. Temporarily giving the account the dbo role allowed the clustering to happen. By the way...

No, XI R2 SP2 was already installed when I got here, but with the services down. It mirrors the first server, though. I imagine the end result would be the same as it would use the ODBC DSN of the same name.. do you think it would act differently? I wonder if FP2.4 would help, hmm..

Hi, We have one XI R2 SP2 server up and running, and it is leveraging a database on a separate SQL Server 2005 SP1 machine for the CMS DB. We now have a second machine, which is identical to the first in terms of hardware, OS, and XI. I created an ODBC DSN on server 2, which matches what is...

Hi, I’m writing a small java program that incites all the cache servers in a BOE deployment to cache the first page of a particular report instance (for performance reasons). I’ve tried this programmatically, but have had no success. I know that generally a cache server is chosen at view time...

hmm.. that looks promising :) if you call system.io.file.exists, though, where does it start its search? does it start in the dll's current working folder first? wouldn't want to pick up the wrong config/ini file.. thanks for your help!

hi, its a runtime value in a file for later use.. the DLL is a custom function for crystal reports, and needs to locate some text files on the hard drive. the location of these files might change, so instead of having the client recompile if the location changes, i was hoping to store the value...

Hi there, Seems like such a simple problem - just trying to get a dynamic value from app.config file or even a simple text file so client doesn't have to recompile.. but either need to be able to access app.config file, or somehow find out current working path so i can open a text file in the...

Oh, my apologies.. I neglected to mention that this is with XI R2. It works with CE10, XI R1, etc. The only way I can get a handle on a report in XI R2 is by going: InfoObjects ceInfoObjects = ceInfoStore.Query("Select * From CI_INFOOBJECTS Where SI_PROGID = 'CrystalEnterprise.Report' And...

Hi there, For the life of me, I can't seem to cast an InfoObject to a CrystalEnterprise.Enterprise.Desktop.Report in .NET. Even with the sample code, it says the cast is not valid.. I've seen other references to this on the net, but no solution. Has anyone seen or solved this issue? Thanks...

Hi Christine, That was a long time ago, but I believe I ended up doing the conversion manually using javascript. Unfortunately, I left that company so I don't have access to the code! Regards, Allan

I ended up writing a small vb script to go through all the reports and and change the table location to be the stored procedure with the ';1', and then alias it to the old table name.. worked out well. Thanks for all your help!

Hi, thanks for the response. I have been able to get it working by using Set Datasource Location, but there are 300+ reports. I could repoint those tables programatically, but even that is hassle.. I have a feeling it has to do with the SQL Client driver on the 7.0 machine..

Hi, In SI 7.0, one can access a stored procedure on a MS SQL Server via in the Crystal Report Expert.. lets say we're trying to access a stored procedure named "test". When this SI 7.0 report is opened in CR 10, the report will not run because it is looking for a stored procedure named "test"...

Hi there, I have a bit of css/js that positions a button at the foot of the page. it works fine when i first load the page, but when i submit the form on the page (the page submits to itself), the positioning does not take effect on the resulting page. However, when i press 'refresh' (it asks...