All Questions
Tagged with sql-server-2005 reporting-services
277
questions
0
votes
1
answer
382
views
How to Pivot with Columns in SQL SSRS
Would you know if my script is missing anything additional, I am trying to pivot the Table "Pay_Details" and to have the month after month set on column rows with years on rows. I have tried the ...
0
votes
0
answers
25
views
SSRS 2012 with SQL2005 Databases
The following article states that SSRS 2016 supports SQL2008 and beyond for its ReportingServer DB: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-...
2
votes
1
answer
68
views
SSRS 2005 with ASP.NET Report Viewer
Hi unfortunately we only have SQL Server 2005 so I am stuck with SSRS 2005. I have created a report and runs as expected.
I have an issue though. When I combine it with the Microsoft Report Viewer it'...
4
votes
1
answer
15k
views
Change value of SSRS report parameter based on the input of another parameter
I have a SSRS 2005 report with three parameters: @FromDate, @ToDate and @Period. @FromDate and @ToDate default to the first day and the last day of last month, respectively.
The @Period parameter is ...
0
votes
2
answers
1k
views
How to make a SSRS work for multiple users
I can't find anything on this so I don't think I am asking the question right but here is my situation. I have a stored procedure which the end user passes a list of filter criteria, since I don't ...
0
votes
0
answers
234
views
SSIS - SQL Server Agent Job not working properly
Before I start, unfortunately I do not have access to the package design as the person who created this package has left and was stored locally on his office computer. However, this package is called "...
0
votes
3
answers
263
views
SSRS 2005 Subscription changes
OK this is my question(s) and its SSRS 2005 and SQL Server 2005/2008
I had been tasked with rebuilding a dozen or so reports that our users use on their data systems. We just build them and since ...
0
votes
1
answer
3k
views
Can not find the existing data source for the SSRS report
I am trying to create a SSRS report with sql server 2005 BI. I have to use the existing data source to be consistent with the other reports, but in the SharedDataSources folder when I click add ...
0
votes
1
answer
830
views
Text parameter input with date validation
I want to allow user to input a date as a parameter in my report.
I'm using datetime type for a parameter (so it shows a datepicker). After I change region of my PC to "United Kingdom", it show ...
0
votes
0
answers
46
views
Report Access Issue in SSRS 2005
We have hundreds of SSRS 2005 reports in an ASP.Net 2.0 application. We are using following Javascript for rendering the report
window.location.href = url;
Url Example
http://aaa88/ReportServer/...
0
votes
2
answers
742
views
SQL Datetime not working with between
I have a query where i need to get a range of dates, Its an SSRS query so the dates come in as varchars. The thing is when I use between on the date it doesn't return any values that I know are there
...
0
votes
0
answers
94
views
Stored Procedure takes 30 seconds but Report takes 10 minutes
I am using SQL Server 2005 and I have been trying to fix this for a while now. I have tried the parameter sniffing and with recompile but neither have worked.
When executing the stored procedure, it ...
0
votes
1
answer
342
views
Report manager for SSRS 2005 not opening
I have an issue while opening Report Manager for SSRS reports built in BIDS 2005.
Virtual directories named ReportServer and Reports get created on IIS for reportserver and report manager ...
3
votes
1
answer
951
views
Joining a table to two one-to-many relationship tables in SQL Server
Happy Friday folks,
I'm trying to write an SSRS report displaying data from three (actually about 12, but only three relevant) tables that have akward relationships and the SQL query behind the data ...
-1
votes
1
answer
41
views
Conditional Switch clause?
hey guys another TSQL question. I'm trying to only have one set of data listed instead of all the fields. Basically I need:
If rep_name="MATT_RYAN" then switch to "Matt Ryan" else nothing
As of now,...