Report Model & Data Source Views

Hi,
(Newbie at SSRS, 10 years experience with SQL-Server & Web/App programming)
I recently (about 1 week ago) introduced myself to the world of SSRS - but
it wasn't as straightforward as I first thought it should be. Try yourself by
searching for documentation about installing reporting services on another
machine than the same as the sql server (ie: at the webserver). As usual: -
you have to read several different webpages, scan through endless
documentation created by linquist-speciallists (discussing everything but the
subject) - a.k.a. 'quickstarts'. Whehehe..
Anyhow, I've now successfully setup Reporting Services and it really excells
at everything it does :)
However, I find it a little bit strange generating the Report Model from the
Data Source View. Shouldn't it be the otherway around? - First creating the
Model (a simple schema of the database - right?), and THEN creating the view
- 'building' upon that model. Could someone please expand on this subject?
Why?
Then there seems to be an issue when I try to include a SQL Server "SQL
View" a.k.a. "Indexed Views" into the Report Model, so this results in that
neither of my SQL View are accessible from the online Report Builder tool.
Shouldn't it be possible to include views in the Report Model?
Best Regards,
FredrikThis is how I solved it:
- In the Data Source View, be sure to set Logical Primary Keys for the SQL
Views that you want to use. Just select the unique columns (if more than
one), rightclick and create the key.
- In the Report Model, add the entities (SQL views) manually - name & bind
them to the SQL views. Rightclick on an empty & newly created entity and
select autogenerate, proceed through the wizard. Add the identifying column
manually on the the entity (using the properties tool-window).
- Build and combine the .DSV & .SMDL file into one (fairly easy to google),
then upload the resulting "model.smdl" to the Report Manager.
- Enjoy SQL views in Report Builder!
"Fredrik Johansson" wrote:
> Hi,
> (Newbie at SSRS, 10 years experience with SQL-Server & Web/App programming)
> I recently (about 1 week ago) introduced myself to the world of SSRS - but
> it wasn't as straightforward as I first thought it should be. Try yourself by
> searching for documentation about installing reporting services on another
> machine than the same as the sql server (ie: at the webserver). As usual: -
> you have to read several different webpages, scan through endless
> documentation created by linquist-speciallists (discussing everything but the
> subject) - a.k.a. 'quickstarts'. Whehehe..
> Anyhow, I've now successfully setup Reporting Services and it really excells
> at everything it does :)
> However, I find it a little bit strange generating the Report Model from the
> Data Source View. Shouldn't it be the otherway around? - First creating the
> Model (a simple schema of the database - right?), and THEN creating the view
> - 'building' upon that model. Could someone please expand on this subject?
> Why?
> Then there seems to be an issue when I try to include a SQL Server "SQL
> View" a.k.a. "Indexed Views" into the Report Model, so this results in that
> neither of my SQL View are accessible from the online Report Builder tool.
> Shouldn't it be possible to include views in the Report Model?
>
> Best Regards,
> Fredrik