This stores the report details whenever a report set is saved by a name. This can be used for future cases where the same expression is required.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier |
|
APPLICATION NAME |
NVARCHAR |
200 |
|
|
Y |
Name of the application |
|
REPORTSETNAME |
NVARCHAR |
200 |
|
|
Y |
Name of the Report Set |
|
REPORTSETEXPRESSION |
NVARCHAR |
1000 |
|
|
Y |
Expression, which is displayed in the expression box |
|
REPORTSETIDSPEXPRESSION |
NVARCHAR |
1000 |
|
|
Y |
Expression, which gives the Report Set result |
|
REPORTSETEXPRESSIONNAME |
NVARCHAR |
240 |
|
|
Y |
The column on which the query is derived |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated date and time |