| Article Information |
Recommended label printer
Q: What printer do we recommend for the label printing? Client has Seiko 100 S2 and wants to use it. We have tried it on two versions of Focus and it DOES NOT WORK BUT it works with the Seiko software that came with it.
A: Older generation label printers work only with the software that comes with the printer. All the label reports in Focus Reports version 5 are designed for Dymo LabelWriter printers. Focus Reports will work with other label printers that have a standard Windows (... more)
|
Canvas does not support drawing
This error can occur when no default printer is installed or the driver for the printer is defective. Install a default printer driver or replace the defective printer driver. (... more)
|
Printing a report with a command line parameter
Beginning in version 1.3 and above Focus Reports can print a report using a command line parameter. Following is the command syntax:
For Focus Reports Standard:
\Program Files\Inborne\Reports\IReports.exe FolderID "MyReport" -print
For Focus Reports Professional:
\Program Files\Inborne\Reports\IReportsDev.exe FolderID "MyReport" -print
Where:
- FolderID is the folder ID number where the report is located. The folder ID may be found in the Report Explorer: Right click the (... more)
|
Only one user can see Focus
Q: You can see focus reports in MediSoft only if you are logged on under the main windows admin account. If you're logged in remotely as any other user, connected to the same computer, you cannot see focus. We'd like for everyone to be able to see them. How can we do this?
A: Install Focus Reports while logged in as the user who cannot see Focus Reports on the MediSoft menu. The MediSoft menu settings are stored for each Windows user login. Since these settings are not shared between (... more)
|
tblFolders : Error 35769 : Error code 35769 is unknown
This error should only occur after a new install of Report Server. If this error occured after upgrading Report Server please call technical support and do not continue with the instructions below.
The problem is caused by a blank tblFolders.adt file. In order to the correct the problem:
1) Download the zipped file located at http://www.rfmdl.com/tblfolder.zip
2) Unzip the downloaded file and copy the contents into the ReportDefs folder that is located within the Medisoft (... more)
|
Using Focus Reports with multiple versions of MediSoft
Reports designed with Focus Reports version 4 are compatible with all supported versions of MediSoft (7, 8, 9, 10 and 11) with no special changes required. These instructions are provided for use when testing or troubleshooting multiple versions of MediSoft data on the same computer. As a rule, only Focus Reports dealers will need to do this.
Assumptions
You are using Focus Reports version 4 or above
Different versions of MediSoft data can be found in different root data folders
(... more)
|
Error: Failed to get data for ItemLinkCount
MediSoft must be launched and a practice opened before installation of Focus Reports. Launching MediSoft places an entry in the Windows registry that defines settings for the MediSoft menu. Focus Reports uses these settings to place the Focus Reports selection on the MediSoft menu.
This error can also occur of you are trying to install a version of Focus Reports that isn't as current as the version of MediSoft you're using. Make sure you are using the most current version of Focus (... more)
|
The selected practice data does not exist
This error occurs because:
1) No data exists for the selected practice
2) The user does not have sufficient rights to access the practice data
Note: This error occurs, because of the Advantage 5004 error.
(... more)
|
MediSoft/NDCMedisoft procedure code and transaction type codes
A = Procedure Charge
B = Product Charge
C = Inside Lab Charge
D = Outside Lab Charge
H = Billing Charge
I = Insurance Payment
J = Cash Co-payment
K = Check Co-payment
L = Credit Card Co-payment
M = Cash Payment
N = Check Payment
O = Credit Card Payment
P = Deductible
S = Adjustment
T = Insurance Adjustment
U = Insurance Withhold
V = Insurance Takeback Adjustment (reverse insurance payment)
Z = Comment
(... more)
|
Recycle Bin
Q: How do you empty the Focus Reports Recycle Bin?
A: Right-click on the Recycle Bin, then select Empty Recycle Bin from the context menu.
(... more)
|
Error - Invalid variant
An Invalid Variant... error when importing a report into Focus Reports indicates a problem with the report template file. This error is frequently caused by emailing a report template.
Resolve the error by getting a new copy of the report template. If sending a report by email, put the report template in a .zip file first.
(... more)
|
"Not Responding" while importing reports
When entering Focus Reports for the first time, the program imports all of the newly installed reports. All of the reports which are using customized SQL must be checked against the Medisoft database. If the current database is very large it will appear that the importing process is "not responding." One solution is to just wait for the importing to go all of the way through, which may take up to several minutes. A second solution is to:
1) Cancel out of the import process (Ctrl + (... more)
|
MediSoft versions supported by Focus Reports
Q: Will Focus Reports work with brand new MediSoft version 10?
A: Focus Reports version 3 works with MediSoft versions 7, 8, 9 and 10, including all of the service packs.
(... more)
|
Unable to import a report into the Focus Reports Developer: "Could not convert variant of type (null) into type (integer)"
Q: When trying to import a report into Focus Reports Developer v2.1 Build 221, I receive the following message:
"Could not convert variant of type (null) into type (integer)"
A: This error usually indicates a problem like file damage in the report template. Get a new copy of the report and reattempt to import the template.
(... more)
|
RAP code to calculate a patient's age
How to create a variable field on the visual designer and calculate a patient's age:
Place a variable on the visual design screen
Display the Report Tree toolbar (View|Toolbars|Report Tree), right click the new variable and select Rename from the context menu. Rename the variable to vAge.
Right click the variable and select Calculations from the context menu.
Copy and paste the following code into the code space in the Calculation window:
start copy on line below--
{Calculates (... more)
|
MediSoft transaction documentation (note) type codes
F= Ambulance Certification
H= Chiropractic Justification
C= Diagnosis Report
2= Emc: Added Ambulance Information
1= Emc: Anesthesia Time
3= Emc: Podiatry Class Finding Codes
5= Emc: Radiation Therapy,Actaul Dates of Service
6= Emc: Special Condition
4= Emc: Unclassified Provider Description
B= Explanation of Benefits (MSP or COB)
Y= Multiple Documentation Items
D= Operative Note
Z= Other
J= Oxygen Prescription
E= PEN Certification
G= Physical Therapy Certification
I= Prosthetics/Orthotic (... more)
|
Focus Reports selection disappears from the MediSoft/NDCMedisoft menu
Symptom: Focus Reports menu selection disappears from MediSoft menu.
Background: Focus Reports menu information is stored in the MediSoft section of the Windows registry. When MediSoft opens, the program reads its menu settings from the registry. Later, when MediSoft closes, it writes its menu settings to the registry. Running Focus Reports from the MediSoft menu (this is normally how the program is launched), menu settings saved to the registry by Focus Reports are overwritten by (... more)
|
How to create a report showing payments on procedure codes by provider
Q: How do I make a report showing how much was collected for each procedure code by provider regardless of charge date of service? For instance, I need to know how much Dr A received during March for procedure code 99213. I know I need to subtotal by provider and procedure code but I can't seem to find the right fields to get the desired results. Most of your reports are based on the charge date of service.
A: The report needs to be based on the payment transactions in the transaction (... more)
|
Where is the transaction notes field found?
Q: I just updated our Focus Reports to the Professional product so that I can more easily custom create reports. Currently, In transaction entry, you can add notes. These notes state that they are for internal use only. However, our collection department needs to have these notes printed along with the aging information. I am unable to locate this exact field.
A: The data filed is found in the transaction table -- The field's name is Documentation.
(... more)
|
Error - MediSoft program directory cannot be determined
The source of this error is a missing Windows Registry entry that specifies the location of the MediSoft program files. Focus Reports uses this information to locate a file named lastcon.cfg. This file tells Focus Reports whether the MediSoft data tables should be opened in local (single-user, on the local computer) mode or remote (client/server, on the database server) mode.
To correct this error, you can manually place an entry in the Windows registry. Caution: Improper editing of the (... more)
|
Error 7200, Invalid SQL Statement
An error 7200 will occur when a data query is invalid. Causes of this error can include incorrectly formed SQL syntax, an invalid comparison operator in a query, and missing comparison criteria.
Note for Focus Reports Version 2: When a user does not have Office Hours appointment files, importing reports that use these files will produce a 7200 error. Reports affected include those in the Focus on Chiropractic group of reports.
Check these things in the query:
If you are (... more)
|
Focus Reports disappears from MediSoft/NDCMedisoft menu - Get it back automatically (for ASP hosted environments)
In Focus Reports version 2 and above you can put the Focus Reports selection on the menu automatically every time a user logs in.
When running an ASP-style hosted server, use the setmmenu.exe program to automatically place the Focus Reports menu selection on the MediSoft menu. Setmmenu.exe makes the necessary Windows registry changes for the menu, then can launch a program when it's finished.
Set the program to run on login to this command line:
setmmenu.exe (space) (... more)
|
Print Engine will not save registration information
Symptom: Focus Reports Print Engine requires registration information to be entered every time the report explorer is launched.
Background: Focus Reports registration information is saved to the Windows registry. The print engine checks the Windows registry for registration information when it is launched. If no registration is found, the registration entry window displays and requires entry of registration information.
Solution: Some network system administrators disable Windows registry (... more)
|
Add additional practice after installing Focus Reports
Q: How do i get to the screen that asks what practices to attach Focus Reports to? A new practice added after installation is showing Focus Reports on task bar but not additional tab fields in patient/case etc and reports are saying no data available.
A: Focus Reports automatically works with all MediSoft data sets. To use a different MediSoft data set in Focus Reports, close Focus Reports, select File > Open Practice in MediSoft, open the desired practice, then reopen Focus Reports.
(... more)
|
Error 7008 installing Money Matters
Money Matters must be installed in the computer where your MediSoft data files reside and all users must exit MediSoft before beginning the installation. This is required because two parts of the installation routine open the Advantage database table in Local Server mode. First to discover the data sets available on the server, then to install the custom patient and custom case data screens. (... more)
|
Error 6420 - The discovery process for the Advantage Database Server failed
Background
Focus Reports uses the Advantage Database Server to protect data from network-induced problems and to speed access to the data. Focus Reports software must discover the database server. To do this, a message is sent across the network to the other computers. The database server computer responds with information to allow Focus Reports to connect to the database server. If this response is not received, the 6420 error is generated.
Note: This error can be caused when (... more)
|
MediSoft custom patient and case data tables
MWCPD
Stores data entered in fields on custom patient information window
MWCCD
Stores data entered for custom case data window
MWOPT
Has controls to determine whether a tab is displayed for a custom patient data window or custom case data window
MWSCD
Contains the definition for the custom patient data window and custom case data window
MWSCR
Custom patient and case data window name, size, and version information
Custom patient and case definitions and (... more)
|
Focus Reports vanishes from MediSoft menu
Q: I have installed the Print Engine at my client's office (Medisoft 7.01). Reports are present and work. After some time, the menu item, on the Medisoft menu, disappears and they can not find their reports. What causes this? and, How can I prevent it from happening? They only run their reports monthly, so it takes less than a month to disappear. Exactly when it goes away is unclear at this time.
A: The Focus Reports selection on the MediSoft menu is controlled by a Windows registry (... more)
|
Is Focus Reports compatible with MediSoft version 8?
Focus Reports is compatible with MediSoft version 8 when properly installed and configured.
MediSoft version 6 or 7 must be uninstalled before installing version 8
MediSoft version 8 must be launched, the root data path selected, and a practice opened before installing Focus Reports
Focus Reports must be reinstalled, selecting the installation procedure for MediSoft version 7 (in Focus Reports version 1.32 and earlier) or MediSoft version 8 (in Focus Reports version version 1.33 and (... more)
|
Focus Reports System Requirements
Q: What are the minimum operating system requirements to run the Focus Reports?
A: Since Focus Reports runs with MediSoft software and uses similar technology, the system requirements (computer, operating system, network) are the same.
(... more)
|
How to remove Focus Reports registration
Focus Reports registration is stored in the Windows registry. Registration information can be removed by editing the registry.
Warning: It is possible to make registry setting changes that will permanently disable a computer. Do not attempt these changes if you do not have a thorough knowledge of the registry and the regedit program.
Open regedit
Browse to HKEY_LOCAL_MACHINE/Software/Inborne/Registration
Click to select the name of the Focus Reports product for which you want to remove (... more)
|
Using a new printer with Focus Reports
Focus Reports will print reports on any Windows-compatible printer installed and usable on the computer running Focus Reports. This includes local and network printers.
The local computer's default printer is used as the default printer for Focus Reports. An alternate printer can be selected at the time a report is printed.
If a printer is not available for printing a report in Focus Reports, verify that the Windows printer driver is installed an/or reinstall the driver. (... more)
|
Editing standard MediSoft look-alike reports
Focus Reports Developer can be used to customize standard MediSoft reports. Versions 1.3 and above of the developer include MediSoft report look-alike formats that may be found in the MediSoft Reports folder in the report explorer.
Any part of these reports may be edited to customize the report for a specific practice's needs. A Focus Reports Print Engine is required to print customized MediSoft look-alike reports on an end-user's computer. (... more)
|
What is a subreport?
A subreport can be used for many things:
1. A "report within a report" to print multiple reports at once. Create a subreport for each report you want to add.
2. The detail portion of a master/detail report. Use a subreport to present data in a way that isn't possible in the main report. Subreports use different queries and permit unique data manipulation.
3. The drill-down portion of a drill-down report. Focus Reports supports drill-down reports -- Put the detail portion of the report into a (... more)
|
How can I print a Flash Report for the prior month or year?
Date filters for all Flash Reports are chosen automatically based on the current date. A Flash Report can be printed for a prior period by changing the date on the computer running the Advantage Database server. Changing the date on a client computer has no effect in a networked MediSoft environment -- The date must be changed on the database server.
Note: In a single-user environment there is not separate database server. Change the date on the client computer. (... more)
|
Invalid template error
Invalid template errors are caused by attempting to import a report that was created with a version of Focus Reports Developer that is newer than the Focus Reports Print Engine.
Install an updated version of the Focus Reports Print Engine. (... more)
|
Primary Insurance Aging Summary (MediSoft look-alike report) balances on Focus Reports version of report and MediSoft version of report do not match
The MediSoft version of this report does not include guarantor payments. The Focus Reports version of the report subtracts guarantor payments from the total due.
When an insurance carrier has completely paid a charge, the Complete check box must be checked to remove a paid charge from the report.
For more information, see the MediSoft Look-Alike Report Release Notes file included with Focus Reports Developer. This document can be found on the Start > Programs > Inborne Technology menu. (... more)
|
Printing data selection criteria on a report or title page
Data filters used to select information for a report may be printed on a report cover page or in the heading of each page of the report.
While editing a repoprt in Focus Reports Developer:
1. On the menu, click Report | Title to open a new Title band on the visual designer.
2. Right click the Title band and select New Page. This will separate the title page information from the body of the report if desired.
3. Place a Memo field in the title band and be certain the field is named Memo1. (... more)
|
Canvas does not allow drawing error
This is a Windows error caused by low GDI (Graphic Device Interface) resources. This error can occur when too many programs are open or the open programs are using a large amount of Windows resources. The MediSoft Case window is an example of a particularly large user of Windows resources. The MediSoft Case window uses a large amount of resources because of the number of controls (data fields) in the window. This is not a MediSoft deficiency, but a result of the information necessary in the (... more)
|
Creating a chart or graph
Focus Reports Developer can create virtually any type of chart or graph from MediSoft data. Follow these steps to create a chart or graph:
Create queries to supply the information for the chart or graph. The result table should contain only the information to be used for the chart or graph, generally a label field and a value for each label.
Place a DBChart component on the visual designer by clicking the DBChart button in the tool bar and clicking a band in the report.
Right-click (... more)
|
SQL error printing reports with appointment information
Problem: An SQL error occurs when printing any of the three Productivity and Retention Statistics reports in Focus on Chiropractic.
Solution: These reports use appointment information from Office Hours, the appointment scheduler included with MediSoft. Correct the problem by opening Office Hours and creating the appointment data files. (... more)
|
Error 7008
Report Explorer (Print Engine) opens properly, but trying to print or preview a report produces an error 7008.
The Focus Reports Print Engine needs to know the location of the MediSoft data files and whether the data tables are local (single-user, on the local computer) or remote (client/server, on the database server). To do this, Focus Reports reads a file in the MediSoft program folder (normally \Program Files\MediSoft\Bin) named lastcon.cfg. This file contains the text "Remote" or "Local" (... more)
|
Developer update download
Q: How do I download the latest Focus Reports Developer update?
A: We offer software downloads for dealers on our Dealer Zone page. End-users can call Inborne Technology support at (480) 497-2442 for information. (... more)
|
Search field not showing drop down box
Q: How is it determined which fields have the drop down box "...." indicated on the search screen? Also, is there a way to customize the look of the search screen?
A: Focus Reports determines internally which fields will have a selection window available. The fields that are supported are the fields that ask for a table-driven code. These fields include patient chart number, provider number, procedure code, and others. An example of unsupported fields include the patient indicator and (... more)
|
Printing to one off label printer
Q: Medisoft software only accounts for full sheets of labels being printed. We use a Seiko SLP printer, it has a roll of labels and you print one at a time. After consulting with Medisoft, it seems they have no intention of supporting this kind of printer. Do you have any capability to support these printers?
A: If a printer is supported by a Windows printer driver, Focus Reports Developer will very likely be able to print a report to the printer. (... more)
|
Creating one unlock code for a package of reports
Focus Reports Developer is designed to generate one unlock code for each report. One unlock code will be required to each report in a dealer-created custom report package.
To work around this issue and create one unlock code that will work for all reports in a report package, follow these steps:
In the developer properties for each report assign the same Report ID to all reports in the package
When distributing the report package to an end-user, generate an unlock code for the first report (... more)
|
Creating a report that prints on mailing labels
Using the Report Wizard it's easy to automatically set the page size and margins for printing on standard Avery labels.
Create a new report
On the Design tab, click File | New...
Select Label Templates in the New Items window
Select the label size and style from the predefined list
Create a query and place the necessary fields in the visual designer (... more)
|
MediSoft versions supported by Focus Reports
Focus Reports works with MediSoft version 6 and above in single-user, multi-user and client/server configurations. (... more)
|
Flash report date filters
Q: How can I expand the date range of The Flash Report-YTD? I need a financial year, not a calendar year.
A: Both flash reports use a date range calculated in an SQL statement. This statement retrieves the current date and back dates the report to the beginning of the calendar year through today. If you have Focus Reports Developer you can change the date range in the SQL statement for the report to include the dates you want to see. Since the date is determined in the SQL statement, there is (... more)
|
Show all box not available
Q: If I click "Auto Search" or "Mandatory" for a field on the Search tab in the Query Designer, a box appears for me to check or uncheck. I can't get a box to appear under "Show All" for me to make a selection.
A: The Query Designer window is too narrow for the control to display in the column. Make the window wider and the check box will be available. (... more)
|
What is RAP code?
RAP code is used in Focus Reports Developer to give users a high level of control over the data included in a report and the layout of a report.
RAP is an acronym for Report Application Pascal. RAP code is very similar to Visual Pascal, the code used in the Borland Delphi software development environment. (... more)
|
No data found for this report
This error indicates that a data filter (also called a search) excluded all possible data for the report.
The likely cause of this error is that a data filter in a query is set in such a way that it excludes all data in the data MediSoft set currently in use.
Troubleshoot this error by examining the queries created for the report. To determine whether a query is improperly constructed and is eliminating wanted data, preview the query by clicking the Preview button in each data view (query) (... more)
|
How does it determine which carriers will be included in the graph for "new patient by carrier"?
Q: When running the new patient by carrier report I am getting 3 carriers and then one group, which is 53% of the new patients called "other". How does Focus Reports decide which carriers it is going to include in the graph?
A: The report determines which carriers should be placed in the Other group based upon the percentage of each carriers' "pie" slice. Any carrier that falls below an 8% threshold will be included in the Other category. The chart can be edited to reduce the threshold to (... more)
|
Developer or print engine will not open
In some cases the print engine or developer will not open after an error condition. Restart the computer and the problem will resolve. (... more)
|
Using an outer join
A join specifies how MediSoft tables relate to one another. An example of this relationship is how the transaction table relates to the patient table through a chart number.
Joins created in a Focus Reports Developer query are inner joins by default. An inner join in our patient/transaction example above would retrieve data in a result table when a record in the patient table matches (through the chart number) a record in the transaction table. Patients without recor (... more)
|
Creating a join
A Join relates data tables. If the transaction and patient table are joined, this allows any field from the transaction table and any field from the patient table to be used in a report. On the Tables tab in the query designer, select two tables for a query, the transaction and patient tables for example. In the Join column of the Selected Tables pane, click the button with the three dots to the right of the Join column. The Join window opens. The transaction and patient tables a (... more)
|
System variables
A system variable is used to print the date, time, document name, or page count. After a system variable is placed in a band in the visual designer, the content of the system variable may be edited using one of the developer's tool bars. If a drop down menu is not displayed in the tool bar area containing all the options for a system variable, display all the developer's toolbars by selecting the View | Toolbar menu.
The print format of the selected system variable is edited by right (... more)
|
Can I use Focus Reports Developer on more than one computer?
Focus Reports Developer may be used by multiple people in your organization on multiple computers to design reports. The Focus Reports Developer license agreement prohibits installation of the developer on a dealer's client's computer. (... more)
|
Will Focus Reports work with PractiSoft?
Q: Since Focus works on version 6 and 7 of MediSoft - Will it work for version 6 of PractiSoft? Is there a special file I need or special version to access reports from Version 6 of PractiSoft? A: Focus Reports works only with MediSoft Patient Accounting (... more)
|
Create Your First Report
Create your first report!
Launch MediSoft
Drop down the Focus Reports menu from the MediSoft menu
Select Report Explorer from the Focus Reports menu
The window now shown is the Report Explorer. Categories appear on the left, reports on the right
Select File | New Report from the menu
Four tabs appear in the upper left corner of the developer window: Data - Used to gather data for your report. Try the Query Wizard - I (... more)
|
Designing a data export format for Word, Excel, Access and other programs
Create a data export report format following the same procedure as for a printed report. To define the data export, from the Design tab in the developer go to the File menu and select Print to File Setup. This window permits selection of the fields to export and format to be used for the export.
Standard reports can also be adapted for export. Create the report, then define the export as above.
To export data, choose the Print to File selection in the Print window, then choose (... more)
|
Error 6316 - Advantage Client Version Newer Than Advantage Server Version
You are attempting to run Focus Reports with the wrong version of the Advantage Database Server (ADS). Focus Reports (developer and print engine) version 1.21 and above supports either ADS version 5 (standard with MediSoft version 6.x) or version 6 (standard with MediSoft version 7.x). If this error occurs in a version higher than 1.21, the wrong version of Focus Reports was installed for use with the MediSoft system on this computer.
Reinstall Focus Reports and select the correct ve (... more)
|
Insurance Pay Analysis days to pay field shows date rather than a number of days
Q: Insurance Analysis report shows dates rather than the number of days it takes an insurance carrier to pay. A: This issue is corrected in version 1.2 of this report. Focus on Managed Care version 1.2 and above have the corrected version of the report. (... more)
|
Developer (or print engine) will not export report
When attempting to export a report the developer will not display the file export window. This problem is caused by a character in the report name that Windows will not accept in a file name.
Focus Reports Developer automatically uses the report name as the default file name for an exported report. Remove these characters from your report name:
\ / : * ? " < > |
All characters above will cause this error. (... more)
|
Avoiding dublicate records in a report
Question: I need to print a report based on case data. How can I avoid duplicate records if I need to run the report based on patient chart number or patient last and first name?
Answer: Duplicates can be eliminated using the Group tab in the Query Designer window. Grouping in a query combines identical records in the result table into one record, thus eliminating duplicates.
(... more)
|
Valid query and data pipeline names
A query name is automatically assigned by Focus Reports Developer. When creating a query where the case file is the primary table, the query/datapipeline name will automatically be assigned as Case . This name is unacceptable when uusing a field from the query in a calculation because Case is a reserved word in the RAP code language.
Change the name of the query like this:
Click the Data tab to display the Data workspace.
Right click the (... more)
|
Using reports with multiple data sets
Focus Reports products can be used with multiple MediSoft data sets. To do this, open a practice in MediSoft, then launch Focus Reports from the MediSoft menu. The current MediSoft data set is used for Focus Reports. (... more)
|
Using Focus Reports with multiple versions of MediSoft
Focus Reports is compatible with MediSoft versions 6 and 7, but it cannot be installed for BOTH versions on the same computer. Reports designed with Focus Reports Developer will work with MediSoft version 6 or 7 with no changes. There is no difference in the report file created for either version. The version differences are as follows: - The executable program file for Focus Reports Developer and the Focus Reports Print Engine are MediSoft version specific. - The Advantage (... more)
|
Export dialog window will not open
Problem: Attempt to export a report format and the export window will not open. Solution: Report name contains an invalid character. Edit the report name to remove the invalid character. (... more)
|
Cannot Generate Report. Could not run program:
Cannot Generate Report. Could not run program: (Event listed here) Calculations (Calc tab) are event driven. When code entered for a calculation produces an error, this error displays. Correct the error by displaying the Calc workspace and looking for red flags in the Report Objects tree (upper left corner of screen). Follow the red flag until the offending code segment is displayed. Correct the RAP code syntax and try printing the report again. On occasion this error will d (... more)
|
Creating a data export format
Follow these steps to create a data export format in Focus Reports Developer: 1. Define a data query as with any standard report 2. Place the fields you want to export into the detail band in the visual designer 3. Click File | Print to File Setup to define the data export file 4. Choose the export format (comma delimited, tab delimited or fixed length). 5. Select the band containing the fields to be exported in the Bands list. 6. Move the desired export (... more)
|
Exporting MediSoft data to Excel, Word or Access
Focus on Data data export formats will export MediSoft data into delimited ASCII files for use in Microsoft Excel, Microsoft Word, Microsoft Access, and other programs. Each data export format is designed to export all the fields in a particular MediSoft table. After exporting data, import the data into the destination program. See the destination program's help files or user manual for more information. (... more)
|
Software registration: retrieving an unlock code from Inborne Technology registration server
Dealers purchase Focus Reports products unregistered. When a product is sold to an end-user or installed for use in the dealer's office, a registration unlock code must be generated and entered in the registration window to unlock the software. Registration is accomplished with the ProductReg program which may be found on every Focus Reports CD. Open Windows Explorer and browse the Focus Reports CD. Navigate to the \Dealer\Product Registration folder. Both the ProductReg program (... more)
|
Generate a user unlock code in developer
Use the Generate User Unlock Code window on the Developer menu to issue a unique unlock code to each purchaser of a report. User Name – Enter the customer’s name as they want it to appear in the Report Explorer. This field is not case sensitive. Characters other than letters and numerals are disregarded. Generate Unlock Code – Click this button to issue a 16 character unlock code. Copy name and Code to Clipboard – Copies information in a format that is suitable for pasti (... more)
|
Setting data filters (Query search tab)
A data filter (data selection criteria) is called a search in Focus Reports. Set data search criteria in the Query Designer window on the Search tab. 1. Select the field to use for the data filter by double-clicking the field in the Available Fields pane of the Search tab in the Query Designer window. 2. Set the operator to use for the data filter: = (equal), (not equal), (greater than), >= (greater than or equal) are standard com (... more)
|
How to create a sub report
Insert a subreport by clicking the subreport button on the Advanced Components tool bar while the visual designer workspace is displayed. The Advanced Components tool bar is not displayed in the developer by default. Click View | Toolbars | Advanced Components to display the Advanced Components toolbar. After inserting the subreport, a tab will be added at the bottom of the Design workspace for the main report and subreport. Click the subreport tab to display and edit the subrepor (... more)
|
Focus Reports Developer Installation
MediSoft should be installed prior to installation of Focus Reports Developer. Insert the Focus Reports Developer CD into the computer’s CD-ROM drive. The Focus Reports installation program should start automatically. If it does not, navigate to and run the ProductMenu.exe program on the Focus Reports CD using Windows Explorer. The user license permits Focus Reports Developer to be installed on all computers in the office of the developer owner. The developer may not be installed (... more)
|
Selecting data tables for a query
USing the query wizard or the query designer, select the primary table first, then the secondary tables that will supply supplementary information. Examples: If you are building a patient list report, the patient table whould be selected. To build a transaction-based report that also needs to include patient and case information, select the transaction table, then select the patent and case tables. (... more)
|
Import or export a data query
Focus Reports Developer permits data queries to be exported for use in other reports. This feature lets you create a query set and use it over and over in other similar reports. Export a query by clicking File | Export…on the developer menu when the Data workspace is displayed. The developer will present a default file name for the query export. Change or accept the file name and complete the export. After exporting you will see the exported query set appear in the report explorer. (... more)
|
Deploying a report
All reports created with Focus Reports Developer reside in a single report database file. The database file will be located on the database server if you are using the developer in an Advantage Database client/server environment, or on the local computer if used in a single-user setting. No matter what type of database environment is in use, reports designed with the developer must be exported to a data file and imported into the Focus Reports Print Engine on the destination computer. You (... more)
|
Author setup window
The Author Setup window is used to identify a report author and store the author password. Author setup must be done on every computer in an office that will be creating reports. Enter the same Author Name and Author Password on every computer. Author Name – It is recommended that the Author Name be set to your company name. Author Password – Enter any combination of characters. Safeguard this password to prevent other developers from having access to your report definitio (... more)
|
Setting developer properties of a report
Select (highlight) a report in the Report Explorer window. Click Developer | Developer Properties to open the Developer Properties window for the report. Developer Properties are assigned to each report. Developer properties are stored in the report definition file and are transported with a report file when it is exported from the developer and imported into a customer’s print engine. Following are descriptions for each field on the Report Information tab in the Developer Propert (... more)
|
Print to file setup
When creating a data export format, use the Print To File Setup window on the File menu specify the output format and field order of a data export file. Output formats available include comma delimited, tab delimited or fixed length. Choose the fields from each band to export by selecting the band, then selecting the field from the Control list, and moving the field to the Selected Controls list. Naming each field using the Report Tree window prior to setting up the export detai (... more)
|
Calc workspace explanation
There are two different ways of performing simple mathematical functions in Focus Reports Developer. Calculations during a data query are the easiest way to perform mathematical operations for a report. The Calc workspace (Calc tab in Focus Reports Developer) can also be used for mathematical operations. In addition to mathematical operations, data manipulation and logic operations may be performed in the Calc workspace. A type of programming code called RAP (Report Application P (... more)
|
Editing SQL statements in a data query
The SQL tab in the query designer shows the SQL statements produced as a result of the entries made in the Query Designer window. The name of the query (data pipeline) may also be changed in this window. Displayed here will be the SQL statement that will be executed to produce a result table for your report. Focus Reports Developer will allow the SQL statement to be directly edited, but this should be avoided if it is possible to produce a desired result with the Query Designer. To edit the SQL (... more)
|
Sorting data for a report
The sort tab in the query designer allows the records in a result table to be ordered. Double-click or drag and drop a field from the Available Fields window into the Sort Fields window. The default sort order is ascending – Check the Desc (z > a) box to reverse the sort order to descending. The sort order of a result table is important if data is to be grouped in a result table or on a report. (... more)
|
Using data selection questions
The Search tab in the query designer is used to select the data to be included in a result table and ultimately in a report. Double click a field or drag and drop a field into the Criteria window to create a data filter for a query. The Operator drop-down list is used to select the comparison method for the data filter: = (equal), (not equal), (greater than), >= (greater than or equal) are standard comparison operators and are all suppo (... more)
|
Simple calculations in a query
Query calculations are used for performing simple mathematical operations on query data. The Calcs tab in the query designer has different uses than the Calc workspace in Focus Reports Developer. The operations that can be performed in the Query Designer are those than are supported in both SQL and the Advantage Database. Examples include summing, counting, and result table field manipulation. Standard functions available in a calculation include Average, Count, Maximum, Minimum, and Sum. (... more)
|
Grouping in a data query
Grouping in a query allows the query to summarize information. The developer can group in the query or in the visual designer. Grouping in a query is helpful when you want to eliminate duplicate records or you want to print only summary information. When grouping the information in a query, all fields selected for inclusion in a result table must also be selected for grouping, and they must be listed in the same order. (... more)
|
Data workspace explanation
The Data tab is used to gather the information that will be used to print a report. This data gathering as called a query. Focus Reports Developer has two ways to build a query – The Query Wizard and the Query Designer. The principles of a data query are similar among all database and reporting systems. You are likely familiar with the term SQL (pronounced ess-cue-ell). SQL (meaning Structured Query Language) is a set of standard commands used to retrieve data from a database. A (... more)
|
More information Resources
After installation of Focus Reports Developer you will find an Inborne Technology selection on your Start menu. On this menu will be listed several information resources for Focus Reports Developer. Use these reference tools for additional information on specific functionality of the program (... more)
|
System Requirements
Focus Reports requires any MediSoft Patient Accounting product version 6 or above. If a computer meets MediSoft’s system requirements it may be used with Focus Reports. Focus Reports works automatically with single user and network versions of MediSoft. (... more)
|
Cannot generate report
Incorrect syntax in RAP code will cause this error. To find the offending statement, click the Calc tab in the developer and follow the red flags until you have browsed down the tree to the error. Correct the syntax. Click on another branch in the Report Bands tree and the code will be recompiled. If the syntax is correct, the red flag will change to green indicating that the compile was successful. (... more)
|
Accumulating totals with RAP code
Following is the RAP code to accumulate totals and subtotals then the totals are outside the area (normally a group) where the amounts are to be accumulated and printed: begin value := Value + (YOUR VARIABLE NAME HERE); end; Use this code by placing a variable on the visual designer screen, then right clicking the variable and entering the code above in the RAP code window. Note: Totals and subtotals are more easily accumulated by using a DBCalc field. (... more)
|
Creating a report installation CD
Software is included with Focus Reports Developer to use to create a self-running installation CD for any report or group of reports. The first step to create an installation CD is to export the report file from the developer. Open Windows Explorer and browse to the \Program File\Inborne\Reports folder and you will find the MakeInstall folder. In this folder are all the files and folders necessary to create an installation CD. We recommend that you copy all included files and folders in (... more)
|
Exporting a report and installing on another computer
All reports created with Focus Reports Developer reside in a single report database file. The database file will be located on the database server if you are using the developer in an Advantage Database client/server environment, or on the local computer if used in a single-user setting. No matter what type of database environment is in use, reports designed with the developer must be exported to a data file and imported into the Focus Reports Print Engine on the destination computer. You (... more)
|
Software Registration
Registration is required before Focus Reports products may be used. This includes Focus on Managed Care, Focus on Financials, Focus on Data, the Focus Reports Print Engine and Focus Reports Developer. General Reports need to be installed and registered only on one network workstation because the report database is shared among all MediSoft users. The print engine and developer must be installed and registered on every workstation on the network. Can't tell whether a characte (... more)
|
Download Focus Reports Developer
The current version of Focus Reports Developer is always available for download in the Dealer Zone of the Inborne Technology web site. (... more)
|
Setting the Focus Reports Data Path
Focus Reports uses functionality built into MediSoft that enables items to be displayed on and launched from the MediSoft menu. MediSoft passes the current data path when Focus Reports is launched from its menu. To change data sets in Focus Reports do this: Close the Focus Reports window, open the desired data set in MediSoft, then relaunch Focus Reports from the MediSoft menu. (... more)
|
Install Developer for MediSoft Version 6 or 7?
When installing Focus Reports Developer you must choose to install for MediSoft version 6 or version 7. Selecting one of these versions installs the appropriate Advantage database driver for one of these versions of MediSoft. The only difference in the installation is the database driver. No matter which selection is made, reports may be developed for either version. Installation for both version 6 and version 7 is not possible and unnecessary. Select the MediSoft version based up (... more)
|
Creating Reports with Appointment Data
Focus Reports Developer can create a report with appointment information when all information is in the appointment data table. Office Hours uses three different appointment tables: The appointment table, repeating appointment table and appointment exception table. To display all appointments together in one view, Office Hours uses program code to combine all three tables into one table. Focus Reports does not have this ability. When a patient is checked in, Office Hours creates a (... more)
|
How to output a report to an Adobe PDF file
Focus Reports includes the ability to save any report as an Adobe PDF file. PDF files are the standard means used to view printed documents in electronic form. They are used extensively on Internet web sites and are easily emailed. Save a report in PDF format like this: 1. Click the name of the report you want to output to PDF in the Report Explorer (Print Engine). 2. Select File | Print from the Report Explorer menu. 3. Click the "Print to File" check box in the Pri (... more)
|
