Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: adasoft
  • Order by date
  1. adasoft

    Error saving report to Excel/PDF from WebIntelligence

    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...
  2. adasoft

    Unable to add column header descirption in crosstab

    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
  3. adasoft

    Unable to add column header descirption in crosstab

    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...
  4. adasoft

    Can anyone help regarding stored procedure

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

    Can anyone help regarding stored procedure

    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...
  6. adasoft

    Declaration statement in XML

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

    Declaration statement in XML

    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...
    • adasoft
    • Thread
    • Replies: 3
    • Forum: XML
  8. adasoft

    Multiple records in One Row Column Wise

    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
  9. adasoft

    Problem to get record with Max (UpdatedDate)

    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...
  10. adasoft

    Multiple records in One Row Column Wise

    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.
  11. adasoft

    How to connect

    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...
  12. adasoft

    How to connect

    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...
  13. adasoft

    How to show photos on report

    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...
  14. adasoft

    Error while runing report

    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.
  15. adasoft

    Error while runing report

    Yes its on local machine
  16. adasoft

    Pls Help : &quot;Unable To Connect to Sql Server ...&quot;

    Yes
  17. adasoft

    Error while runing report

    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.
  18. adasoft

    Error while runing report

    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.
  19. adasoft

    Error while runing report

    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...
  20. adasoft

    Error while runing report

    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>".

Part and Inventory Search

Back
Top