• Report having more than 240 columns in SSRS 2005

    Hi folks, I am using SSRS 2005 BI. As per MSDN standards SSRS 2005 will not support more than 240 columns in excel (while exporting, will get error). Now I am having more than 240 columns though I am using SSRS 2005, I am not getting any errors. However there is an error here: Reporting Services...

    BhakthaprahladaReddy2,030 pointsBadges:
  • 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.

    Gma885 pointsBadges:
  • Exporting SSRS Report in Simple Excel sheet(not formatted)

    Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

    Avhilash5 pointsBadges:
  • Export SSRS Report to Microsoft Excel

    Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

    AmitJoshi14310 pointsBadges:
  • Count the times that = Smith is present in SSRS

    I want to count how many times a certain word is used is a column on a SSRS report

    Vickis5 pointsBadges:
  • SSRS Report Server security not working

    SSRS Report server security group is set up right on folders with all rights. But we are getting an Windows account error that says a specific Windows account lacks rights to create a data source. What could cause this?

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

    ITKE371,765 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...

    ITKE371,765 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.

    ITKE371,765 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:

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.