Run Oracle Procedure in SSRS dataset
Have an Oracle stored procedure that needs to run to repopulate a table. Do not need data from sp, have a separate dataset to pull from refreshed table. What I need is a way to run the sp that is acceptable to SSRS inside or outside of dataset.

Answer Question   |  January 28, 2013  7:43 PM
Oracle, SSRS, Stored Procedure

Accessing Report Permission Using An Stored procedure in SSRS
I have created an Report and I want to give Access  to only few to View Report. Is there a way to use a  Procedure to grant access to Users. 

Answer Question   |  February 27, 2012  6:55 AM
SQL Server, SSRS

SSRS 2008 R2 Trendlines
I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet http://technet.microsoft.com/en-us/library/dd207034.aspx refers to a ‘Values’ area and an option to ‘Add Calculated Series’. The ‘Values’ area I see does nothing on a “Right-click” and the option to “Add Calculated Series” I cannot find anywhere.

Answer Question   |  October 25, 2011  8:19 AM
SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

SSRS authentication in workgroup environment
Can a workgroup be configured to authenticate to reporting services to run reports? If so, could someone please assist me in this security setup as we are currently experiencing difficulty. Our Windows 7 “server” authenticates fine but none of the current client computers are able. Thank you.

Answer Question   |  March 31, 2012  2:51 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups

Backup started running 2x longer
Hello, We have a 3573 L2U drive which we are using as a standalone tape drive.  Our backup jobs started running nearly twice longer than our normal run time last week.  IBM SSR replaced the drive, cable and terminator.  However, still after replacing, backup still ran long.  Do you have any idea what is causind [...]

Answer Question   |  March 31, 2012  5:32 PM
Backup, IBM, IBM Ultrium 3580, OS/400, SSRS

VS 2005 SQL Reports – Need to convert 5 character string to datatime
Hey there. I am relatively new to SQL and have a problem. I am building a report that gets a summation of a column called ‘Duration’. The datatype is char(5) e.g. “00:30″ to represent a half hour. I suppose I need to change the datatype to sum it but can’t figure out how to. What [...]

Answer Question   |  March 31, 2012  8:16 PM
SQL, SQL Server, SSRS, Visual Studio 2005, VS 2005

SQL Report Help
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]

Answer Question   |  June 1, 2011  11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS

SSRS Report switch for Operational DB to DWH
We currently are running a large report off of the operational DB but in turn used this report to create a DWH in order to get this report to run faster. Before we used a stored procedure with many smaller queries that summed our numbers. Since we have the DWH that stores all this needed [...]

Answer Question   |  February 16, 2011  2:43 PM
SQL Server data warehousing/business intelligence, SQL Server Reporting Services, SQL Server Reporting Services 2008, SSRS, SSRS 2008

Trying to get select all in a dropdown from the AS400 to SSRS(Urgent)
I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don’t know if there is a way I [...]

Answer Question   |  December 2, 2010  3:29 PM
AS/400, AS/400 reporting, SSRS

Error trying to get a store produce to work from AS 400 to SSRS
I have made a store procedure that runs fine but when I try to Call it into SSRS I am getting an error. The Error says SP_Convert_Date_MMDDYYY_to_CYYMMDD in *N type *N not found. Is there anyway of getting it to find my file in the AS 400 and what would I have to do?

Answer Question   |  December 2, 2010  7:14 PM
AS/400, SSRS, SSRS 2005, SSRS 2005 errors

SSRS Report Export to Excel
When exported to Excel, some data is hidden from view by the row heigth. Rows must be expanded to view. Please suggest me a nice solution so that if the data is more than the single line, it has to expand the row height.

Answer Question   |  November 22, 2010  7:14 AM
excel, SQL Server, SQL Server Reporting Services, SSRS, SSRS 2005

How to make a graph always visible when there is no data?
Hi, I am currently creating a report in SSRS which contains many tables including a graph on one page. The formatting is nice generally, but when there is no data in the graph, everything will be different. So, I am trying to keep the graph always visible to keep the formatting. Is that possible? Thanks, [...]

Answer Question   |  October 5, 2010  8:52 AM
SQL Server Reporting Services, SSRS, SSRS Performance, SSRS reports

SQL Server Reporting Services (SSRS) Reports 2005
How to include to Input parameters in the report, so as to help users identify the parameters on which the report was run.

Answer Question   |  October 4, 2010  12:06 PM
input parameters, Parameters, SQL Server, SQL Server reporting, SQL Server Reporting Services, SSRS, SSRS reports, SSRS Reports 2005

SSRS Dynamic Report Parms
I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks

Answer Question   |  September 1, 2010  4:14 PM
SQL, SQL Parameters, SQL Server, SQL Server 2008, SSRS, SSRS reports

Exporting to Excel – Sort doesn’t work due to merged cells
How can I change my SSRS to allow exporting into EXCEL and eliminate the header portion of report which includes merged cells. These prohibit my user from being able to sort a column in the table data.

Answer Question   |  August 6, 2010  9:40 PM
excel, Excel import/export, SSRS, SSRS Migration, SSRS reports

Using stored Procedure in SSRS
Hi…. I am trying to create a Report using Report wizard in MSSRS 2005, I am trying to use Stored Procedure. The steps which I am following are below…. Solution Explorer–> Add New Report–> Next(as DB is already shared one)–> Query Builder (But when going into query builder the command text is disabled and I [...]

Answer Question   |  June 3, 2010  8:24 PM
SQL Server 2005, SQL Server Stored Procedure Migration, SSRS, Stored Procedures

Invalid Algorithm Specified
I am going through a SSRS tutorial using the AdventureWorks database on a fresh install of SQL Server: I get the following error when trying to deploy a project: Error rsRPCError : Invalid algorithm specified. (Exception from HRESULT: 0×80090008) Standard Edition Microsoft SQL Server Management Studio: 9.00.3042.00 Microsoft Analysis Services Client Tools: 2005.090.3042.00 Microsoft Data [...]

Answer Question   |  May 5, 2010  1:39 PM
Microsoft SQL Server Management Studio, SQL Server, SSRS

Reporting Services 2005
Hello, I am running reporting services 2005. I created a subscrition for a report named “paid_claims” that will auto generate an excel file into a shared folder on the network. The “paid_claims” report has a link to another report named “sub_paid_claims” in the same folder. We recently renamed our server from MEDI01a to MEDI01, when [...]

Answer Question   |  January 13, 2010  4:23 PM
Reporting, Reporting Services, Reporting Services 2005, SSRS, SSRS 2005

SSRS statistics
Hi, I new to SSRS. I have a table grouped by a category. I need to make a statistics about number of rows of particular item and sum of few columns in each of the group. I can make those statistics inside the tablix. But I need to have those statistics outside of the tablix [...]

Answer Question   |  December 21, 2009  1:50 AM
SQL Server 2008, SQL Server Reporting Services, SSRS

Trigger SSRS report when particular table is updated in the database
Hi, I need Trigger or run the SSRS report automaticallty and deliver to my email when some updates happens in particular table. Is that Data driven subscriptions is solution for the above or any other methods to be done. Looking forward you answer quickly   Thanks

Answer Question   |  December 18, 2009  2:39 PM
SQL Server Reporting Services, SSRS, SSRS reports