Hi All,
I need to find some tutorial on
"Implementing SQL Server Reporting Services with a Java EE Application"
for my j2EE application.
Until now i have searched a lot of sites but have not any thing related to this topic.
I am using apache axis along with SQL Server Report Manager for creating the sql server reports.
I have done upto :
Creating the webservice with the help of report manager.
Now i want to connect it through my j2EE application and want to retrieve some data from that web service.
I have got stuck on the following BOLD lines in my code .
code:
public CatalogItem[] getData(String res, String searchStr) throws RemoteException {
ReportingService2005Soap port = null;
ReportingService2005Locator loc = new ReportingService2005Locator();
// Retrieve a port from the service locator
try {
port = loc.getReportingService2005Soap(new java.net.URL(res));
} catch (MalformedURLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ServiceException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
org.apache.axis.client.Stub stub = (org.apache.axis.client.Stub) port;
stub.setUsername("localhost\\Administrator");
stub.setPassword("servWIN@2007");
// Retrieve a port from the service locator
SearchCondition condition = new SearchCondition();
condition.setCondition(ConditionEnum.Contains);
condition.setName("Name");
if (searchStr != null)
{
condition.setValue(searchStr);
}
else
{
condition.setValue("");
}
// Create an array of SearchConditions which will contain our single search condition
SearchCondition[] conditions;
conditions = new SearchCondition[1];
conditions[0] = condition;
// Call the Web service with the appropriate CatalogItem[] returnedItems;
CatalogItem[] returnedItems = null;
port.findItems("foldername",BooleanOperatorEnum.Or, conditions);
return returnedItems;
}
i.e. while executing the findItems() method i got the following exception :
System.Web.Services.Protocols.SoapException: The item '/reportingservices' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/reportingservices' cannot be found.
at Microsoft.ReportingServices.Library.RSService.FindItems(String folder, String operation, SearchCondition[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions, CatalogItem[]& Items)
Any any body has any idea please help me.
I need it urgently.
Regards.