DataLink information not showing in report - REST

Permanently deleted user

August 03, 2011 22:38

I using REST manager 3.4.1 and am trying to set up a report with information from an external database - the report works fine in the WebADF versions, but does not show the information from the database in the REST version.  I have set up a Datalink for the layer which works - as I can get the information to show using the identify function - but the data does not show up in the report.  I wondered if there was a specific syntax for using in the DATAFIELD  property of the text box to refer it to the datalink fields rather than the attribute fields of the shapefile. 

 

I have selected the perform data link button Report properties.

 

Thanks

Caroline

0

• 

  Permanently deleted user

  August 05, 2011 05:11

  Hi Caroline,

  The DataField property needs to contain the name of the column in your database. For example, if I want to show data from the ZIP column of the database I've linked to, in the DataField property I would type ZIP (all capitals, exactly as it appears in the database). I hope this helps!

  Victoria

  0
• 

  Permanently deleted user

  August 10, 2011 21:37

  Hi Victoria

  This still isn't working - what happens if there are multiple data links - how does the report know which link to use?

  Thanks

  Caroline

   

  0
• 

  Permanently deleted user

  August 13, 2011 06:58

  Hi Caroline,

  If there are multiple data links then you need to create a subreport for each one. When you drag the subreport control onto your main report, the Tag field is where you specify the .rpx file that you want to include, and just above that is the ReportName field which is actually where you put the ID of the DataLink element that you want to use. Then, from within your subreport, in the DataField property all you need to specify is the name of the column. More information can be found in the help menu of Report Designer, under "Incorporating Data in your Template", and if you click REST Elements under "Specify a Subreport's Template File".

  Cheers, 

  Victoria

  0
• 

  Permanently deleted user

  August 30, 2011 23:27

  I find that the "HELP" in Report Designer a little lacking in depth and clarity.  I would be nice to have more documentation and a separate forum for the Report Designer.

   

  Mark

   

   

   

  0
• 

  Angeleta Wilson

  February 13, 2014 23:30

  Hi,

  I am experiencing the same issue and the forum or help documents doesn't seem to provide much assistance. Not even my date/time  field populates and I didn't change the datafield as the document stated, but all I get are the headings and the date/time for the footer, but no actual data on the pages.

  Ange

   

  0
• 

  Angeleta Wilson

  February 14, 2014 04:17

  Figured this out; issue was with the template area. Created a new template and added the fields again and it works fine - still cannot explain why the 1st template didn't work however.

  0
• 

  Permanently deleted user

  February 25, 2014 00:55

  I'm getting the same issue also where the reports are not using the datalink for the layer.  I even created a new template in the report deigner 4.0 version and no dice.

  Is there a specific parameter, like {}, you need to use in the datalink field in the report designer?  The whole URL to the REST endpoint maybe?

  0

Please sign in to leave a comment.