Search results for query: *

Hi, While saving report to Excel/PDF from WebIntelligence, I am getting the following error. I am not getting, why this problem is coming? Can anyone help me to get rid of this problem. The error shown displays the following on screen message: <?xml version="1.0" ?> - <METHODRETURN...

Hi Ties, Thanks for the quick reply. I am using cross tab. I have placed measure type variables for the values I want to get in two new columns. Ony problem is that I am unable to add the column header description. Can you help me? With regards, Adasoft

Hi, I have to amend one report build using Business Objects (version 6.1). The report is using two crosstabs. I am able to add the two columns needed for amendment but I am unable to add the column header description for them. While adding the column header description, it gives error message...

Hi SQLDenis, Thanx a lot for the responce. Your link is useful enough for me. With regards, Rajendra

Hi, I am having one stored procedure named SP1 which is having one input and one output parameter. I have write another stored procedure named SP2 which is creating a dynamic SQL statement like @variable = 'exec ' + @CURR_PROC_NAME + ' '''+ @STR_Var_VARCHAR + ''' , @STR_RETURN_STRING OUTPUT...

Hi, Thanks very much for this valuable help.Its work fine.

Hi, How can I insert declaration statement in XML document if I am creating XML document using DOM. For example: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> When I am creating XML document using VB 6.0 with Msxml2.DOMDocument.4.0, it is not being inserted automatically.Can anyone...

Hi, I have got the solution.One can get the help from this too DECLARE @TestCol varchar(100) SELECT @TestCol = COALESCE(@TestCol + ', ', '') + CAST(Col3 AS varchar(5)) FROM TestTable WHERE Col1 = 1

Hi, I have written following Query ( Select PersonnelNumber , dtEmpAccount.EmployeeID ,AccountID, AttributeCode, CurrentValue, UpdatedDate,AttributeUnit , recordType FROM dtEmpAccount, Employee, dtAccountDef Where Employee.EmployeeID = dtEmpAccount.EmployeeID AND...

Hi, I am having 3 record in table with column name say col1, col2, col3. I want to fetch all the 3 record in such a way that i can get the value of col3 for each record in one row. Say Col3 , col3 , col3 . Can any one help me I have to write these value in sequence in file.

Hi, I am having a machine having SQL Server installed with two IP Addresses.One is local and other is global(external).My network has a router which routes the connection recieved on global IP to the local IP. If I connect from a VB application installed on a machine of my network to the SQL...

Hi, I am having a machine having SQL Server installed with two IP Addresses.One is local and other is global.My network has a router which routes the connection recieved on global IP to the local IP. If I connect from a machine of my network to the SQL Server by giving local IP Address, then it...

Hi, I have a new requirement.Say, there is a table having information related to an employee like name, ID , Email etc.There is folder on the system which has photos of the employees. The photo files are named based on employee ID. I want that the report should show EmployeeID, name, Email etc...

Hi, You are right. There was fault on MSDE networking configuration settings.There were no protocols enabled for the netwrok connections.We changed it and now it is working fine. Thanx for the support.

Yes its on local machine

Yes

Hi, The problem is not with MSDE i am able to connect MSDE database with my applications in VB using Machine Name , IP address , (Local) as server name. But when i try with Crystal report it fail with Machine Name And (Local) as server name but with IP address it work fine.

Yes, we have tried using SA user.I think it is not the security problem because it is running using IP Address of the MSDE machine but fails using machine name.

We have already tried ticking this option.When we create new report using ODBC as data explorer then it works fine.But when we uses "Microsoft SQL Server" available below "More data sources" then report does not even connect to SQL server.This problem is only with MSDE 2000.Is it problem of...

ODBC is working is properly and report is also working.But if we uses Microsoft SQL server available in More data sources then report does not even connect to SQL server.It gives message "Unable to connect to SQL Server <Server name>".