• SSRS interview questions and answers

    I'm looking for SSRS interview questions and answers. Can someone point me in the right direction?

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

    Blowinup5 pointsBadges:
  • Field data in Footer SSRS 2005

    I need to put field data in the footer of a report so it repeats on ever page of the report. How do I get be Header/Footer constraints.

    Rob122810 pointsBadges:
  • SSRS Excel export

    Hello I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.

    BBoy5 pointsBadges:
  • can VS 2005 support Oracle 10g?

    can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

    KPL5 pointsBadges:
  • SSRS 2008 R2 Trendlines

    I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet 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.

    NHSNick30 pointsBadges:
  • Connection issue from analysis to reporting

    I have a report pulling the data from analysis services and reporting in SSRS reports. when I try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during...

    GIG240 pointsBadges:
  • Integrate MOSS with SQL Server 2008

    Can someone provide a step-by-step or point me to a guide for integrating MOSS with SQL Server 2008? Thank you very much. Moderator Note: This is a submitted question

    BrentSheets6,925 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE352,580 pointsBadges:
  • 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...

    ITKE352,580 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.

    ITKE352,580 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following