Contents
Introduction
Licensing
Expressions
Introduction
Text in expressions
Calculations of values in expression
Multiline expressions
Using variables from the dictionary
Using variables from the report code
Using fields from data sources
System variables
Using properties of components
Functions in expression
Expressions with condition
Text information output
Introduction
Output of text parameters
Introduction
Multiline text
Text Trimming
Prevention of incompletely visible lines
Lines of underlining
Maximal number of lines
Text rotation
Merging of duplicated values
Highlight condition
Hiding of zero values
ReportTo
Expressions in text
Introduction
Text output without expressions
Expressions processing in the end of the report rendering
Text format
Introduction
Standard format
Numerical format
Currency format
Date format
Time format
Percentage data format
Boolean values format
Custom format
Format in the text
Rtf text output
Introduction
Rtf text editor
Expressions in the Rtf text
Loading the Rtf text from the data field
System information
Graphic information output
Introduction
Imaging
Image loading
Image stretching
Bar-codes
Shapes
How to transfer an image to the StiImage component
Styles of components
Introduction
Font
Background
Border
Horizontal alignment
Vertical alignment
Report
Introduction
Report rendering
Report code
Programming language of a report
Integration of the report code to VisualStudio.Net
Bands
Introduction
Types of bands
Bands output
Data bands
Introduction
Data source for the Data band
Virtual Data band
List output
List with header
List with footer
Lists one after another output
Even or odd strings filling
Data sorting
Data filtration
Page bands
Introduction
Page header
Page footer
Reports with grouping
Introduction
Condition of grouping
Group header
Group footer
Whole group output
New page formation
Group footers output only
Nested groups
Totals of a group
Strings numbering in a group
Grouping in the multicolumn reports
Reports with columns
Introduction
Columns on a page
Columns on the data band
Across Then Down column output mode
Down Then Across column output mode
Minimal number of strings in a column
Column headers
Column footer
Headers and footers combination
Two bands output on one band
Data strings numbering
Containers
Introduction
Bands positioning in a container
Containers position
Using the StartNewPage property
Side by Side reports
Multiple tables on one page output
Cloning
Autosizing
Introduction
Automatic change of a size
Automatic change of a text size
Automatic change of containers size
Automatic change of bands size
Both bands and columns size changing
Binding to the bottom of the component
Components shift
Calculation of totals
Introduction
Calculation of totals procedure
Totals output in any part of a report
The type of a result of an aggregate function
Expressions with aggregate functions
Totals with conditions
Calculation of totals of a page and of a container
Calculation of totals of a column
Calculation of totals in a code of report events
Calculation of growing total
Invisible bands
Totals and automatic change of a size
Aggregate functions syntax
Calculation of totals in hierarchical reports
Navigation
Introduction
Bookmarks
Tree of bookmarks
Hyperlinks
Reports with content
Bookmarks creation using a code
Developer FAQ
General
How to save load a report
How to render a report
How to bind data to a report
When should I attach data - before loading of a report or after it
How to run a report designer
How to save load a rendered report
How to load DataSet XSD schema
How to change the current script language of a report
Report Designer
Our users find the Designer too complicated. What can we do to cut off unwanted functions
What can I do to hide tips when running the Designer
How to hide the tab page with the report code
How to make the Designer not to ask about saving a report before quitting
What can I do something after running the Designer but before initialization
How to intercept saving/loading a report in the report Designer
How to hide something in the data dictionary
How to change the name of the edited file in the report Designer
How to hide a menu element in the designer
Work with a report
Access to data
How to change data of connection with database
How to address to the column with data directly without typical conversion
How to change a text of query when report rendering
All data are received by a report. Is it possible to register in a report
How to add a parameter to SQL query
How to render a report on the server and send to your client
Is it possible to design the report in the designer using a local database and change the database in code once online
Is it possible to display images, both stored in a database or hosted on a server
Can I change the report connection string on run time
How to send parameters for SQL query by application
How to check null values
How to render Master-Detail reports if two tables are located on another DataSet
Formatting and converting
How to convert coordinates of one unit into another
How to convert coordinates and sizes of a report
How to output the value instead of DBNull and Null values
Variables
How to add a variable in a report
How to get access to the value of a variable
How to add system variable to the text
Miscellaneous
How to change sorting of data
How to get actual size of a component
How to find a component by its name
How to get or set a text to rtf component in rtf format
How should I add a bookmark for a component using code
What is the difference between the Text and the TextValue
What should I specify in the DataColumn field of an image
How to load image from the path, stored in database
How to bind ComboBox on Form to Data
How to get access to the text of the report code
How to generate a new code of a report
How to update a report code
How to use custom assemblies in a report
How should I get access to objects of my application from a report
How to work with columns which names concur with the csharp key word
How to load an image from URL
How to find the name of the file from which the report was loaded
How to change CheckBox value on a page in preview
How to change the page number
Are there any ways to print a header for a databand on the second page
How to minimize the font size of the text component depending on the text size
How to change duplicated values on a band with one
How to add the event handler to events
How to get access to pages of a report
How to get the total of a band without its printing
How to sort data on the base of the Expression
Cross-report rendering by 3 tables
Text formatting in the RichText component in the GetValue event handler
Work with compiled report
How to compile report to assembly
How to load a report from assembly into the memory once only
How to use the compiled report assembly
How to get compatibility of versions of the report generator and compiled reports
How to load a report from assembly
Preview
How to process saving and loading of a rendered report by myself
How to process printing in the Window of Preview
How to disable buttons in the toolbar
How to disable the toolbar
How to specify to the report generator to output the result of report rendering in the StiPreviewControl
How to specify to the report generator to use my window of report preview
How to set zoom of pages in the StiPreviewControl
How to set predefined zoom of pages in the StiPreviewControl
How to refresh the report preview in the report code
How to load a page into the rendered report from the code of the report
How to get access to pages of rendered report
How to show all components in preview but do not print them
How to add or change an image in the rendered report in the report code
How to indicate pressing the cancel button in the Window of Preview and do not show the report
How to attach your indicator of pages rendering
Why the text I have printed does not look similar with the text in Preview
Printing Reports
How to print a report immediately without preview
How to print report without dialog box
How to print a report with specified parameters
How to print a report with the specified printer
How to indicate the specified paper source for printing
The end of the page is not printed completely. What should I do
How to print copyright on every page of a report
Why the content of the Text is printed without last pixels
Export of reports
How to export rendered report
How to export a report without using the dialog box
How to disable all unnecessary types of export from the Window of Preview
How to export a page with the specified size into the Bitmap
When I export a report to Html but not all components which are crossed have been exported
How, using the RichText, to output the text in the RTF format
The ExcelValue property
Configuration
What can I do to load or save report configuration
What can I do if I do not want to save configuration
How to restore configuration by default
How to use more then one configurations concurrently
How to save configuration in database
How to attach your own TraceListener
How to show all exceptions which are invoked in StimulReport.Net
How, in StimulReport.Net, to disable all dialog boxes with messages
How to change the current localization of the report generator
How to change the path to resources of localization
How, in addition to English, to add other languages to localization
How to decrease the number of levels of relations in business objects
How to enable RightToLeft in the Window of Preview
Which units are used to store report coordinates
How to change the current unit in the report

© 2003-2007 Stimulsoft