Topics Tabular Report Search:  
To monitor practice's performance such as Billing data, Payment data, Productivity of individuals and other statistical information, PrognoCIS provides a dedicated customizable report section known as Tabular reports.

My Reports and All Reports radio buttons: Users can search the reports saved under My Reports or search from All Reports list. Reports that are saved as My Report or All Reports from the Add Report (On the Report screen, click Save As icon) popup are available under these options on the Report → Tabular screen.

Classification:  This dropdown displays the list of Classifications defined from Settings →Configuration →Tabular.

Reports: This dropdown displays the list of Reports defined from Settings →Configuration →Tabular.The reports marked as ‘Hide Report’ are not displayed in this list. The list of reports displayed in ‘Reports’ list box are dependent on options selected (My Reports/ All Reports).

Fixed Column: On the Tabular Report UI, depending on the value selected from the Freeze Columns drop-down list, the columns on the report are frozen such that the vertical scroll does not affect its viewing.For Example: 1 – If option '1' is selected then it will freeze one column, 2 – If option '2' is selected then it will freeze two columns on the report and 0 – If option '0' is selected then it will freeze none of the columns on the report.

Period: User can select the desired period from the dropdown. As the period is selected the related dates get auto populated in the ‘From’ and ‘UpTo’ date fields, except for the Custom Date. When the option Custom Date is selected then user need to mentioned the dates in ‘From‘ and ‘UpTo’ field.

Provider: The 'Provider’ list box gets enabled only when the selected report has its related configuration set from Tabular Report design screen. This list box shows all the providers of type ‘DR’ name auto populates as mentioned on Settings → Configuration →Tabular.

Days: This field is enabled only when on Settings →Configuration →Tabular → Days checkbox is checked.

Applicable Title: The field is enabled only for those graphs for which check box ‘Code’ is checked from Settings → Configuration → Tabular → Code Title. The name Applicable Title is replaced by the name mentioned in the field ‘Code Title’, if no name is defined then the field will be displayed as ‘Applicable Title’ only.

Run In Background: When Run in Background checkbox is checked then the process runs behind the screen and the generated report are shown under Settings → Download Files. You will be notified in your Message Inbox when your report is generated. You can download this report from Settings →Download Files → Category “Tabular Reports”. The message in his InBox will have a Zoom Button to display the generated report. The report gets generated under the respective Category section of the Download files. Note: Format of the generated report will be in HTML and Xls file will get generated. The email generated in Inbox is displayed as Message Type N, Subject : Background Process Complete: Tabular Report, Message:Tabular Report is generated . User can click on the Zoom button to view the file.
Limitation: Alert message is not displayed when more than one user perform Run in Background simultaneously for a report.

Patient: This button is shown enabled only when Patient Filter is used in SQL query of the Tabular Report.

Sort: This button will always be enabled and will allow the user to sort the Report.

Billing: This button is shown enabled only when Billing Filter is used in SQL query of the Tabular Report.

Comment: This button is shown enabled when Comments are entered in Comment button of the Tabular Report Design screen.

Design: Clicking the Design button takes the user to the design screen of the Tabular Report screen. Note: This feature is available only for Admin login.

Hide Identifier: This option is shown selected only when the Hide Identifier checkbox is checked on Tabular Report Design screen.

Go Button: After selecting appropriate parameters, Users can click on Go Button generate the desired Tabular Report. 

Pagination

Prev and Next: These hyperlinks will be enabled only when the output of a tabular report has multiple pages.By default, 2000 records will be displayed on each page. If the output exceeds 2000 records, the 'Next' hyperlink will be displayed. After the last page is reached, only 'Prev' hyperlink is shown in enable status. 'Next' will not have hyperlink. Similarly, on the very first page, hyperlink will not be displayed for 'Prev'.

Buttons on the screen

Increase Font: Clicking this button the font size of the report can be seen in larger font size.

Decrease Font: Clicking this button the font size of the report can be seen in smaller font size.

Save As: Clicking this button allows the user to save the copy of the report with desired name and can be saved under any of the two categories My Reports / All Reports.

Print: Clicking this button user can print the report in PDF format.

Export CSV HTML: Clicking this icon generates the report in CSV format.
Note: When the report is run from Reports → Tabular screen and file is downloaded in CSV format, PrognoCIS table columns (for example: BLH_COMMENTS) will not be printed as per displayed in the report because it contains new line characters.

SHA Key for Csv Report: Clicking this icon shows the SHA key generated for the last downloaded file. Each time, when the report output is downloaded the secure key gets generated.

Save Sample: Clicking this icon the report can be saved as a sample and message 'Sample File created' is displayed. Now, this created sample file can be seen on Tabular Report Design Screen besides Report ID field as Preview Sample icon. On click of this Preview Sample icon user can view the generated report.