SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.

learn more… | top users | synonyms

2
votes
1answer
814 views

How to apply filter at runtime in SSRS 2008 R2

In my report in SSRS 2008 I have created a expression for the CasesShipped column like this: =IIF(Fields!Current_Product.Value= "Match"," ",Sum(Fields!Cases_Shipped.Value)) It sums the ...
5
votes
1answer
7k views

How can I tell which data sources are being used in SSRS?

We have a bunch of SSRS (2008) reports deployed to our web portal. We have edited some of the reports to use a shared data source different than the one with which it was originally deployed. I am ...
6
votes
3answers
299 views

Things to consider with a bigger table

I have a table that has around 12 billion rows (row size 32 B) which grows each month by 300 million rows. I have setup partitions for each month and each month has 8 data files (since I currently ...
20
votes
1answer
536 views

Reporting Service and Application Role

First poster, long time lurker here. What is the best way to activate application role in a report ? I've tried different things and so far the only method that works is to embed the call to the ...
0
votes
1answer
248 views

Using SSAS for retrieval data instead of using SSRS to make a report?

If you work with Reporting service in order to create a report and you need to retrieve data from the relational database. The datamodel of the relational database can be structured in a certain way ...
6
votes
3answers
235 views

Find material for improvement in Microsoft BI

Which websites, books etc. can you recommend me to improve my basic knowledge in Microsoft Business Intelligence 2008, SSAS, SSIS and SSRS? Please remember that I'm a newbie in technical BI tool. If ...
3
votes
2answers
282 views

Report model data source

Does anybody know how i could use a linked server as a data source for a report model in SQL server 2008 r2? or how i could make this linked server a data source on a report model? Please help. Thank ...
6
votes
1answer
2k views

Is it safe to change the Recovery Model of SSRS database ReportServer to SIMPLE?

I'm changing the recovery model of ReportServer database from FULL to SIMPLE. Is there any reason why i would not want to do this? Besides the obvious answer of losing point-in-time recovery? (i am ...
1
vote
2answers
1k views

Connect a linked server to MS Reporting Service?

I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server? How do I connect it to Reporting Services?
3
votes
3answers
4k views

Problem Connecting Report Server to Report Server Database in SSRS

I have configured Reporting Services on one Server and have the ReportServerDb & ReportServerTempDb on other server (Future requirement of scale out deployment). I am connecting to these servers ...