Sybase InfoMaker 11.5, CD, Win, ENG Specifiche Pagina 319
- Pagina / 828
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
Users Guide 297
CHAPTER 9
Filtering, Sorting, and Grouping
Rows
About this chapter
This chapter describes how you can customize your report by doing the
following in the Report painter:
• Defining filters to limit which of the retrieved rows are displayed in
the report
• Sorting rows after they have been retrieved from the database
• Displaying the rows in groups and calculating statistics on each group
Contents
Filtering rows
You can use WHERE and HAVING clauses and retrieval arguments in the
SQL
SELECT statement for the report to limit the data that is retrieved
from the database. This reduces retrieval time and space requirements at
runtime.
However, you may want to further limit the data that displays in the report.
For example, you might want to:
• Retrieve many rows and initially display only a subset
• Limit the data that is displayed using InfoMaker expression functions
(such as
If) that are not valid in the SELECT statement
Topic Page
Filtering rows 297
Sorting rows 299
Grouping rows 302
- InfoMaker 1
- DC37789-01-1150-01 2
- September 2008 2
- PART 2 WORKING WITH DATABASES 5
- PART 3 REPORTS 6
- Contents 10
- Users Guide xiii 13
- PART 5 APPLICATIONS 15
- PART 7 APPENDIXES 19
- About This Book 21
- Other sources of 22
- If you need help 22
- The InfoMaker 23
- Environment 23
- Working with InfoMaker 25
- About InfoMaker 26
- 6 InfoMaker 28
- Users Guide 7 29
- Group report 29
- TreeView report 30
- Users Guide 9 31
- Freeform form 31
- Freeform Grid 31
- Data pipelines 32
- Applications 33
- Database management 33
- The InfoMaker environment 34
- About the PowerBar 35
- Working with libraries 36
- Users Guide 15 37
- ❖ To set the current library: 37
- About creating a new library 37
- Working with objects 38
- Opening existing objects 39
- Working in painters 40
- Opening painters 41
- Painter summary 41
- Using views in painters 41
- Users Guide 21 43
- ❖ To move a pane: 43
- Floating and docking views 44
- Adding and removing views 45
- Saving a layout 46
- Using pop-up menus 46
- Defining colors 47
- Working with tools 48
- Using property pages 49
- Using toolbars 51
- Customizing toolbars 53
- Report /o ReportName /ro 57
- Creating new toolbars 58
- Using report wizards 59
- Using the To-Do List 60
- Using online Help 61
- Windows Help files on Vista 63
- Users Guide 43 65
- Using the file editor 66
- Editing activities 67
- Changing fonts 68
- Users Guide 47 69
- Using the Query Governor 70
- Accessing the Query Governor 71
- About the registry 73
- About the initialization file 73
- Working with Libraries 77
- Creating new libraries 79
- About the Library painter 80
- Using the pop-up menu 82
- Selecting objects 82
- Changing the current library 84
- Users Guide 63 85
- ❖ To open an object: 85
- Setting the root 86
- Modifying comments 87
- Deleting libraries 88
- Optimizing libraries 89
- Regenerating library entries 89
- Rebuilding libraries 90
- Migrating libraries 91
- 70 InfoMaker 92
- Working with Databases 93
- Managing the Database 95
- Users Guide 75 97
- Database views 97
- Extended attributes 98
- Additional database 98
- Managing databases 99
- Using the Database painter 100
- 80 InfoMaker 102
- Logging your work 104
- Users Guide 83 105
- Working with tables 106
- Users Guide 85 107
- About saving the table 107
- Specifying column definitions 108
- Specifying table properties 109
- Dept_name is Dept Name. To 111
- Altering a table 112
- Users Guide 91 113
- ❖ To alter a table: 113
- Closing a table 114
- Dropping a table 115
- Viewing pending SQL changes 115
- Printing the table definition 116
- Exporting table syntax 117
- About system tables 117
- Working with keys 119
- Users Guide 99 121
- Defining primary keys 121
- ❖ To create a primary key: 121
- Naming a primary key 121
- Working with indexes 123
- Working with database views 125
- Users Guide 105 127
- Users Guide 107 129
- ❖ To join tables: 129
- About the Query Governor 129
- Manipulating data 130
- Retrieving data 131
- Modifying data 131
- Sorting rows 132
- Users Guide 111 133
- Precedence of sorting 133
- If you change your mind 133
- Filtering rows 134
- Viewing row information 135
- Importing data 135
- Printing data 136
- Saving data 136
- Creating stored procedures 137
- Controlling comments 138
- Entering SQL 138
- Users Guide 117 139
- Typing SQL 139
- EnableSet=1 139
- Explaining SQL 140
- Executing SQL 140
- Customizing the editor 141
- 120 InfoMaker 142
- Working with Data Pipelines 143
- Defining a data pipeline 144
- Piping extended attributes 145
- Creating a data pipeline 146
- SQL SELECT statement 147
- Users Guide 127 149
- 128 InfoMaker 150
- NULL is allowed for 151
- Choosing a pipeline operation 152
- Users Guide 131 153
- For Oracle databases 153
- When using Refresh 153
- When execution stops 154
- No limit or a number 155
- Piping blob data 156
- SELECT statement. After the 157
- InfoMaker 158
- Correcting pipeline errors 159
- Saving a pipeline 160
- Using an existing pipeline 161
- Pipeline examples 161
- PART 3 Reports 163
- Defining Reports 165
- Using the Tabular style 167
- Using the Freeform style 168
- Using the Grid style 168
- Using the Label style 169
- Using the N-Up style 170
- CHAPTER 5 Defining Reports 171
- Using the Group style 172
- Using the Composite style 172
- Using the OLE 2.0 style 174
- Using the RichText style 174
- Building a report 175
- Selecting a data source 176
- Using Quick Select 178
- Selecting a table 179
- Selecting columns 180
- Specifying sorting criteria 181
- Specifying selection criteria 181
- SQL expression examples 184
- Using SQL Select 187
- Selecting tables and views 188
- Joining tables 192
- Using ANSI outer joins 193
- Using retrieval arguments 195
- Using Query 202
- Using External 202
- Using Stored Procedure 204
- Choosing report-wide options 206
- Saving the report 209
- Modifying an existing report 209
- Defining queries 210
- Saving the query 211
- What's next 212
- Enhancing Reports 213
- The header band 216
- The detail band 217
- The summary and footer bands 218
- Users Guide 197 219
- Lasso selection 219
- Importing data into a report 225
- Using print preview 226
- Working in a grid report 229
- Saving the data as PDF 231
- In the Report painter 232
- System requirements 232
- Saving as PDF using XSL-FO 233
- Saving as XSL-FO 234
- Apache Web site at 235
- Working with PSR files 236
- Changing the report style 238
- Setting colors in a report 239
- Users Guide 219 241
- Users Guide 221 243
- 222 InfoMaker 244
- Modifying text in a report 247
- Naming controls in a report 248
- Using borders in a report 248
- Users Guide 227 249
- RowHeight, you must 250
- SELECT statement 250
- Modifying the result set 252
- What happens at runtime 253
- Retrieving rows as needed 255
- Adding controls to a report 257
- Adding text to a report 258
- Users Guide 237 259
- Adding pictures to a report 260
- Users Guide 239 261
- Tips for using pictures 261
- Adding buttons to a report 265
- Adding graphs to a report 267
- Adding reports to a report 268
- Deleting controls in a report 269
- Moving controls in a report 270
- Copying controls in a report 270
- Resizing controls in a report 271
- Aligning controls in a report 271
- Rotating controls in a report 275
- Users Guide 255 277
- 256 InfoMaker 278
- Presenting the data 280
- About display formats 281
- Working with display formats 282
- Users Guide 261 283
- Edit style takes precedence 283
- Defining display formats 285
- Number display formats 287
- String display formats 289
- Date display formats 289
- Time display formats 291
- About edit styles 292
- Working with edit styles 294
- Users Guide 273 295
- ❖ To create a new edit style: 295
- Defining edit styles 296
- Users Guide 275 297
- ❖ To use the Edit edit style: 297
- The CheckBox edit style 298
- The RadioButtons edit style 299
- The EditMask edit style 300
- NULL value for 301
- Users Guide 281 303
- The RichText edit style 305
- The InkEdit edit style 305
- Defining a code table 306
- How code tables are processed 308
- Validating user input 308
- About validation rules 309
- Working with validation rules 310
- Defining validation rules 311
- Defining the expression 312
- Customizing the error message 313
- Specifying initial values 314
- Specifying the expression 315
- Examples 315
- Full_Price column 316
- Commission column is: 316
- Users Guide 295 317
- 296 InfoMaker 318
- Suppressing repeating values 323
- Grouping rows 324
- Users Guide 303 325
- How to do it 325
- Users Guide 305 327
- What InfoMaker does 327
- Users Guide 307 329
- What you can do 329
- Creating subgroups 329
- Sorting the rows 330
- Rearranging the report 331
- Adding summary statistics 332
- Sorting the groups 334
- Users Guide 313 335
- Highlighting Information in 337
- Reports and Forms 337
- Highlighting information 338
- Users Guide 317 339
- Defining an 339
- Users Guide 319 341
- Example 2: rotating controls 343
- Users Guide 323 345
- Supplying property values 347
- 326 InfoMaker 348
- Background.Color 349
- Brush.Color 351
- Brush.Hatch 351
- Users Guide 331 353
- Description 353
- In the painter 353
- Font.Height 354
- Font.Italic 355
- Font.Strikethrough 356
- Font.Underline 357
- Font.Weight 357
- Pen.Color 359
- Pen.Style 359
- Pen.Width 361
- Timer_Interval 362
- Specifying colors 365
- Using Nested Reports 367
- About nested reports 368
- Users Guide 351 373
- Users Guide 353 375
- Working with nested reports 376
- Users Guide 355 377
- ❖ To adjust report width: 377
- WHERE clause of 379
- SELECT statement: 379
- 362 InfoMaker 384
- Exporting and Importing XML 385
- About XML 386
- XML syntax 387
- XML parsing 388
- Users Guide 367 389
- Xerces parser 389
- Export templates 389
- Import templates 389
- Creating templates 392
- Saving templates 393
- Header and Detail sections 393
- The Detail Start 394
- Moving the separator 394
- Header section 395
- Detail section 395
- Editing XML templates 396
- XML declaration 397
- Document type declaration 398
- Root element 399
- Controls 399
- InfoMaker expressions 400
- Attributes 400
- Composite and nested reports 401
- CDATA sections 403
- Comments 403
- Exporting to XML 404
- The Use Template property 405
- Generating group headers 406
- Formatting the exported XML 409
- Exporting metadata 409
- Importing XML 413
- Default data import 417
- Example with empty elements 420
- Tracing import 421
- Working with Graphs 423
- Parts of a graph 424
- Organization of a graph 425
- Types of graphs 426
- Pie graphs 427
- Scatter graphs 427
- Three-dimensional graphs 428
- Using graphs in reports 430
- Placing a graph in a report 431
- Associating data with a graph 434
- Specifying the categories 435
- Specifying the values 435
- Specifying the series 436
- Users Guide 417 439
- Graphing unit sales of 439
- Graphing unit sales by 439
- Users Guide 419 441
- Graphing actual and 441
- Users Guide 423 445
- Specifying axis properties 449
- Specifying a pointer 451
- 430 InfoMaker 452
- Working with Crosstabs 453
- 432 InfoMaker 454
- Two types of crosstabs 455
- Creating crosstabs 456
- Users Guide 435 457
- Specifying the information 458
- Viewing the crosstab 461
- Users Guide 441 463
- Previewing crosstabs 464
- Enhancing crosstabs 464
- Specifying basic properties 465
- Defining summary statistics 467
- Using crosstab functions 469
- Int function to 471
- Creating static crosstabs 473
- Users Guide 453 475
- 454 InfoMaker 476
- Working with TreeViews 477
- Similarities to the 478
- Group presentation 478
- TreeView creation process 479
- Creating a TreeView report 479
- Users Guide 459 481
- Using an expression 482
- Users Guide 461 483
- Users Guide 463 485
- Other actions you can 485
- TreeView report Design view 486
- Users Guide 465 487
- Specifying images for 487
- Users Guide 469 491
- Property Description 491
- 470 InfoMaker 492
- Working with Rich Text 493
- RichText 493
- Creating the report 495
- Users Guide 475 497
- Editing text 497
- Preview mode and editing text 497
- Inserting a file 497
- ❖ To insert a file: 497
- Headers and footers 498
- The whole RichText report 499
- Selected text and paragraphs 499
- Input fields 500
- Users Guide 479 501
- Computed fields 501
- ❖ To define a computed field: 501
- Predefined computed fields 501
- Pictures 502
- Previewing and printing 503
- Formatting keys and toolbars 504
- 484 InfoMaker 506
- Using OLE in a Report 507
- About using OLE in reports 508
- In this section 510
- Adding an ActiveX control 510
- Users Guide 489 511
- Defining the OLE object 512
- Specifying properties 514
- What the data is for 514
- Specifying a value for 516
- Previewing the report 518
- Creating an OLE column 520
- Users Guide 499 521
- Setting properties for 521
- WHERE id = :id 522
- 502 InfoMaker 524
- Access to the Form painter 525
- Defining Forms 527
- About forms 528
- Creating new forms 529
- Freeform forms 531
- Grid forms 532
- Working in a grid form 533
- CHAPTER 18 Defining Forms 535
- Creating and saving forms 536
- Creating a master/detail form 538
- Generating and saving forms 543
- Saving the form 544
- Working with forms 545
- Limiting the retrieved data 546
- Importing data into a form 547
- Printing forms 549
- Actions in forms 549
- 528 InfoMaker 550
- Accessing and deleting forms 552
- Controlling Updates in Forms 553
- Users Guide 533 555
- Using the primary key 555
- Specifying an identity column 556
- Specifying updatable columns 556
- Employee table, whose key is 558
- WHERE clause columns: 558
- How to choose a 560
- Enhancing Forms 561
- About the PainterBars 563
- About the StyleBar 563
- CHAPTER 20 Enhancing Forms 565
- Printing the form definition 568
- Cutting controls 570
- Sliding controls in a form 573
- Specifying a title for a form 575
- Setting colors for a form 575
- Defining your own colors 576
- Modifying text in a form 577
- ❖ To modify text in a form: 578
- Using borders in a form 579
- What happens 580
- SELECT statement, InfoMaker 582
- Adding controls to the form 583
- Defining a computed field 585
- Adding pictures to a form 587
- Adding reports to a form 590
- 572 InfoMaker 594
- Working with Applications 597
- Creating an application 598
- Users Guide 577 599
- ❖ To create an application: 599
- Users Guide 579 601
- Users Guide 581 603
- Reusing an application 604
- Running an application 605
- Identifying your application 607
- Managing the toolbar 609
- Executing pipelines 610
- ❖ To modify the Commit value: 614
- Users Guide 593 615
- Deploying Your Application 617
- About deploying applications 618
- DayName function returns a 620
- String function to format a 620
- Users Guide 599 621
- Configuring an ODBC driver 622
- Deploying SQL Anywhere files 624
- OLE DB database providers 626
- JDBC database interface 626
- Java support 627
- Saving as PDF and XSL-FO 629
- Using the Apache FO processor 631
- Deploying ActiveX controls 632
- Users Guide 611 633
- 612 InfoMaker 634
- Reference 635
- Operators and Expressions 637
- Where you use expressions 638
- GetText 639
- 'C%' OR 642
- 'G%' 642
- 'C%' 642
- Matching text patterns 648
- 628 InfoMaker 650
- DataWindow Expression and 651
- InfoMaker Functions 651
- Four examples 652
- Users Guide 635 657
- Users Guide 637 659
- RGB(255,255,255)) 659
- What you get 659
- Other examples 661
- InfoMaker functions 662
- CrosstabAvg 675
- Users Guide 655 677
- CrosstabAvg(1) 677
- CrosstabAvgDec 679
- CrosstabCount 680
- CrosstabMax 682
- CrosstabMaxDec 683
- CrosstabMin 684
- CrosstabMinDec 685
- CrosstabSum 687
- CrosstabSumDec 689
- CumulativePercent 690
- CumulativeSum 692
- CurrentRow 693
- Date returns null 694
- DateTime 695
- DayNumber 697
- DaysAfter 698
- 2.0d and 699
- Describe 700
- GetRow determines what 705
- IsExpanded 710
- IsNumber 711
- IsRowModified 711
- IsRowNew 712
- IsSelected 712
- 692 InfoMaker 714
- Max; it is faster 715
- LastPos returns 0. If any 718
- LastPos returns null 718
- Left returns the entire 718
- LeftA returns the entire 719
- LeftTrim 720
- LookUpDisplay 723
- Mid function 731
- MidA returns the 732
- PageAcross 741
- PageCount 741
- PageCountAcross 742
- Percent 744
- Pos returns 0 746
- ProfileInt 747
- ProfileString 749
- Rand function is a 750
- Real returns 0 750
- RelativeDate 751
- RelativeTime 751
- Replace 752
- ReplaceA 753
- Right returns the entire 755
- RightA returns the entire 755
- RightTrim 756
- RowCount 757
- RowHeight 757
- SecondsAfter 759
- Min; it is faster 762
- StDev returns an estimate of 764
- StDev assumes that 765
- StripRTF 770
- Time returns 00:00:00 774
- Truncate 775
- WordCap 782
- 762 InfoMaker 784
- Appendixes 785
- Identifiers 787
- Reserved words 788
- The Extended Attribute 789
- System Tables 789
- 80=Decorative 791
- 770 InfoMaker 792
- CheckBox edit style (code 85) 793
- 772 InfoMaker 794
- 774 InfoMaker 796
- Edit edit style (code 89) 797
- 776 InfoMaker 798
- PBCatEdt only 799
- 778 InfoMaker 800
- Numerics 801
© 2020, manymanuals.it. Tutti i diritti riservati | 0.041 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale