Just want to clarify that I never use select * expeically not in a view. I was just focused on answering the specific question. I did see several...

I'm pretty sure parameters cannot be passed into views. A view is a virtual table and allowing parameters would change its definition and it would become more like a...

Are all other reports are running slow? If so then stop and restart Reporting Services.

Are all the other reports running okay? If so

Run the query or stored...

These are what I would use depending upon the user requirements

(1) If the users need to have full control over when to run the job, I would use SSRS and...

I would try the suggestions by lowell first

Navigation through entities in the report model is determined in the design stage. If you are navigating and entities and corresponding fields disappear there is a problem with the...

I'm pretty sure you can't use two datasets in a Chart. I assume your report has two data regions on it and that's why you are able to have...

You might want to try using a group expression that groups by Month if the Year is current year Else group by Year. Your dataset would have a Month...

Once you launch the Report Builder 3.0 in Report Manager you can create your groups in two ways:

1) Using the Table Wizard or Matrix Wizard under the Insert Tab...