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

    Rick Martinez585 pointsBadges:
  • 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 in a separate text box....

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

    Sivashankar755 pointsBadges:
  • Transposing a table in SQL Server Reporting Services Layout.

    Hi Eveyone, Can anybody tell me that [strong]How to Transpose a table in SQL Server Reporting Services Layout?[/strong] I am having my data displayed in a [strong]Table[/strong] inn SSRS 2005; Please help... Thanks, Swapnil

    Swapnil885 pointsBadges:
  • Rename Sheet when report exported to excel

    hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.

    Rachi5 pointsBadges:
  • Refresh Reporting Services to view newly added sproc fields

    How do I refresh reporting services fields after I have added new fields to my stored procedure? The new felds do not show up in Report Data window. I have tried rebuild and refresh. Neither sem to work. I am using SSRS 2008

    Deeanna5 pointsBadges:
  • Reordering the Table position in SSRS

    Is there any provision to reorder the table position in a rdl? I have two tables, say A and B where A is placed after B at design time. Can I reposition them with B coming first and then A at run time?

    UmaD5 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

    ITKE344,955 pointsBadges:
  • SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes

    I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run...

    Cvillavicencio35 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:
  • Accessing SSRS from a Web server

    We have a Web server at our collocation site with public access. On the server, there is a simple menu with links that call SQL Server Reporting Services. We also have another server -- with SQL Server 2005 -- that contains our database and reporting services. This one is only on the internal...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Insert Word document into SSRS

    How can I import/insert a word document into a report in SSRS?

    NTBC5 pointsBadges:
  • SSRS 2000 Support Ending Date

    Is there a data set when SSRS 2000 will no longer be supported?

    Stoptherain5 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:
  • 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:
  • 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:

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