The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
91 views

User can create in SSRS, but can't manage objects

We have a user who can create, but is unable to manage objects in SSRS, even though he has content manager permissions and another user who has same permissions who is able to. It is SSRS 2008 R2, ...
2
votes
0answers
182 views

Exporting SSRS report to Excel

We have a number of SSRS reports and want to show the report in Excel format to the users. SSRS has provided an option to save the report in Excel format (.xls), however when the report is saved as ...
1
vote
0answers
37 views

How to specify a display name in emails from SSRS subscriptions?

How can I specify a display name (e.g. "Reporting Server" <noreply@domain.com>) in the emails sent from SSRS subscriptions?
1
vote
0answers
57 views

How to draw series line in SSRS chart

Does anyone know how to add the series line between these columns in SSRS chart? Thanks!
1
vote
0answers
208 views

SSRS Remote Database Connection Issue

I have installed SSRS 2008 R2 on Windows 2012 server. It is up and running. In the Configuration Manager, I have set it to point to remote Database on same network. Then on my own PC (also on ...
1
vote
0answers
234 views

How to change x-axis labels in a report

I am creating a trend report, in which the x-axis labels are first laywr as year (2014), second quarter (1,2), third period (month) (3,1), fourth week (3,4,5,1,2). I need to change these labels as ...
0
votes
0answers
8 views

Is it possible to overcome the lack of “detail” group in SSRS matrix report to get the correct totals?

Apparently SSRS handles matrix reports fine, as long as the totals are being calculated under the pivoted columns only. The first report below calculates the correct totals. <?xml version="1.0" ...
0
votes
0answers
45 views

ReportViewer winforms control missing some functionality/formatting

Not sure where this should go, but wanted to start here. I have a few reports on a SQL 2008 R2 SSRS instance. These reports contain inline styling (some select words are bold in a cell). The reports ...
0
votes
0answers
191 views

How to convert Excel into Star-schema Model?

My end user gave an Excel spreadsheet with 15 columns and 50K rows out of which 5 columns are calculated and 10 are not. My data modeler has converted Excel into a single TABLE on Microsoft SQL ...
0
votes
0answers
781 views

SSRS - Report using Stored Procedures, Cascading Parameters and Views

I am looking for a non-trivial Microsoft SQL Server Reporting Services example that shows the efficient use of the following for calculated columns such as: Profit = Revenue - Expense Margin = Profit ...