http://reports.cyriouswiki.com/ 2026-07-26T05:21:25+00:00 http://reports.cyriouswiki.com/ http://reports.cyriouswiki.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2019-01-17T09:04:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/adding_the_original_report_location_to_a_report?rev=1547733854&do=diff Explanation For support purposes, it is desirable to know the source of any report and whether that report is one of the Cyrious standard reports or a customized report that was developed for a specific user. While Crystal Reports supports pulling the file name and location of the RPT file, this is not helpful in determining this because: text/html 2019-01-17T09:04:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/ar_detail_report_standard?rev=1547733854&do=diff Purpose The report is used for Accounts Receivable management. It summarizes all the balance outstanding for each company. Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: text/html 2019-01-17T09:04:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/ar_summary_report_standard?rev=1547733854&do=diff Purpose The report is used for Accounts Receivable management. It summarizes all the balance outstanding for each company. Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: text/html 2019-01-17T09:04:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/control_specific_issues_with_crystal_reports?rev=1547733855&do=diff Accessing System Option Information Often you may need to access options that are configured in Control. Rather than access them from the database (which is possible through the UserOptions table), which can be difficult, you can “ask” Control for the information directly. text/html 2019-01-17T09:04:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/crystal_reports_repository?rev=1547733855&do=diff {$page} Standard Headers Cyrious implements 8 standard page headers that should be used on all reports, excluding perhaps the Invoice and Estimate reports. For aesthetic reasons, the Invoice and Estimate will probably not use the standard header. text/html 2019-01-17T09:04:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/deposits_made_report_standard?rev=1547733855&do=diff Purpose This report provides a breakdown of all of the payments by deposit made (as determined using the Make Deposits feature in Control). Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: text/html 2019-01-17T09:04:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/dynamically_load_reports_from_a_file_structure?rev=1547733856&do=diff ={$page}= Many users have custom reports they have developed in Word or Crystal Reports (or had developed for them). The process of adding these reports to the menu has involved multiple steps that must be repeated for every report or for report changes. text/html 2019-01-17T09:04:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/estimate_report_standard?rev=1547733856&do=diff Estimate Report Purpose This is the primary estimate or quotation report. Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: * The Header Record (TransHeader) text/html 2019-01-17T09:04:16+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/gl_listing_report_standard?rev=1547733856&do=diff Purpose This report provides the GL information for an particular Order, Customer, Activity Type, GL Account, or time-period. This information is provided in Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: text/html 2019-01-17T09:04:17+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/historical_ar_report_standard?rev=1547733857&do=diff Purpose The report is used for printing Historical Accounts Receivable reports. It is similar in look to the A/R Detail report, but the source of the A/Rs is the G/L records rather than the orders (since the orders may have changed). It also does not break the A/Rs into their corresponding Ages. text/html 2019-01-18T13:04:33+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/home?rev=1547834673&do=diff This wiki was created to provide Crystal Report Designers with the information used in designing reports for Cyrious Control and Cyrious SMS. Note: This guide is NOT designed to teach Crystal Reports. It is simply a repository of information a skilled Crystal Report Programmer could use to effectively develop reports for Cyrious SMS and Control. text/html 2019-01-17T09:04:17+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/how_to_create_a_dsn_file?rev=1547733857&do=diff This page describes how to create a DSN file, which will allow you to modify reports through Crystal Reports. Concept In order to create a custom report or modify a standard report in Crystal Reports, you will need to establish a link between your report and your Control database. This link is called an ODBC (Open Database Connection) link. It allows you to communicate with your database so you can pull tables and fields directly out of your database onto your report. The ODBC is stored in a .… text/html 2019-01-17T09:04:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/invoice_report_standard?rev=1547733858&do=diff Invoice Report Purpose This is the primary invoice report. Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: * The Header Record (TransHeader) text/html 2019-01-17T09:04:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/orders_placed_between_report_standard?rev=1547733858&do=diff {$page} Purpose This report shows a list of orders that were placed, marked built, marked sale, closed, or voided between a specific time. It also shows adjustments to orders at those stages (or later stages). Information Structure Because the report also shows adjustments to orders, the data must be pulled from the Ledger and not from the TransHeader table. text/html 2019-01-17T09:04:18+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/report_rules_fx_functions_and_system_parameters?rev=1547733858&do=diff {$page} System Report Rules * Any text used inside a formula must be wrapped in the translate() function. This function can be found in the Crystal Repository. * Any Date or DateTime field must be set to use the System Default Short Format. * text/html 2019-01-17T09:04:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/sales_by_x_report_standard?rev=1547733859&do=diff {$page} The Reports Menu in Control allows you to choose nine options for the report: Note that the “Date” menu option expanded by the “Show Detail” button requires the selection of two dates for the Beginning and Ending dates which are used for filtering values for the EntryDateTime from the Ledger table. text/html 2019-01-17T09:04:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/sales_report_standard?rev=1547733859&do=diff {$page} Purpose This report shows Ledger activity occuring during a specific time frame. The report reflects both new sales as well as adjustments to previous sales. All sales numbers are pulled from the GL view which filters the ledger by OffBalanceSheet 0. text/html 2019-01-17T09:04:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/setting_default_values?rev=1547733859&do=diff Description Even though the default values in Crystal Reports are all replaced by Control, the default values for Crystal Reports can make a HUGE difference in report speed with the DLLs currently used by Control to open them. When opened, reports pull the data from the database using the default settings text/html 2019-01-17T09:04:19+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/space.template.report_template?rev=1547733859&do=diff Purpose This report ... Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: * Top level (table) * Sub level (table) * sub-sub level (table) text/html 2019-01-17T09:04:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/using_barcode_fonts_on_a_crystal_report?rev=1547733860&do=diff Overview Barcode fonts may be used on Crystal Reports to allow users to scan barcode information into external programs or devices. Requirements * Must have the relevant barcode fonts installed on each system in the C:\Windows\Fonts folder. * Must have the barcode dll installed on each system in the C:\Windows\System32\ for 32-bit or C:\Windows\SysWow64 for 64-bit. text/html 2019-01-17T09:04:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/using_crystal_reports_with_cyrious_programs?rev=1547733860&do=diff Overview Purpose Cyrious utilizes a third-party reporting engine known as Crystal Reports for the majority of reports that area available within Control. Crystal Reports is a publicly available and can be purchased directly from many online vendors or directly from SAP. If you wish to create your own reports and have them accessible within Control you will need to utilize Crystal Reports for this task. text/html 2019-01-17T09:04:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/wip_and_built_report_standard?rev=1547733860&do=diff {$page} Purpose The is one of the primary reports used for production management. The organization (detail) of this report is by Line Item; it is used when line items are routed independently and the entire order is not routed together. Information Structure text/html 2019-01-17T09:04:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/wip_by_line_item_report_standard?rev=1547733860&do=diff {$page} Purpose The is one of the primary reports used for production management. The organization (detail) of this report is by Line Item; it is used when line items are routed independently and the entire order is not routed together. Information Structure text/html 2019-01-17T09:04:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://reports.cyriouswiki.com/work_order_report_standard?rev=1547733861&do=diff Work Order Report Purpose This is the primary invoice report. Information Structure The report shows, in logical hierarchy, information from the following different sources and the table the information is contained within: * The Header Record (TransHeader)