reporting-services

How can I dynamically center an image in a MS Reporting Services report?

Out of the box, in MS Reporting Services, the image element does not allow for the centering of the image itself, when the dimensions are unknown at design time. In other words, the image (if smaller than the dimensions allotted on the design surface) will be anchored to the top left corner, not in the center. My report will know the UR...

Reading recommendations for: SQL Server 2005 Reporting Services

I have been shuffled around at work. Can anyone recommend a quick book/site to get me up to speed on SQL Server 2005 Reporting Services. Additionally; I have the following books available, a quick rating would be handy. Professional SQL Server 2005 Reporting Services by Paul Turley, Todd Bryant, James Counihan and Dave DuVarney...

How do you handle audit logging with SSRS?

I have some reports in SQL Server Reporting Services 2005 that I need to keep audit logs for. The audit log should include who ran what report with what parameters. I can't use Windows authentication. What is the best way to log this information? ...

Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services

I know there's a bug with conditional visibility and page breaks with SQL 2005, but I wonder if anyone has come up with a work around. I have a table that has a conditional visibility expression, and I need a page break at the end of the table. If I set the PageBreakAtEnd property to true. It is ignored no matter what. Remove the visi...

Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source

I writing a report in Visual Studio that takes a user input parameter and runs against an ODBC datasource. I would like to write the query manually and have reporting services replace part of the where clause with the parameter value before sending it to the database. What seems to be happening is that the @parmName I am assuming will be...

SSRS scheduled reports not working.

My scheduled reports in SQL server won't run. I checked the logs and found the job that was failing. The error message in the log was: 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK SERVICE'. The step failed. I'm using SQL authentication for the report so it shouldn't be issues with the permissions to t...

Optimizing the PDF Export of Huge Reports in Sql Reporting Services 2005

First off I understand that it is a horrible idea to run extremely large/long running reports. I am aware that Microsoft has a rule of thumb stating that a SSRS report should take no longer than 30 seconds to execute. However sometimes gargantuan reports are a preferred evil due to external forces such complying with state laws. At my ...

SSRS - Uninstall Trial Version of VS Business Intelligence

I've been using the Trial version of SQL Server Reporting Services for a while now. My company finally purchased the software from an online distributor, and for support of Oracle, we needed to upgrade to MSSQL 2005 SP2. Anyway, the "full" version of the software would not install, as it was already installed (It seems the installer ...

SSRS - RSS Feeds

This question has already been kinda asked, but I'm asking specifically for SQL Server Reporting Services. Are there any RSS feeds, Blogs or Podcasts that will allow me to find new/advanced SSRS techniques? ...

SSRS - Process dies/goes to sleep after not being used

Another SSRS question here: We have a development, a QA, a Prod-Backup and a Production SSRS set of servers. On our production and prod-backup, SSRS will go to sleep if not used for a period of time. This does not occur on our development or QA server. In the corporate environment we're in, we don't have physical (or even remote ...

SSRS - Post Publishing Tasks

As part of the publishing "best practices" i came up with my own, i tend to archive report groups and republish the "updated" reports. However, with this stratedgy, I lose users associated with each report, or have to rehide reports. Is there an automated process I can use to hide reports, or add users, after deploying form Visual Stud...

Easy way for Crystal Reports to MS SQL Server Reporting Services conversion

Is there a way to easily convert Crystal Reports reports to Reporting Services RDL format? We have quite a few reports that will be needing conversion soon. I know about the manual process (which is basically rebuilding all your reports from scratch in SSRS), but my searches pointed to a few possibilities with automatic conversion "acc...

Internationalization in SSRS

What's the best way to handle translations for stock text in a SSRS. For instance - if I have a report that shows a grid of contents what's the best way to have the correct translation for the header of that grid show up, assuming the culture of the report is set correctly. Put another way - is it possible to do resources in a SSRS repo...

Enterprise Reporting Solutions

Hello everyone, What options are there in the industry for enterprise reporting? I'm currently using SSRS 2005, and know that there is another version coming out with the new release of MSSQL. But, it seems like it might also be a good time to investigate the market to see what else is out there. What have you encountered? Do you li...

I can share a SQL Server Reporting Services Data SOURCE... what about a Data SET?

I am developing a Reporting Services solution for a DOD website. Frequently I'll have a report and want to have as a parameter the Service (in addition to other similar mundane, but repetitive parameters like Fiscal Year, Data Effective Date, etc). Basically everything I've seen of SSRS 2005 says it can't be done... but I personally re...

Custom font in SQL Server 2005 Reporting Services

Hi, I'm having issues with my SQL Reporting Services reports. I'm using a custom font for report headers, and when deployed to the server it does not render correctly when I print or export to PDF/TIFF. I have installed the font on the server. Is there anything else I need to do in order to use custom fonts? When viewing the font in th...

SQL Reporting Services viewer for webpage - can you move the View Report button?

Using the viewer control for display of SQL Reporting Services reports on web page (Microsoft.ReportViewer.WebForms), can you move the View Report button? It defaults to the very right side of the report, which means you have to scroll all the way across before the button is visible. Not a problem for reports that fit the window width, b...

SQL 2005 Reporting Services custom report item (CRI) - what are the limits?

Reading MSDN (and other sources) about custom report items (CRI) for reporting services 2005. It looks like I'm limited to generating a bitmap. Not even with some mapping overlay for detecting mouse clicks on it. Is there away to go around this? There are two things I would like to do: Embed HTML directly into the report, to format dyn...

How do I set a textbox to multi-line in SSRS?

I have a report with many fields that I'm trying to get down to 1 page horizontally (I don't care whether it's 2 or 200 pages vertically... just don't want to have to deal with 2 pages wide by x pages long trainwreck). That said, it deals with contact information. My idea was to do: Name:        Address:   City:        State:  ... Jon D...

Is there a Box Plot graph avalible for Reporting Services 2005?

Is there a Box Plot graph, or box and whisker graph available for Reporting Services 2005? From the looks of the documentation there doesn't seem to be one out of the box; so I am wondering if there is a third party that has the graph, or a way to build my own? ...