Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Report question - write in or existing item RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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