Can get RDL file name?

Hi,

Is any way can get RDL file name and show on text box?

Any function or something else?

Thanks for any advices!

As the data is tranfered to sql server the report file does not exists anymore as a file. The file that you can download from the web interface is simply composed by reportname + rdl extension.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

The ReportObjectModel exposed to RDL expressions contains several collections (see also: http://msdn2.microsoft.com/en-us/library/ms157274.aspx). One of them is the Globals collections:

Member

Type

Description

ExecutionTime

DateTime

The date and time that the report began to run.

PageNumber

Integer

The current page number. Can be used only in page header and footer.

ReportFolder

String

The full path to the folder containing the report. This does not include the report server URL.

ReportName

String

The name of the report as it is stored in the report server database.

ReportServerUrl

String

The URL of the report server on which the report is being run.

TotalPages

Integer

The total number of pages in the report. Can be used only in page header and footer.

The following expression would show you the path and report name of the current report:

=Globals.ReportFolder & Globals.ReportName

-- Robert