Current Position:Home > XML data from a Web Service sometimes missing fields I need, any ideas on a trap?

XML data from a Web Service sometimes missing fields I need, any ideas on a trap?

Update:10-11Source: network consolidation
Advertisement
I get reports from our ERP via a web service to SSRS.  Just got asked to make a tweak in a report and find that the WebService only sends data that is needed for this transaction.  My issue is our entire system is based around EACH item we make. 
New Trading Partner got Case Price.  We put two of our items together in a box for them is all that happened.
Need to identify package column that had "ea" hard coded. 
When I get a cs item there are more elements that identify conversion factor UOM etc.  They are only sent down for CASE items.  How do I trap for a column not being there 99.98555% of the time?
_conv =  conversion factor.  I only receive it with a 2,4,6 in it whe4n the item is not an each. 
 =iif(Len(Fields!tcibd003_conv.Value) >0  , Fields!inh4470_qshp.Value / Fields!tcibd003_conv.Value , Fields!inh4470_qshp.Value  )
How do I trap for this?  I tried Fields!tcibd003_conv.IsMissing but that didn't seem to work as expected.
TIA

The Best Answer

Advertisement
Hello,
Sorry, I cannot get your requirment and report design structure currently. Can you post the following information to us ? It is benefite us for further analysis.
1. The fields in your dataset. You can post the dataset with sample data if it is convenient.
2. The Report design structure: Table or Matrix and Group inforamation
3. It seems that you want to filter the report data based on a expression, please post more details about the filter logic and expected result.
Regards,
Fanny Liu
Fanny Liu
TechNet Community Support
  • XML data from a Web Service sometimes missing fields I need, any ideas on a trap? Update:10-11

    I get reports from our ERP via a web service to SSRS.  Just got asked to make a tweak in a report and find that the WebService only sends data that is needed for this transaction.  My issue is our entire system is based around EACH item we make.  New

  • Trying to pass xml data to a web service Update:10-11

    I'm working on an Apex application that is required to pass data to a web service for loading into another (non Oracle) system. The web service expects two stings as input, the first string is simply an ID, the second string is an xml document. I gen

  • Get xml data from a web service into Forms? Update:10-11

    Hello folks! I am reading active directory info from a web service into forms via imported java classes. I can read from functions that return strings just fine, but I have to get the output from getGroupUsers which returns an XmlDataDocument. How do

  • How to retrieve data from a web service Update:10-11

    Hi i am at very beginner level about web services. I am searching for a simple example of retrieving data from a web services, but cant find. How can i get xml data from a web service. i dont need to develop the web service it is already ready, i jus

  • Retrieve data from a web service. Update:10-11

    Hi, I need to retrieve the data from Oracle CRM On Demand therefore I downloaded the web service "CustomObject15" from Oracle CRM On Demand then used the netbeans Tool to generate XML files then call Web Service "CustomObject15" then I

  • Unzip data received from web service? Update:10-11

    In my Apex 3.0.1 application I am trying to obtain data from a web service. The problem is that the returned data is first zipped and then encoded using base 64 coding. I can decode the data using the utl_encode package and if I download the result,

  • Dates coming from web service Update:10-11

    Hi, I'm currently trying to consume in VC a CAF Application Service exposed as a Web Service. I'm able to retrieve what I want but I have a problem with dates format. The web service returns dates in the following format: YYYY-MM-DDTHH:NN:SS When I t

  • Deliver data to external web service possible in OBIEE 11g? Update:10-11

    Hi all, I'm looking into the possibility of "pushing" data from OBIEE and out to an external web service, e.g. through executing a scheduled report that instead of delivering the result on screen, it would call an external web service that would