• Setting “SendAs” permission for SSRS

    I need to set the "Send As" permission for Report Server Windows Service so my SQL Server can send reports by email. How is this accomplished?

    rdbarnes5 pointsBadges:
  • Auto filter of distinct values on columns in SQL Server Reporting Services?

    Is there a way to have an auto filter of distinct values on columns in SQL Server Reporting Services?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSRS reports in SQL Server 2012?

    I’ve been working with SQL Server 2008 R2 in conjunction with Visual Studio 2008 and 2010. I just installed SQL Server 2012 and have SQL Server Data Tools running. Now I’m trying to create SSRS reports in SQL Server 2008 R2, but I can't find them in Programs. I realize that common advice is to...

    ITKE829,015 pointsBadges:
  • Trying to ID SSRS reports

    Our company currently has over 50 SSRS reports. We're trying to assign an unique ID to each report and we're wondering if there's a way to leverage system generated information in SQL Server 2012 databases rather than manually assigning each report one-by-one.

    ITKE829,015 pointsBadges:
  • Passing parameters to report viewer

    Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has...

    Shaygen5 pointsBadges:
  • 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.

    redusn19505 pointsBadges:
  • 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 would my query...

    Haxatron15 pointsBadges:
  • 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...

    IS Questions110 pointsBadges:
  • 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.

    ConFlicker210 pointsBadges:
  • 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. 

    Akashmay5 pointsBadges:
  • 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 data in...

    An2795055 pointsBadges:
  • 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...

    AMcAuley3105 pointsBadges:
  • 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?

    AMcAuley3105 pointsBadges:
  • 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.

    Radhikavarshit5 pointsBadges:
  • 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?...

    Zhounan5 pointsBadges:
  • 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.

    YogeshNT5 pointsBadges:
  • 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

    Mgee165 pointsBadges:
  • Crystal Reports to SSRS

    There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the...

    Mbdaniel5 pointsBadges:
  • 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...

    Rohitd235 pointsBadges:
  • 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: 0x80090008) Standard Edition Microsoft SQL Server Management...

    Bmull5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following