| Groups | Blog | Home |
sql server reporting services : Using RS Web Service
I am using Reporting Services's web services to migrate reports across environments. I have a report path from the source which i need to migrate . ex say reportPath1 = "/abc/xyz/report1" Before calling the create report i have to create the folders. I know there is a method called as CreatFolder, But i need to check as to if the folder doesn't exits create it else dont create. There is no method which tells whether the folder exists or not. Can some one help me solving this prob
You could also call ListChildren passing in the folder you want to check.
The method will throw and error if the item does not exist. -- -Daniel This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Adrian M." <absolutelynospam@nodomain_.com> wrote in message news:u$i%23Bcv$EHA.1404@TK2MSFTNGP11.phx.gbl... > Try something like: > > private bool DoesFolderExist (string folder) > { > SearchCondition condition = new SearchCondition(); > condition.Condition = ConditionEnum.Contains; > condition.ConditionSpecified = true; > condition.Name = "Name"; > condition.Value =folder; > > SearchCondition[] conditions; > conditions = new SearchCondition[1]; > conditions[0] = condition; > > CatalogItem[] returnedItems = m_ReportingService.FindItems( "/", > BooleanOperatorEnum.Or, conditions ); > > if (returnedItems != null && returnedItems.Length != 0) > foreach ( CatalogItem ci in returnedItems) > if (ci.Type == ItemTypeEnum.Folder) > if (ci.Name == folder) return true; > > return false; > } > > folder is the name of the folder you are checking to see if it exists. > > Adrian M. > > "Hari" <Hari@discussions.microsoft.com> wrote in message > news:AF901289-045C-48A2-BFCF-0168CE984E4D@microsoft.com... >> Hi all >> I am using Reporting Services's web services to migrate >> reports across environments. I have a report path from the source which i >> need to migrate . >> ex say reportPath1 = "/abc/xyz/report1" >> Before calling the create report i have to create the folders. I know >> there >> is a method called as CreatFolder, But i need to check as to if the >> folder >> doesn't exits create it else dont create. There is no method which tells >> whether the folder exists or not. Can some one help me solving this prob >> >> > >
Try something like:
private bool DoesFolderExist (string folder) { SearchCondition condition = new SearchCondition(); condition.Condition = ConditionEnum.Contains; condition.ConditionSpecified = true; condition.Name = "Name"; condition.Value =folder; SearchCondition[] conditions; conditions = new SearchCondition[1]; conditions[0] = condition; CatalogItem[] returnedItems = m_ReportingService.FindItems( "/", BooleanOperatorEnum.Or, conditions ); if (returnedItems != null && returnedItems.Length != 0) foreach ( CatalogItem ci in returnedItems) if (ci.Type == ItemTypeEnum.Folder) if (ci.Name == folder) return true; return false; } folder is the name of the folder you are checking to see if it exists. Adrian M. [quoted text, click to view] "Hari" <Hari@discussions.microsoft.com> wrote in message news:AF901289-045C-48A2-BFCF-0168CE984E4D@microsoft.com... > Hi all > I am using Reporting Services's web services to migrate > reports across environments. I have a report path from the source which i > need to migrate . > ex say reportPath1 = "/abc/xyz/report1" > Before calling the create report i have to create the folders. I know > there > is a method called as CreatFolder, But i need to check as to if the folder > doesn't exits create it else dont create. There is no method which tells > whether the folder exists or not. Can some one help me solving this prob > >
Thanks for your reply Adrian.
I know about the FindiTems method. I wanted to check whether a folder exists in the current folder i am looking at. But find items will search the entire heirarchy and if there is any folder somewhere else but not in the folder i wanted to search in it would still give me a true value, which is not true. [quoted text, click to view] "Adrian M." wrote:
> Try something like: > > private bool DoesFolderExist (string folder) > { > SearchCondition condition = new SearchCondition(); > condition.Condition = ConditionEnum.Contains; > condition.ConditionSpecified = true; > condition.Name = "Name"; > condition.Value =folder; > > SearchCondition[] conditions; > conditions = new SearchCondition[1]; > conditions[0] = condition; > > CatalogItem[] returnedItems = m_ReportingService.FindItems( "/", > BooleanOperatorEnum.Or, conditions ); > > if (returnedItems != null && returnedItems.Length != 0) > foreach ( CatalogItem ci in returnedItems) > if (ci.Type == ItemTypeEnum.Folder) > if (ci.Name == folder) return true; > > return false; > } > > folder is the name of the folder you are checking to see if it exists. > > Adrian M. > > "Hari" <Hari@discussions.microsoft.com> wrote in message > news:AF901289-045C-48A2-BFCF-0168CE984E4D@microsoft.com... > > Hi all > > I am using Reporting Services's web services to migrate > > reports across environments. I have a report path from the source which i > > need to migrate . > > ex say reportPath1 = "/abc/xyz/report1" > > Before calling the create report i have to create the folders. I know > > there > > is a method called as CreatFolder, But i need to check as to if the folder > > doesn't exits create it else dont create. There is no method which tells > > whether the folder exists or not. Can some one help me solving this prob > > > > > >
Hari,
FindItems should work fine. Just pass in the full path of the folder you want to search. You don't necessarily have to start from the root. If you want to search the root: CatalogItem[] returnedItems = m_ReportingService.FindItems( "/", BooleanOperatorEnum.Or, conditions ); If you want to search a folder called Test: CatalogItem[] returnedItems = m_ReportingService.FindItems( "/Test", BooleanOperatorEnum.Or, conditions ); ....etc [quoted text, click to view] "Hari" <Hari@discussions.microsoft.com> wrote in message news:4932D408-75D2-43FC-9855-24A6B3FC41F8@microsoft.com... > Thanks for your reply Adrian. > I know about the FindiTems method. I wanted to check whether a folder > exists > in the current folder i am looking at. But find items will search the > entire > heirarchy and if there is any folder somewhere else but not in the folder > i > wanted to search in it would still give me a true value, which is not > true. > > > "Adrian M." wrote: > >> Try something like: >> >> private bool DoesFolderExist (string folder) >> { >> SearchCondition condition = new SearchCondition(); >> condition.Condition = ConditionEnum.Contains; >> condition.ConditionSpecified = true; >> condition.Name = "Name"; >> condition.Value =folder; >> >> SearchCondition[] conditions; >> conditions = new SearchCondition[1]; >> conditions[0] = condition; >> >> CatalogItem[] returnedItems = m_ReportingService.FindItems( "/", >> BooleanOperatorEnum.Or, conditions ); >> >> if (returnedItems != null && returnedItems.Length != 0) >> foreach ( CatalogItem ci in returnedItems) >> if (ci.Type == ItemTypeEnum.Folder) >> if (ci.Name == folder) return true; >> >> return false; >> } >> >> folder is the name of the folder you are checking to see if it exists. >> >> Adrian M. >> >> "Hari" <Hari@discussions.microsoft.com> wrote in message >> news:AF901289-045C-48A2-BFCF-0168CE984E4D@microsoft.com... >> > Hi all >> > I am using Reporting Services's web services to migrate >> > reports across environments. I have a report path from the source which >> > i >> > need to migrate . >> > ex say reportPath1 = "/abc/xyz/report1" >> > Before calling the create report i have to create the folders. I know >> > there >> > is a method called as CreatFolder, But i need to check as to if the >> > folder >> > doesn't exits create it else dont create. There is no method which >> > tells >> > whether the folder exists or not. Can some one help me solving this >> > prob >> > >> > >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |