Search results for query: *

Can Cognos 6.5 open an OLAP cube from SQL Server 2005?

I have a database with customers and some with more than one address. I'm trying to capture the customers with more than one address and return the resultset. I tried to do count(ADRSCODE) and distinct but never really got the result I wanted. Appreciate any help from the group, the following...

I'm moving all our SQL Servers and is now half-way. While we were doing I tried to check the versions and found that the old & new had different SP2 installed. The old server was in 9.0.3054 while the new servers were in 9.0.3042. I know these are different versions of SP2, can I just install...

When somebody tries to open a spreadsheet we get this message: FileXXX.xls is locked for editing by ''. We don't see who's using it.

I need a script so it'll give me the owners of certain folders/subfolders.

Anybody know of a GP vendor or customer who have a product or have done customizations for Recurring Billing or Deferrals with Multicurrency.

when I boot my pc it would show the windows logo then would go to the Advance Options Menu where i chose safe mode or last known good configuration but nothing works. what do i need to do?

After upgrading from 2K to 2005, I have both the SSMS and Enterprise Mgr. Does this mean my upgrade didn't work or this is normal?

I've installed 2-months ago SQL Server 2005 STD on a physical server and Visual Studio version is 8.0.50727.762(SP.050727-7600). I then used the same installation files today in a VM server and got a different version 8.0.50727.42(RTM.050727-4200)

I just installed SSIS and created a new project in BIDS. While creating a new OLE DB connection manager I got this error: Creating an instance of the COM component with CLSID{C8B522D0-.....} from the IClassFactory failed due to the following error:8007007b

We have an application where you can print reports in pdf format and it's working for everybody except one. When he exports the file instead of a pdf he gets a ps file. He double-clicks the file and creates the pdf with a log file. This is too cumbersome for him since he export as much as 60...

How do you do this in Sharepoint Document Library? We have a File Server where we store our Invoices and Statements for customers. We manually link the docs to the customers but this is very inefficient and its in beta, we want to go production for 2000+ customers.

I'm getting this error when I try to run //localhost/Reports for the first time. Here's more info to the error: Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your...

I've read that you can't run STSADM remotely. how can i run it from rdp so the server thinks I'm local.

Here's the formula: CASE {RM20101.RMDTYPAL} when 3 then {RM20101.TRXDSCRN} when 7 then {RM20101.TRXDSCRN} when 9 then {RM20101.TRXDSCRN} else isnull(subsctring({CN00300.TXTFIELD},1,250),") end I get this error: The remaining text does not appear to be part of the formula.

trying to create a formula that give me the previous year if I enter the current year parameter. example, if i enter 2007 as the current year then the previous year would be 2006. i'm trying to use the datediff("yyyy", {year1},{year1} - 1) but i'm getting this error: A date is required here...

Is it possible to run Crystal reports as SQL jobs?

I'm trying to create a formula to distribute the amount paid based to the start and end dates. Example, customer pays $12000 today (5/25) and we would start charging them subscription for 12 months starting 6/01. Fields are: subscription amt = $12000 start date = 06/01/2007 end date =...

We have Lotus notes 7 which is our default e-mail service. We want to use our financial system to email statements to customers. The financial system only uses MAPI compliant email service. Is Lotus Notes 7 MAPI compliant, if not, how can we convert it to be compliant? Are there any...

Is there anyway I could retrieve deleted sent emails if its not in the Deleted Items anymore. We don't have Exchange server.