Implementing SQL Server Reporting Services with a Java EE Application

[Khushwinder Chahal]

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 lines in my code where i have used findItem() method. I am not able to predict what should i have to write in place of foldername option in that method.
I have tried a lot of things but no success.

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;
[B]port.findItems("foldername",BooleanOperatorEnum.Or, [/B]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.
[ February 20, 2008: Message edited by: Khushwinder Chahal ]

[Khushwinder Chahal]

Thanks all.
have solved it with the help of my friend.
Regards.