Home > SIX 2013 Documentation > Knowledge Base > Imported SI5 Reports Look Weird

Imported SI5 Reports Look Weird

Symptoms

When you import a customized SI5 Report, the report displays "oddly". The examples below are from a custom Proposal report.

No description displays for the Level 1 Items. Accessories/Package details display with improper indentation:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/indentation_issue.jpg

 

The Project Summary section (usually last page) is cutoff:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/project_summary_issue.jpg

Resolution

 

This is caused because exported SI5 Reports do not export the subreports for the Report unless those subreports have also been customized. So when imported into SIX, the new SIX subreports of the same name as the subreports bound to the main Report are used, and SIX has newly formatted subreports that may not "play well" with your custom Report. The chart shown below shows what subreports are needed for the various reprorts you might have imported from SI5:

 

report grid.jpg

Steps

 

  1. Download the attached file named "Customized Sub Reports SI5 Format.dtr".
  2. Open SIX and go to Start->Reports->Manage Reports:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/manage_reports.jpg

 

  1. Click Import->File and browse to the file you downloaded in step 1:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/import_file.jpg

 

  1. This will import a "dummy" report that will display under "Uncategorized" in your reports list. You can delete this file if you would like. It was used as a mule to import the subreports and serves no purpose now.

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/imported_report.jpg

 

  1. Open the Standard Report Designer:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/open_standard_report_designer.jpg

 

  1. Choose to open an existing report and choose the report you want to correct. In this example I will be correcting a Proposal with Images report that was imported from SI5 into SIX:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/open_existing_report.jpg

 

  1. When the report opens, click on the description field in the grpItemHeader section and in the Properties window, change the DataField from "dtr:ClientDescription" to "dtr:LongDescription" as shown below:

 

change description data field.jpg

 

  1. Click in the grpItemFooter section and you should see that an object gets selected (there will be a control handle that appears). Right-click and choose Bind to D-Tools Report:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/grpItemFooter_subreport.jpg

 

  1. Based on the chart above, choose the subreport named "Proposal Level 2 Items Images - SI5":

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/binding_level_2_subreport.jpg

 

  1. Click in the grpMiscCosts section and you should see that an object gets selected (there will be a control handle that appears). Right-click and choose Bind to D-Tools Report:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/grpmisccosts_subreport.jpg

 

  1. Based on the chart above, choose the subreport named "Misc Costs - SI5":

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/binding_misc_costs_subreport.jpg

 

  1. Click in the grpSummaryDetail section and you should see that an object gets selected (there will be a control handle that appears). Right-click and choose Bind to D-Tools Report:

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/grpsummarydetail_subreport.jpg

 

  1. Based on the chart above, choose the subreport named "ProjectSumary Detail - SI5":

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/binding_project_summary_detail_subreport.jpg

 

  1. Publish your report and run to make sure all runs as expected now.

 

File:SIX_Guide/008_Reports/Troubleshooting-Reports/Imported_SI5_Reports_Look_Weird/publish_report.jpg

Contact Support

 

If you cannot resolve this issue, please open a Support Ticket.

Last modified
09:41, 23 Apr 2014

Tags

Classifications

This page has no classifications.