Saturday 12 May 2012

Build-In-Fields


1.       Rigth click on TextBox or Table Cell etc. Select Expression.


2.       Select Build-In-Fields.


ExecutionTime:
The date and time that the report began to run.( =Globals!ExecutionTime)


Language:
The language ID of the client running the report.(=User-language)
Ex: (=User!language) – is              en-US.


OverallPageNumber:
The current overall page number. Can be used only in a page header or footer.
Note:
It returns the current page number.


OverallTotalPages:
The total number of pages in the report. Can be used only in a page header and footer.
Note:
 It returns the total number of pages generated.


PageName:
The name of the current page in the report. Can be used only in page header or footer.


PageNumber:
The current page number, which can be reset through the use of page breaks. Can be used only in page header or footer.
Note:
Its similar to OverallPageNumber.The difference is PageNumber can be reset through page break.


RenderFormat.Name:
The name of the renderer as registered in the RSReportServer configuration file.
Ex: Globales!RenderFormat.Name ----   IMAGE


ReportFolder:
The full path to the folder containing the report. This does not include the report server URL.
Ex: Globals!ReportFolder


ReportName:
The name of the report as it is stored in the report server database.
Ex: Globals!ReportName


ReportServerUrl
The URL of the report server on which the report is being run.
Ex: =Globals!ReportServerUrl


TotalPages:
The total number of pages in the current continous page sequence. The number can be reset by using page breaks. Can be used only in a page header and footer.
Ex:=Globals!TotalPages ----  Current Total Pages. It can be reset by the page breaks or group break etc.


UserId:
The ID of the user running the report.
Ex: =User!UserID  ----   Will returns the current user Name and group name.


No comments:

Post a Comment