report: how to pass feature id to filter report data source

Permanently deleted user

19. Juli 2013 02:17

Hello, 

I am new to the report designer tool. I need to create a feature-specific report template with ChartControl, and need to feed feature_id value from the feature layer to be part of the Chart's data source statement - so the data source query will need to be something like:

SELECT * FROM labdataTable WHERE location_id = {feature_id}; 

labdataTable is the table that I will need to pull data out from. location_id is the link field from labdataTable. 

My question is: how to feed {feature_id} into the statement? 

Please help!

 

Thanks,

Jie

 

 

0

• 

  Permanently deleted user

  19. Juli 2013 02:37

  I'm confused: FeatureID is ObjectID? Is FeatureId an attribute in your database? Are you using a WFS/WMS map service, not an ArcGIS Server one?

  Thanks,

   

  Shawn.

  0
• 

  Permanently deleted user

  19. Juli 2013 02:45

  Yes, feature_id is the unique identifier of the feature layer (sample location layer).  The feature layer is added to the site as an ArcGIS server map service.  The labdataTable is a standalone flat table on the same SDE where the feature layer is stored. I need to pull data out from the labdataTable to plot chart for a specific sample location (identified by feature_id in the feature layer, by location_Id in the labdataTable).

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.