none
Unable to show all fields from a table\view within a SSRS Report Model for user selection

    Question

  • I recently added a new view with a simple SELECT (with 3 fields) statement to our existing Report Model DSV. I then went ahead to the report model (.smdl) file proceeded with the auto-generation of the new attributes which of course ran with no issues. I was seeing the three new fields as attributes. But when I went within the existing Perspective to add the newly added fields so that the users see them, one of the field is missing. It is just a VARCHAR field. What would it cause this field to not show up within a Perspective?

    Any help is greatly appreciated.Thanks,

    Nimesh


    NM


    • Edited by NMan47 Monday, August 25, 2014 9:13 PM
    Monday, August 25, 2014 9:03 PM

All replies

  • Hi NM,
     
    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.

    Thank you for your understanding and support.
     
    Regards,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Wednesday, August 27, 2014 8:48 AM
    Moderator