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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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