locked
Report question - write in or existing item RRS feed

  • Question

  • I've built a new quote report using fetch xml and an excellent article on power objects related to not using sub reports (http://www.powerobjects.com/blog/2013/02/18/dynamics-crm-sub-report-not-displaying).

    Anyway, I have a question that I feel should be easy but I cant work out how to do it at all. 

    On the table displaying all the quote products, the description field is currently set to productdescription, but when an existing item is selected this field is obviously blank. 

    So I need this field to show 'either' the 'productdescription' or 'productid' field based on what is selected, the rest of the row is fine. 

    Thursday, February 20, 2014 11:00 PM

All replies

  • Hi

    Did you try adding an expression on description textbox ?

    Add an if clause something similar to this:

    =IIF(Fields!productdescription.Value=null,Fields!productid.value,Fields!productdescription.value)

    I know this can be done on Sql query based report. Not fully sure about fetch reports, but my guess is that it should.

    Friday, February 21, 2014 9:37 AM