Field Setup
After loading the database, the database objects (tables, views, custom views and
reports) will be shown in the left pane (the database pane). Click on any database
object to go to the Field Setup Page for that object at any time.
Note: ASP.NET Report Maker does not support BLOB fields. If ASP.NET
Report Maker finds any unsupported fields in a table, an [Unsupported Fields]
tab will appear. You can click on the tab to view the list of fields that are not
supported.
The Field Setup pages consists of two section. The upper section is a grid showing
available options of all fields. The lower section contain two panels, the [View
tag] panel and the [Report Field Settings] panel for
the selected field.
The grid consists of the following sections:
General
Properties
|
Field Name
|
Field Name (read only)
|
|
Data Type
|
Data Type (read only)
|
|
Size
|
Maximum field length (read only)
|
|
Caption
|
Caption to be displayed
|
Report Page
Properties
|
Show |
Show field in report page
|
|
Width |
Specify field column width
e.g. If you enter "200px" (without quotes), the output will be style="width:
200px"
|
|
Wrap |
Enable/Disable wrapping of field value
|
|
Filter |
Enable/Disable popup filter for the field in the report.
Normally, distinct values in the field will be populated in the popup filter. However,
if the field is group-level fields, the grouping intervals will be used. If enabled,
you can optionally enable "Range" for the filter. If the data type of
the field is datetime, you can also optionally enable relative filters. See
[Report Field Settings] below for details.
Note: Always use as few filters as possible, especially for Detail
and Summary Reports that have a large number of detail records. The more filters
applied, the slower the page loads.
|
Custom field display order by drag-and-drop
You can change the field order defined in the database by simple drag-and-drop.
Simply click the Field Name column to select the field, then drag it to where you
want. ASP.NET Report Maker will generate ASP.NET and display
records according to this order. (For Detail and Summary Report only)
View Tag Panel
You can click the icon on the View Tag panel toolbar to select how to display the
field. After selecting the View Tag, you can further setup its properties in the
View tag panel.
There are two types of View tag, Formatted Text and Image.
Formatted Text - View Tag to display the field value as formatted
text with optional hyperlink. Properties:
|
Style |
|
Bold
|
Display as Bold (enclosed with <b> </b> tags)
|
|
Italic
|
Display as Italic (enclosed with <i> </i> tags)
|
|
Align |
Left/Center/Right/Justify. Align the data (enclosed with <div> </div>
tags)
|
|
Format
|
|
None
|
No formatting
|
|
Currency
|
Display in currency format (VBScript FormatCurrency function)
|
|
Date/Time
|
Display in date format (ASP.NET Report Maker formatdatetime function)
|
|
Number
|
Display in number format (VBScript FormatNumber function)
|
|
Percent
|
Display in percent format (VBScript FormatPercent function)
|
|
String |
Format the field value with specified VBScript string function or custom function |
|
Max Length (List page)
|
Truncate the field value at specified max. length and append "..." to
the end.
Note: This setting only applied to memo fields in list page and
must be larger than 0 to take effect.
|
|
Hyperlink |
|
HREF field |
Display the field as hyperlink with the href attribute set to the value of this
field. Can be the field itself. |
|
Target |
_top/_parent/_self/_blank |
|
Prefix |
- None (no prefix, relative path of url)
- http:// (prefix http:// added, absolute path of url)
- mailto: (prefix mailto: added, email link)
- ftp:// (prefix ftp:// added, ftp link)
- file:// (prefix file:// added, file link)
- news:// (prefix news:// added, newsgroup link)
|
|
Suffix |
Append the input string to the URL |
Image - View Tag to display as Image using <img> tag. The
field should be a field storing the path of the image.
|
IMG Tag attributes |
|
Width |
Specify the width of the image |
|
Height |
Specify the height of the image |
|
Hyperlink (same as above) |
Report Field Settings Panel
Crosstab Report
|
Crosstab |
This read-only property show the type of the field in the report, possible values
are:
- Row Heading
- Column Heading
- Value
- (Not shown)
You can click the [...] button to edit the report.
|
|
Grouping Level
|
If the field is Row Heading in the report, this read-only property
show the grouping level, possible values are 1-4.
You can click the [...] button to edit the report.
|
|
Show Summary
|
If the field is Row Heading in the report, this property sets if
summary should be displayed at the end of each grouping level.
|
|
Summary Value
|
If the field is Value field in the report, this property sets the
summary value, possible values are:
|
|
Grouping Interval
|
If the field is Column Heading field in the report and is of date/time
type, this property sets the interval for the field values, possible value are:
- Year
- Quarter
- Month
- Date
- Date/Time
|
|
Year filter
|
If the field is Column Heading field in the report and is of
date/time type, and the Grouping Interval is Quarter
or Month, this setting become available. If unchecked, quarters
or months of different year in the report will be displayed together. If checked,
a combobox for the available years will be added automatically to the report so
user can select which year's data to display.
|
Detail and Summary Report
|
Detail/Summary |
This read-only property show the type of the field in the report, possible values
are:
- Group-level
- Value
- (Not shown)
You can click the [...] button to edit the report.
|
|
Grouping Level
|
If the field is group-level field in the report, this read-only
property show the grouping level, possible values are 1-4.
You can click the [...] button to edit the report.
|
|
Show Summary
|
If the field is group-level field in the report, this property
sets if summary should be displayed at the end of each grouping level.
|
|
Grouping Interval
|
If the field is group-level field in the report and is of date/time
type, this property sets the interval for the field values, possible
value are:
- Normal (All distinct values)
- Quarter
- Month
- Week
- Day
- Hour
- Minute
If the field is group-level field in the report and is of string
type, this property sets the interval for the field values, possible
value are:
- Normal (All distinct values)
- 1st Letter
- 2 Initial Letters
- 3 Initial Letters
- 4 Initial Letters
- 5 Initial Letters
If the field is group-level field in the report and is of numeric
type, this property sets the interval for the field values, possible
value are:
- Normal (All distinct values)
- 10s
- 50s
- 100s
- 500s
- 1000s
- 5000s
- 10000s
|
|
Summary Value
|
If the field is Value field in the report and is of numeric
type, this property sets the summary values, possible values are:
More than one summary values are allowed.
|
Filters
|
Relative Days
|
Add the following options in the popup filter:
|
|
Relative Day Periods
|
Add the following options in the popup filter:
- Last 30 days
- Last 14 days
- Last 7 days
- Next 7 days
- Next 14 days
- Next 30 days
|
|
Relative Weeks |
Add the following options in the popup filter:
- Last two weeks
- Last week
- This week
- Next week
- Next two weeks
|
|
Relative Months |
Add the following options in the popup filter:
- Last month
- This month
- Next month
|
|
Relative Years |
Add the following options in the popup filter:
- Last year
- This year
- Next year
|
|
Past / Future |
Add the following options in the popup filter:
|
|
Range |
Add [From] and [To] combobox in the popup filter
for user to select a range of field values to filter.
This option is only available for field with "Filter" enabled in above
grid.
|
Note: The optional Relative Days, Relative
Day Periods, Relative Weeks, Relative Months,
Relative Years, Past/Future filters are only available
for datetime field with "Filter" enabled in above grid.
These options are also not available when the field is set as Column Headings in
Crosstab Report.
|
