:Base crorg65.hlp :Title Oracle Designer Design and Generation 1 Generating Oracle Reports applications 2 Introducing Oracle Designer Report Generator 3 About Report Generator=crg_About_Report_Generator@crorg65.hlp>main 3 What's new for Report Generator in 6i=crg_WhatsnewforReportGeneratorin6i@crorg65.hlp>main 3 Features added to Report Generator in previous releases 4 Features added to Report Generator in Oracle Designer Release 6.0=crg_FeaturesaddedtoReportGeneratorinOracleDesignerRelease60@crorg65.hlp>main 4 Features added to Report Generator in Oracle Designer Release 2.1.2=crg_FeaturesaddedtoReportGeneratorinOracleDesignerRelease212@crorg65.hlp>main 4 Features added to Report Generator in Designer/2000 Release 2.1.1=crg_FeaturesaddedtoReportGeneratorinDesigner2000Release211@crorg65.hlp>main 4 Features added to Report Generator in Designer/2000 Release 2.1=crg_FeaturesaddedtoReportGeneratorinDesigner2000Release21@crorg65.hlp>main 2 Getting started... 3 An overview of the report generation process=crg_An_overview_of_the_report_generation_process@crorg65.hlp>main 2 Generating Oracle Reports applications 3 Defining report structure 4 Report types and report module structure 5 About report types and report module structure=crg_About_report_types_and_report_module_structure 4 Tabular reports 5 About Tabular reports=crg_About_tabular_reports@crorg65.hlp>main 5 Creating Tabular reports=crg_Creating_tabular_reports@crorg65.hlp>2nd 4 Form reports 5 About Form reports=crg_About_form_reports@crorg65.hlp>main 5 Creating Form reports=crg_Creating_form_reports@crorg65.hlp>2nd 4 Address reports 5 About Address reports=crg_About_address_reports@crorg65.hlp>main 5 Creating Address reports=crg_Creating_address_reports@crorg65.hlp>2nd 4 About report lookup table usages 5 About report lookup table usages=crg_About_report_lookup_table_usages@crorg65.hlp>main 4 Group Left reports 5 About Group Left reports=crg_About_Group_Left_reports@crorg65.hlp>main 5 Creating Group Left reports=crg_Creating_Group_Left_reports@crorg65.hlp>2nd 5 Example of Group Left report with multiple breaks=crg_Example_of_Group_Left_report_with_multiple_breaks@crorg65.hlp>example 4 Group Above reports 5 About Group Above reports=crg_About_Group_Above_reports@crorg65.hlp>main 5 Creating Group Above reports=crg_Creating_Group_Above_reports@crorg65.hlp>2nd 5 Drilldown reports 6 About Drilldown reports=crg_About_Drill_down_reports@crorg65.hlp>main 6 Creating Drilldown reports=crg_Creating_Drill_down_reports@crorg65.hlp>2nd 6 Example of Drilldown report using module components in the same module=crg_Example_of_Drill_down_report_using_module_components_in_the_same_module@crorg65.hlp>example 6 Example of Drilldown report using different modules=crg_Example_of_Drill_down_report_using_different_modules@crorg65.hlp>example 4 Matrix reports 5 About Matrix reports=crg_About_Matrix_reports@crorg65.hlp>main 5 Creating Matrix reports=crg_Creating_Matrix_reports@crorg65.hlp>2nd 3 Generating report output 4 About report output=crg_About_report_output@crorg65.hlp>main 4 Setting Report Generator options=crg_Setting_Report_Generator_options@crorg65.hlp>2nd 4 Starting Report Generator=crg_Starting_Report_Generator@crorg65.hlp>2nd 4 Running generated reports=crg_Running_generated_reports@crorg65.hlp>2nd 4 Converting generated reports=crg_Converting_generated_reports@crorg65.hlp>2nd 4 Distributing generated Oracle Reports applications=crg_Distributing_generated_Oracle_Reports_applications@crorg65.hlp>2nd 3 Adding report objects 4 Adding parameters 5 About parameters=crg_About_parameters@crorg65.hlp>main 5 Creating arguments=crg_Creating_arguments@crorg65.hlp>2nd 5 Creating allowable values for arguments=crg_Creating_allowable_values_for_arguments@crorg65.hlp>2nd 5 Creating lists of values for generated parameters=crg_Creating_lists_of_values_for_generated_parameters@crorg65.hlp>2nd 5 Validating values entered in generated parameters=crg_Validating_values_entered_in_generated_parameters@crorg65.hlp>2nd 5 Combining parameter validation types=crg_Combining_parameter_validation_types@crorg65.hlp>2nd 5 Using generated parameters to restrict report data=crg_Using_generated_parameters_to_restrict_report_data@crorg65.hlp>2nd 5 Using generated parameters to exchange data between modules=crg_Using_generated_parameters_to_exchange_data_between_modules@crorg65.hlp>2nd 5 Creating parameters in template reports=crg_Creating_parameters_in_ template_reports@crorg65.hlp>2nd 4 Adding summaries 5 Adding computed summary items 6 About computed summary items=crg_About_computed_summary_items@crorg65.hlp>main 6 Creating computed summary items=crg_Creating_computed_summary_items@crorg65.hlp>2nd 5 Adding SQL aggregate summary items 6 About SQL aggregate summary items=crg_About_SQL_aggregate_summary_items@crorg65.hlp>main 6 Creating SQL aggregate summary items=crg_Creating_SQL_aggregate_summary_items@crorg65.hlp>2nd 4 Adding formula items 5 About formula items=crg_About_formula_items@crorg65.hlp>main 5 Creating formula items=crg_Creating_formula_items@crorg65.hlp>2nd 4 Adding item groups 5 About item groups=crg_About_item_groups@crorg65.hlp>2nd 4 Adding objects to HTML and PDF report output 5 Adding bookmarks 6 About bookmarks=crg_About_bookmarks_in_HTML_and_PDF_report_output@crorg65.hlp>main 6 Creating bookmarks for repository items=crg_Creating_HTML_and_PDF_bookmarks_for_repository_items@crorg65.hlp>2nd 6 Creating bookmarks for template objects=crg_Creating_HTML_and_PDF_bookmarks_for_Template_objects@crorg65.hlp>2nd 5 Adding hyperlinks 6 About hyperlinks=crg_About_hyperlinks_in_HTML_and_PDF_report_output@crorg65.hlp>main 6 Creating hyperlinks for repository items=crg_Creating_HTML_and_PDF_hyperlinks_for_repository_items@crorg65.hlp>2nd 6 Creating hyperlinks for template objects=crg_Creating_HTML_and_PDF_hyperlinks_for_Template_objects@crorg65.hlp>2nd 6 Creating tags for repository items=crg_Creating_HTML_and_PDF_tags_for_repository_items@crorg65.hlp>2nd 6 Creating tags for template objects=crg_Creating_HTML_and_PDF_tags_for_Template_objects@crorg65.hlp>2nd 5 Adding PDF command links 5 About PDF command links=crg_About_command_links_in_PDF_report_output@crorg65.hlp>main 6 Creating PDF command links for repository items=crg_Creating_PDF_command_links_for_repository_items@crorg65.hlp>2nd 6 Creating PDF command links for template objects=crg_Creating_PDF_command_links_for_Template_objects@crorg65.hlp>2nd 4 Creating HTML headers and footers=crg_Creating_HTML_headers_and_footers@crorg65.hlp>2nd 4 Adding headers and footers 5 Creating header and trailer pages=crg_Creating_header_and_trailer_pages@crorg65.hlp>2nd 5 Creating page headers and footers=crg_Creating_page_headers_and_footers@crorg65.hlp>2nd 5 Creating group headers=crg_Creating_group_headers@crorg65.hlp>2nd 4 Adding graphical objects 5 Adding boilerplate text=crg_Adding_boilerplate_text@crorg65.hlp>2nd 5 Adding images=crg_Adding_images@crorg65.hlp>2nd 5 Adding buttons 6 Adding buttons to display multimedia objects=crg_Adding_buttons_to_display_multimedia_objects@crorg65.hlp>2nd 6 Adding buttons to call PL/SQL functions and procedures=crg_Adding_buttons_to_call_PL_SQL_functions_and_procedures@crorg65.hlp>2nd 6 Adding buttons to call other reports=crg_Adding_buttons_to_call_other_reports@crorg65.hlp>2nd 4 Adding journaling information 5 Displaying journaling information in generated reports=crg_Displaying_journaling_information_in_generated_reports@crorg65.hlp>2nd ;3 Displaying repository property information ;4 Displaying repository objects=crg_Displaying_repository_objects@crorg65.hlp>2nd 3 Enhancing query generation 4 Changing query names=crg_Changing_query_names@crorg65.hlp>2nd 4 Changing table and column aliases in queries=crg_Changing_table_and_column_aliases_in_queries@crorg65.hlp>2nd 4 Selecting specific data using WHERE clauses=crg_Selecting_specific_data_using_WHERE_clauses@crorg65.hlp>2nd 4 Selecting specific data using HAVING clauses=crg_Selecting_specific_data_using_HAVING_clauses@crorg65.hlp>2nd 4 Specifying the maximum number of rows displayed per page=crg_Specifying_the_maximum_number_of_rows_displayed_per_page@crorg65.hlp>2nd 4 Removing duplicate rows=crg_Removing_duplicate_rows@crorg65.hlp>2nd 4 Outer joins 5 About including outer joins in lookup links=crg_About_including_outer_joins_in_lookup_links@crorg65.hlp>main 5 Including outer joins in lookup links=crg_Including_outer_joins_in_lookup_links@crorg65.hlp>2nd 4 Hierarchical data 5 About displaying hierarchical data=crg_About_displaying_hierarchical_data@crorg65.hlp>main 5 Displaying hierarchical data=crg_Displaying_hierarchical_data@crorg65.hlp>2nd 4 Merging queries 5 About merging master and detail queries=crg_About_merging_master_and_detail_queries@crorg65.hlp>main 5 Merging master and detail queries=crg_Merging_master_and_detail_queries@crorg65.hlp>2nd 4 Combining the results of queries 5 About combining the results of queries=crg_About_combining_the_results_of_queries@crorg65.hlp>main 5 Combining the results of queries=crg_Combining_the_results_of_queries@crorg65.hlp>2nd 4 Sub-queries 5 About sub-queries=crg_About_sub_queries@crorg65.hlp>main 5 Adding sub-queries to restrict data=crg_Adding_sub_queries_to_restrict_data@crorg65.hlp>2nd 3 Customizing report layout and appearance 4 Customizing report layout and appearance using template reports=crg_Customizing_report_layout_and_appearance_using_template_reports@crorg65.hlp>2nd 4 Customizing report layout and appearance using Report Generator preferences=crg_Customizing_report_layout_and_appearance_using_Report_Generator_preferences@crorg65.hlp>2nd 3 Generating Year 2000 compliant applications 4 About the Year 2000 (Y2K) problem=d2kg_AbouttheYear2000Y2Kproblem@gencom65.hlp>main 4 About Y2K-compliant date format masks=d2kg_AboutY2Kcompliantdateformatmasks@gencom65.hlp>main 4 About Report Generator and Y2K compliance=d2kg_AboutReportGeneratorandY2Kcompliance@gencom65.hlp>main 3 Using application logic and Report Generator 4 About application logic and Report Generator=crg_AboutapplicationlogicandReportGenerator@crorg65.hlp>main 4 About generated application logic created by Report Generator=crg_AboutgeneratedapplicationlogiccreatedbyReportGenerator@crorg65.hlp>main 4 About user-modified generated application logic and Report Generator=crg_AboutusermodifiedgeneratedapplicationlogicandReportGenerator@crorg65.hlp>main 4 Modifying generated application logic created by Report Generator=crg_ModifyinggeneratedapplicationlogiccreatedbyReportGenerator@crorg65.hlp>2nd 4 Capturing application logic from Oracle Reports applications=crg_CapturingapplicationlogicfromOracleReportsapplications@crorg65.hlp>2nd 4 About user-defined application logic and Report Generator=crg_AboutuserdefinedapplicationlogicandReportGenerator@crorg65.hlp>main 4 Entering user-defined event code for Report Generator=crg_EnteringuserdefinedeventcodeforReportGenerator@crorg65.hlp>2nd 4 Entering user-defined named routines for Report Generator=crg_EnteringuserdefinednamedroutinesforReportGenerator@crorg65.hlp>2nd 4 Modifying user-defined application logic for Report Generator=crg_ModifyinguserdefinedapplicationlogicforReportGenerator@crorg65.hlp>2nd 4 About template application logic and Report Generator=crg_AbouttemplateapplicationlogicandReportGenerator@crorg65.hlp>main 4 Entering template event code for Report Generator=crg_EnteringtemplateeventcodeforReportGenerator@crorg65.hlp>2nd 4 Entering template named routines for Report Generator=crg_EnteringtemplatenamedroutinesforReportGenerator@crorg65.hlp>2nd 4 Event code generated by Report Generator=idh_crg_Event_code_generated_by_Report_Generator@crorg65.hlp>main 4 Alphabetical list of Report Generator events=crg_AlphabeticallistofReportGeneratorevents@crorg65.hlp>category 5 After Parameter Form event=idh_crg_After_Parameter_Form_event@crorg65.hlp>applogic 5 After Report event=idh_crg_After_Report_event@crorg65.hlp>applogic 5 Before Parameter Form event=idh_crg_Before_Parameter_Form_event@crorg65.hlp>applogic 5 Before Report event=idh_crg_Before_Report_event@crorg65.hlp>applogic 5 Between Pages event=idh_crg_Between_Pages_event@crorg65.hlp>applogic 5 Drilldown event=idh_crg_Drill_down_event@crorg65.hlp>applogic 5 Format Trigger event=idh_crg_Format_Trigger_event@crorg65.hlp>applogic 5 Formular event=idh_crg_Formular_event@crorg65.hlp>applogic 5 Parameter Validation event=idh_crg_Parameter_Validation_event@crorg65.hlp>applogic 3 Storing files in the repository and the Oracle Designer Generators 4 About repository file storage and the Oracle Designer Generators=d2kg_AboutrepositoryfilestorageandtheOracleDesignerGenerators@gencom65.hlp>main 4 About storing files in the repository for use during generation=d2kg_Aboutstoringfilesintherepositoryforuseduringgeneration@gencom65.hlp>main 4 About storing generated files in the repository after generation=d2kg_Aboutstoringgeneratedfilesintherepositoryaftergeneration@gencom65.hlp>main 4 Using files stored in the repository during generation=d2kg_Usingfilesstoredintherepositoryduringgeneration@gencom65.hlp>main 4 Storing generated files in the repository after generation=d2kg_Storinggeneratedfilesintherepositoryaftergeneration@gencom65.hlp>main 4 About capturing repository definitions from files stored in the repository=d2kg_Aboutcapturingrepositorydefinitionsfromfilesstoredintherepository@gencom65.hlp>main 4 Capturing repository definitions from files stored in the repository=d2kg_Capturingrepositorydefinitionsfromfilesstoredintherepository@gencom65.hlp>main 3 Using the Oracle Designer Generators with a versioned repository 4 Versioned Repositories for users with experience of the Oracle Designer Generators in non-versioned environments=d2kg_VersionedRepositoriesforuserswithexperienceoftheOracleDesignerGeneratorsinnonversionedenvironments@gencom65.hlp>main 4 Creating and updating repository objects during generation and design capture=d2kg_Creatingandupdatingrepositoryobjectsduringgenerationanddesigncapture@gencom65.hlp>main 4 When are repository objects not updated during generation and design capture=d2kg_Whenarerepositoryobjectsnotupdatedduringgenerationanddesigncapture@gencom65.hlp>main 4 Generating applications from a versioned repository=d2kg_Generatingapplicationsfromaversionedrepository@gencom65.hlp>main 4 Capturing applications into a versioned repository=d2kg_Capturingapplicationsintoaversionedrepository@gencom65.hlp>main 3 Using Oracle Forms/Reports, Oracle Designer, and Oracle Repository together for increased productivity 4 About using Oracle Forms/Reports, Oracle Designer, and Oracle Repository together for increased productivity=d2kg_AboutusingOracleFormsReportsOracleDesignerandOracleRepositorytogetherforincreasedproductivity@gencom65.hlp 4 Using Oracle Repository to source control Oracle Forms/Reports files=d2kg_UsingOracleRepositorytosourcecontrolOracleFormsReportsfiles@gencom65.hlp 3 Generated reports and PL/SQL library modules 4 About generated reports and PL/SQL library modules=crg_AboutgeneratedreportsandPLSQLlibrarymodules@crorg65.hlp>main 2 Using templates for report generation 3 About template reports=crg_About_template_reports@crorg65.hlp>main 3 Creating template reports=crg_Creating_template_reports@crorg65.hlp>2nd 3 Adding generator objects to template reports=crg_Adding_generator_objects_to_template_reports@crorg65.hlp>2nd 3 List of generator objects=crg_List_of_generator_objects@crorg65.hlp>2nd 3 Specifying template reports=crg_Specifying_template_reports@crorg65.hlp>2nd 2 Using Report Generator preferences 3 About Report Generator preferences=crg_About_Report_Generator_preferences@crorg65.hlp>main 3 Setting Report Generator preferences=crg_Setting_Report_Generator_preferences@crorg65.hlp>2nd 3 Report Generator preferences - organized alphabetically=crg_Report_Generator_preferences_organized_alphabetically@crorg65.hlp>category 3 Report Generator preferences - organized by category 4 All categories=crg_Report_Generator_preferences_organized_by_category@crorg65.hlp>main 4 Data Model Object preferences=crg_Report_Generator_Preferences_Data_Model_Objects@crorg65.hlp>main 4 Field Labels preferences=crg_Report_Generator_Preferences_Field_Labels@crorg65.hlp>main 4 Field Layout preferences=crg_Report_Generator_Preferences_Field_Layout@crorg65.hlp>main 4 Group Layout preferences=crg_Report_Generator_Preferences_Group_Layout@crorg65.hlp>main 4 HTML Deployment preferences=crg_HTML_deployment_preferences@crorg65.hlp>main 4 Item Group Titles preferences=crg_Report_Generator_Preferences_Item_Group_Titles@crorg65.hlp>main 4 Journal Columns preferences=crg_Report_Generator_Preferences_Journal_Columns@crorg65.hlp>main 4 Parameters preferences=crg_Report_Generator_Preferences_Parameters@crorg65.hlp>main 4 Queries and PL/SQL preferences=crg_Report_Generator_Preferences_Queries_and_PLSQL@crorg65.hlp>main 4 Report-level Objects preferences=crg_Report_Generator_Preferences_Report_Level_Objects@crorg65.hlp>main 4 Templates preferences=crg_Report_Generator_Preferences_Templates@crorg65.hlp>main 2 Design capture of existing reports 3 About design capture=crg_About_design_capture@crorg65.hlp>main 3 About captured report modules=crg_About_captured_report_modules@crorg65.hlp>main 3 Capturing existing Oracle Reports applications into the repository=crg_Capturing_existing_Oracle_Reports_applications_into_the_repository@crorg65.hlp>2nd 2 Oracle Designer repository properties used by Report Generator 3 Application system properties=crg_application_system@crorg65.hlp>2nd-wide 3 Module properties=crg_module@crorg65.hlp>2nd-wide 3 Argument properties=crg_module_argument@crorg65.hlp>2nd-wide 3 Module component properties=crg_module_component@crorg65.hlp>2nd-wide 3 Table usage properties=crg_table_usage@crorg65.hlp>2nd-wide 3 Item properties=crg_item@crorg65.hlp>2nd-wide 3 Item group properties=crg_item_group@crorg65.hlp>2nd-wide 3 Action item properties=crg_action_items@crorg65.hlp>2nd-wide 3 Window properties=crg_window@crorg65.hlp>2nd-wide 2 Report Generator dialog boxes 3 Generate Report dialog box=IDH_crg_Generate_Report_dialog_box@crorg65.hlp>2nd 3 Report Generator Options dialog box=IDH_crg_Report_Generator_Options_dialog_box@crorg65.hlp>2nd 3 Capture Report Design dialog box=IDH_crg_Capture_Report_Design_dialog_box@crorg65.hlp>2nd 3 Capture Reports Design Options dialog box=IDH_crg_Report_Design_Capture_Options_dialog_box@crorg65.hlp>2nd 3 Reports Capture Application Logic dialog box=IDH_crg_Reports_Capture_Application_Logic_dialog_box@crorg65.hlp>2nd 3 Reports Capture Application Logic Options dialog box=IDH_crg_Reports_Capture_Application_Logic_Options_dialog_box@crorg65.hlp>2nd 2 Oracle Reports help system 3 Start Oracle Reports help system=cr_StartingtheOracleReportsHelpSystem@crorg65.hlp>main