• Hi Sarah

    Its always nice to see response to a query.

    In the report model I was able to create a filter such that it pulls only from one company.

    What I was looking to do was pass the 'company name' which is stored in one of the database tables at run time to the Report Builder model such that only data from that company comes up.

    Under Data Source Views, (Solution Explorer in Visual Studio) I right clicked on the table diagram and selected 'Replace Table with a new Named Query'

    But I would still not be able to pass parameters to the Report Model at Run Time based on values stored in a database table.

    I feel the authentication is based on the server credentials.

    We cannot do authentication based on data stored in one of the tables in database.

    So what I trying to do is not going to work. 🙁 :unsure:

    DD