ResearchMaster Reports

[Print-friendly version]

ResearchMaster uses Crystal Reports software as its reporting tool from the RM application, These reports are written and maintained by RM Support. Details of what field/data each report contains can be found on the individual Module pages.

The reports are updated and modified approximately four times per year and are sent out automatically via an SMS package (which automatically connects to your computer and installs the new reports).  Should you not have SMS allowed on your computer you will have to manually install the reports using the file below.

To check if you have the most recent version of the reports go to your MY COMPUTER and then to the following file C:\RM4\Crystal Reports. A text file will be in this folder and it will be called “Release Date XXXX”. If the release date does not correspond to the date below you will need to install the reports.

• Faculty Reports
• Report Structure
• Types of Reports
• How to Run Reports
• How to Export to PDF
• FAQS

Faculty Reports

(new report set as at 16 July 2008)

The latest report templates are available for download. Please select the desired module:

• Postgradute Reports
• Projects (Grants) Reports
• Publications Reports
• Ethics Reports
• All Modules
• Library Reports (for Library users only)

Click on the link above and run the exe file. The file will automatically install the reports in the correct folder. If you have any problems or require assistance, please either email RM Support or call x88008.

Report Structure

The reports are broken down into their "purpose" ie. the type of information provided by the report and take the following structure within their numbering:

100 - Core based around application or publication or student.

200 - People based on investigator, author, supervisor and examiner.

300 - Significant Dates

500 - Fund Sources based around grant scheme and scholarship recipients.

600 - Finance based around budget financials and transactions.

700 - Thesis and Examination

Types of Reports

There are three types of reports - (1) those which are designed to be printed or exported to word (2) those which are designed to be exported to excel and (3) those which are presented in cross-tab style. These three types of reports are distinguished in their title and easily identifiable.

RPT - printable or exportable to word

EXP - exportable to excel

XTAB - presented in crosstab format

Please note: when exporting to word it is recommended that you select Export to Rich Text Format (RTF) - this opens in word and is the best way to retain the formatting used in the report.

How to Run Reports

Once you have your results on your desktop simply click the report icon on the toolbar

This will bring up the reports dialogue box.

Navigate to the Crystal Reports tab please note: QUT supports Crystal Reports only - the other options present of Classic Reports, Export Reports and HTML Reports are not supported and not should not be used.

Select Report to choose your report. Reports are located in the folder C:\RM4\Crystal Reports (for faculty and institute users - Division of Research & Commercialisation users should contact RM Support with regards to the report suite).

Once selected, the name of your report will be listed under Report Name. Press the Screen button to start the report. Please do not use the Download Reports button.

Once the report has appeared on your screen it can be used in a number of ways, depending on the type of report it is. For an EXP (Excel export) report, click on the envelope icon to export it to Excel - preferred version is 8.0. For reports beginning with RPT click on the printer button to send it to your default printer.

How to Export to PDF

You can send RPT reports to PDF however you must first install the CUTE-PDF writer. This is free software which enables you to be able to print to PDF.

• Run CONVERTER.EXE
• Run CUTEWRITER.EXE
• Re-boot your computer

The difference with this over the way you normally export to PDF is that the Cute PDF program acts like a printer so when you are in RM and you want to export to PDF you need to do the following:

• Go to START > PRINTERS and FAXES
• Set your default to CUTE PDF
• Open your report in RM as per normal
• Click on PRINT (not export)
• It will ask you to SAVE it – just choose somewhere that’s logical to you

Once you are done, you should change your default printer back to your normal printer.

Frequently Asked Questions

How do I turn an Excel report into a Pivot Table?

1. Open the exported RM report in Excel.  
2. Click on a cell within the data.
3. On the Data menu, click PivotTable and PivotChart Report
4. In step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create?
5. Follow the instructions in step 2 of the wizard.
6. Follow the instructions in step 3 of the wizard, and then decide whether to lay out the report onscreen or in the wizard.

Instructions about PivotTable report layout can be found here.

How can I merge several reports to get the data that I require

ResearchMaster reports are written to generate a specific output and sometimes you might require data that is provide in two different reports to be merged into one. This can be done easily on Microsoft Access. Instructions on how to merge data can be found here and you are welcome to contact RM Support if you require further assistance.