Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding new fileds to reporting model in SSRS giving me error in smdl file Expand / Collapse
Author
Message
Posted Wednesday, February 19, 2014 5:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 4:56 PM
Points: 7, Visits: 17
Hi All,

I am new to SSRS and I have task to edit report model in SSRS. We have a reporting model that i tried to edit as i have added new fields for that database/table(s) ..

here is what I did

-->in dsv file for the table that I need to add new fields to I right clicked on it and then clicked on "Edit named Query"

-->then added new fields to query and build the project

-->now in smdl file I tried to add new fileds to that certain table source by right clicking on it and selecting "add-> new source field" and I renamed it as it is as in the table

-->now when I try to build the application I get an error like "The binding is missing for the Attribute "EthicsApprovalType". Attribute must have exactly one Column binding if Expression is not specified"

Please help me .. am not sure what else am missing.
Post #1543294
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse