The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
424 views

SSRS 2008 parameters question

SSRS allows you to create 5 types of parameters: Text, Boolean, Date/Time, Integer i Float. I created a new integer parameter which allows user to enter a minimum price and view a report. However if ...
0
votes
1answer
114 views

SSRS email Subscription Not Working but local smtp is working

SQL SERVER EDITION- 2008 ENTERPRISE EVALUATION EDITION Operating System- Window Server 2008 R2 I've Created Local Smtp to use gmail id for Subscription of SSRS Report by Email as we don't have an ...
0
votes
1answer
97 views

Report in MSSSRS without Star Schema?

I have to create a single report in MSSSRS to view calculated columns (Salary, Total Compensation, Performance Bonus, 401 (k)) by Employee, Department, Service Line, Geography, Quarter, etc. My ...
2
votes
0answers
199 views

Cross-talk with temp tables with SSRS over a shared data source?

I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in ...
1
vote
0answers
16 views

Report Builder Data Sources Do Not Change in Catalog Table

I am trying to extract the connection string for MS SSRS reports from the Report Server Catalog table. This is straightforward enough but if I change the Data Source in Report Builder, the change is ...
1
vote
0answers
39 views

SSRS Filter efficiency question

People at my organization use SQL Queries within SSRS reports: for instance SELECT name, age FROM egTable Then, this query is run on the database and then they use a FILTER within SSRS to get rid ...
1
vote
0answers
54 views

Permissions for executing subscription in SSRS

I'd like to execute an SSRS subscription after some ETL work run by a SSIS package that takes a varying amount of time completes. I'm considering using this method, which basically consists of SSIS ...
0
votes
0answers
7 views

Report snapshot with links to other reports

I have a report that I have just set up to create a weekly snapshot. This report has links on it to other reports in reporting services. When SSRS creates the snapshot, how does it treat these ...
0
votes
0answers
65 views

Subreport Only Works In Some Situations

I have built a report that's a sort of "Landing Page" for two other reports. This report has two parameters, both of which can accept blank ("") values (not null). One of the reports is a "search" ...
0
votes
0answers
448 views

Why have a couple reports started rendering slowly?

Been troubleshooting an issue for a couple weeks now, where a couple reports are running really slowly. These aren't terribly complex reports, they just grab data and do a little aggregation/sorting ...
0
votes
0answers
1k views

SSRS 2008. subreport page breaking issue migrating SSRS 2005 reports over to 2008

I'm moving over several hundred reports that were created in SSRS 2005 over to an SSRS 2008 server, and most run fine when copying the .rpt files over, but the reports that have sub-reports don't page ...
0
votes
0answers
162 views

SSRS 2008 R2 setup issue

I have installed SSRS 2008 R2 on my desktop and server. When I hit the reports link on my desktop http://mypc/Reports_mypc/Pages/Folder.aspx all I get to see is this I cant create a new folder ...
0
votes
0answers
295 views

SSRS - rsAccessDenied error

I have created one SSRS text report. I have built and deployed it successfully. I am also able to view it from the report manager succesfully. I am a local admin on windows server but not on SQL ...