Map Image with MultiLayer Report blowing up
/customer/servlet/servlet.FileDownload?file=00P6000000elzvIEAQ
I'm trying to do the multi-layer report and throw a map image on it as well.
I *think* I may have overcome the iXMLSerializable error (I hope) but now am getting the above when my workflow gets to the report.
I know that it means that it can't find SOMEthing, but what?
If I remove the get map part of my workflow, the report will work.
I also know that the URL for the mapimage is valid, because I can enter it into a browser and get a return...
/customer/servlet/servlet.FileDownload?file=00P6000000em1g7EAA
Is the image not getting transferred to the DataSet?
Is the subReport broken?
please help.
thanks.
Eric
-
Eric,
As the message says, there is definitely not matching the data source (dataset) and the FieldNames in rpx file.
How many DataTable(s) are in the DataSet?
Are you usign 'TemplateReport' activity, rgiht?
If then, one of InArguments will be DataSet where you need to set the datasource of the rpx file.
Make it sure you set the DataTable in DataSet with the map image (which I think you get from 'Export Map' client activity.
You can check the image is correctly generated by 'Write File' activity, and check your dataTable using 'DataTable To CSV activity or something else like looping through the DataTable.Rows to debug.
Munhwan
0 -
How many DataTable(s) are in the DataSet? -- 19 (I think)
Are you usign 'TemplateReport' activity, rgiht? -- Yes
If then, one of InArguments will be DataSet where you need to set the datasource of the rpx file -- should be good
Make it sure you set the DataTable in DataSet with the map image (which I think you get from 'Export Map' client activity.
should be in here, correct?
<Sequence DisplayName="Include Map Image" sap2010:WorkflowViewState.IdRef="Sequence_69">
<Sequence.Variables>
<Variable x:TypeArguments="x:String" Name="MapURL" />
<Variable x:TypeArguments="scg:IDictionary(x:String, x:Object)" Name="dictionary" />
</Sequence.Variables>
<gwa1:CreateDictionary x:TypeArguments="x:String, x:Object" sap2010:WorkflowViewState.IdRef="CreateDictionary`2_1" Result="[dictionary]" />
<gwa1:ExportMap IncludeGeoreferenceData="{x:Null}" UseTransparentBackground="{x:Null}" CustomExtent="[bufferEnvelope]" sap2010:WorkflowViewState.IdRef="ExportMap_1" ImageHeight="[400]" ImageWidth="[600]" ResultUrl="[MapURL]" />
<Sequence DisplayName="Bitmap Sequence" sap2010:WorkflowViewState.IdRef="Sequence_71">
<Sequence.Variables>
<Variable x:TypeArguments="sd1:Bitmap" Name="bitmap" />
<Variable x:TypeArguments="sd:DataTable" Name="dataTable" />
<Variable x:TypeArguments="sd:DataSet" Default="[New System.Data.DataSet]" Name="dsMapDataSet" />
</Sequence.Variables>
<gwa1:DownloadImage sap2010:WorkflowViewState.IdRef="DownloadImage_1" Result="[bitmap]" Uri="[MapURL]" />
<Assign sap2010:WorkflowViewState.IdRef="Assign_90">
<Assign.To>
<OutArgument x:TypeArguments="x:Object">[dictionary("MapImage")]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:Object">[bitmap]</InArgument>
</Assign.Value>
</Assign>
<gwa1:Alert sap2010:WorkflowViewState.IdRef="Alert_11" Text="[MapURL]" Title="MAP IMAGE" />
<gwa1:DictionaryToDataTable x:TypeArguments="x:String, x:Object" DataTable="[dataTable]" Dictionary="[dictionary]" sap2010:WorkflowViewState.IdRef="DictionaryToDataTable`2_1" />
<Assign sap2010:WorkflowViewState.IdRef="Assign_92">
<Assign.To>
<OutArgument x:TypeArguments="x:String">[dataTable.tablename]</OutArgument>
</Assign.To>
<Assign.Value>
<InArgument x:TypeArguments="x:String">Map_Data</InArgument>
</Assign.Value>
</Assign>
<gwa1:AddToDataSet DataSet="[dsReportSource]" DataTable="[dataTable]" sap2010:WorkflowViewState.IdRef="AddToDataSet_1" />
</Sequence>
</Sequence>0 -
It looks good.
The first datatable (out of 19 dataTable) in the DataSet is the dataSource of the main repotr (rpx file) unless you put your own Script on your rpx file.
Also, if you have many suports to consume the 19 datatable in the dataSet, are you confident you have done correctly to associate between DataSource of the SubReport file and DataTable?
I would like to test with only two DataTable source to make this work (one for the main report, and the other for sub-report) and then expand one by one.
Is it only one ExportMapImage source issue?
If you take off Image(Picture) where the exported map image is rendered on the rpx, is your report work with 19 datatable?
I think it will be helpful to use the support ticket if possible to get on-hand help.
Munhwan
0
Please sign in to leave a comment.
Comments
3 comments