Define various options for the download - Magic, Lookup, Excel.
dbQP Abbr: dp
Version: All
Namespace:
TornadoVersion: All
Assembly: Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)
Syntax
| C# |
|---|
public string dbDownloadParams { get; set; } |
| Visual Basic (Declaration) |
|---|
Public Property dbDownloadParams As String |
Field Value
Mydb.dbDownloadParams = "(;,~)Magic | StripHtmlTags| LookUp | Excel | ForceDownload| titlebgcolor| titlecolor| headerbgcolor| headercolor|row1bgcolor| row1color| row2bgcolor| titlerow| row2color| sumbgcolor| sumcolor| CSUM=col1,col2| InsertAfterCol = column, caption, formula ~..... Repeat"| Keyword | Description |
|---|---|
| Field | Download field to be processed by MAgicCell filter. |
| Tag | Tag of field |
| Macro | MagicCell Macro. (See MagicCell reference) |
| Magic | Use Magic Filter - True / False (def) |
| StripHtmlTags | Strip all Html tags from grid/title/Agg templates - True / False (def) |
| LookUp | Use LookUp Filter - True / False (def) |
| Excel | Download as Excel - True / False(Def) |
| ForceDownload | Def=False. If set to True then a content-disposition attachment will be issued. This is the same as the Command line param of the ASPdbDownload except it applies to Excel download. |
| InsertAfterCol | Insert a column after this one with - Column_number, Caption, formula. (0 based) |
| CSUM | Fields to sum at the bottom (index separated by commas) |
| TitleRow | Def=1. how many rows Title occupies. e.g. <H3> occupies 2 rows. |
| titlebgcolor | Def=yellow. Title bg color. (Excel download color) |
| titlecolor | Def=black. Title text color. (Excel download color) |
| headerbgcolor | Def=black. Header bg color. (Excel download color) |
| headercolor> | Def=white. Header text color. (Excel download color) |
| row1bgcolor | Def=black. Zebra row 1 bg color. (Excel download color) |
| row1color | Def=black. Zebra row 1 cell text color. (Excel download color) |
| row2bgcolor | Def=lightgrey. Zebra row 2 cell text color. (Excel download color) |
| row2color | Def=black. Zebra row 2 bg color. (Excel download color) |
| sumbgcolor | Def=cyan. Sum cell bg color. (Excel download color) |
| sumcolor | Def=black. Sum cell text color. (Excel download color) |
| DownloadTitle | Excel directly download title. |
Remarks
If Magic is specified, a new query will be fired to get the raw data and then downloadMagicCell will be applied. Otherwise, the Display data will be used.
Examples
See Special Topic - Download for more details.
