Showing posts with label models. Show all posts
Showing posts with label models. Show all posts

Monday, February 13, 2012

building models with views

Using data in SS2000 and RS2005. I tried to build a model from a view that I
created. I got the "tables does not have a primary key" error. Do I have to
use indexed views in the model?
--
Dan D.Dan,
You will need to specify a 'logical' primary key in your DSV (Data Source
View)
Bret
"Dan D." wrote:
> Using data in SS2000 and RS2005. I tried to build a model from a view that I
> created. I got the "tables does not have a primary key" error. Do I have to
> use indexed views in the model?
> --
> Dan D.

Friday, February 10, 2012

Build reports using Report Designer using Models

Once a Model is created, is ther query builder the only tool that can be used
to create a report from the Model or can we use Report Designer to build
reports off a Model?
Thanks in advance!I guess I should have clarified I am work with the 2005 Beta version of
Reporting Services. If anyone has any idea, please let me know.
Thanks!
"clutch" wrote:
> Once a Model is created, is ther query builder the only tool that can be used
> to create a report from the Model or can we use Report Designer to build
> reports off a Model?
> Thanks in advance!