How do I hook linked data into a report

Permanently deleted user

February 11, 2011 03:26

Hi, I want to create a report that runs from an SDE spatial layer that will contain a map with my selected parcel. I also want this report to include the fields from a non-spatial SQL database table (I have set up a connection to this non-spatial table via the Essentials Manager Data Connections page and via the Data Links page). When I test my data links in REST, the linked results appear as expected. When I test it in the viewer, the linked results also appear okay. Now comes the bit I'm stuck on. Can someone please tell me how I hook my linked results values into my report so they show up in my report pdf? Could you please provide some SDE/SQL examples (please no more xls examples) so I can see where I am going wrong or what I'm missing. I am using Essentials 3.3 (REST elements only) and Geocortex Viewer for Silverlight 1.0.1. Hope you can help. Thanks very much.

0

• 

  Permanently deleted user

  February 16, 2011 20:14

  This one took me a little work to figure out so do not feel bad. I could be wrong about this first part but hopefully someone will correct me if I am. 1) If you want a map you need to make the map report your primary report. 2) You will need 2 subreports for your map report. On the Map report add the Subreport boxes to fit the area you want your subreports to display in. 3) Create 2 subreports. One report for the spatial layers attribute arranged how you want it and one with the data link fields. 4) I usually set the data source in the reports to the tables I want to display so I can actually see how it will look. 5) Add the report as a Layer report and make sure it is set to include datalinks. 6) Set the report visible to what you want. 7) Test it in the viewer.   I know this is broad but there is no simpler way to explain it. The documentation on it is awful to it is a lot of trial and error. It is all in the SUBREPORTS.   Good luck.  

  0
• 

  Permanently deleted user

  September 16, 2011 02:11

  When you link the Subreport Control.  You must specify the ReportName to be the DataLinkID for the Data Link.  The Tag has to be the <sub report name>.rpx.  Inside the <sub report name>.rpx file has text controls that are binded to the attribute values of the data linked table setting the DataField attribute to the Attribute Name of the Data Linked Attribute.

  Hopefully this makes sense.

  Jonetta

  0

Please sign in to leave a comment.