How do I get a ReportName using the ReportID in ExecutionLog Table

Hi,
In the executionlog table of ReportServer DB, I can get the ReportID, I want
to get the ReportName for that particular ReportID.
How do i get it?
Thanks
Balaji
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1Look in the Catalog table, I think the ItemId maps to ReportId, use
Name for the report name.
--
Regards
Chris
BALAJI K via SQLMonster.com wrote:
> Hi,
> In the executionlog table of ReportServer DB, I can get the ReportID,
> I want to get the ReportName for that particular ReportID.
> How do i get it?
> Thanks
> Balaji|||If you want to do it programatically, use the GetProperties API. This is the
only API that allows you to pass the report id to get some properties back.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"BALAJI K via SQLMonster.com" <u5178@.uwe> wrote in message
news:578a4972b3b9e@.uwe...
> Hi,
> In the executionlog table of ReportServer DB, I can get the ReportID, I
> want
> to get the ReportName for that particular ReportID.
> How do i get it?
> Thanks
> Balaji
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200511/1