What charting tools/controls would you use with SQL Server/Reporting Services?
Apart from commercial tools like Dundas, are there any open source or cheaper (and decent) 3rd party charting tools/controls for reporting services out there? ...
reporting-services
Book/resource recommendation for learning charting with Reporting Services
What books or online resource would you recommend for learning how to do advanced charts and dashboard design with Reporting Services? ...
Define small row height in Reporting Services 2005
I want to specify a small row height in a Reporting Services report of about 3pt. However, while the report looks ok in the previewer, once deployed, the row height resets to the standard row height. I've tried adjusting the "CanGrow" and "CanShrink" settings as well as playing around with the padding, lineHeight, font size, etc... An...
Displaying Tiff files in SSRS reports.
I have a requirement to be be able to embed scanned tiff images into some SSRS reports. When I design a report in VS2005 and add an image control the tiff image displays perfectly however when I build it. I get the warning : Warning 2 [rsInvalidMIMEType] The value of the MIMEType property for the image ‘image1’ is “image/tiff”, which i...
How do I get the full name of the current user from a SQL Reporting Services 2008 report?
I know that the name of the user account can be retrieved from the built in variable User!UserID but how can I get the full user name of the user? I guess it would be possible to hook up some .NET code and do a Active Directory look up but are there any alternatives? ...
Custom ROLAP Data Source in SSAS
I am trying to build an OLAP datasource from a bunch of binary files, and our current model just isn't working. We are using SSAS as our analysis / reporting model for our results, but aren't able to get the performance we want out of SQL. Our main constraints are: The database is very large. We have huge dimension tables with mil...
How to check for null values before doing .AddDays() in SSRS?
I have the following as the value for my textbox in SSRS report: =iif(IsNothing(Fields!MyDate.Value), "", Format(Fields!MyDate.Value.AddDays(30), "MMMM dd, yyyy")) It gives me an "#Error" every time MyDate is null. How do i work around this? UPDATE: i wrote this custom function, it got rid of the error, but returns January 31,...
Using client side reporting vs. server side reporting?
When do we use client side reporting and when do we use server side reporting? Which reporting is best practice (client/server)? This pertains to SSRS reporting. ...
SSRS: Change SQL Statement Dynamically
I have a report in SSRS 2005 that's based on a query that's similar to this one: SELECT * FROM MyTable (NOLOCK) WHERE col1 = 'ABC' AND col2 LIKE '%XYZ%' I need to be able to dynamically include the AND part of the WHERE clause in the query based on whether the user has checked a checkbox. Basically, this is a dynamic SQL statement a...
How to generate a PDF from an embedded report definition without server or UI?
Is it possible for a stand alone executable to generate a report and output it as PDF (or one of the other export options available from the report viewer) without displaying the ReportViewer control? The report definition should be embedded in the executable and should not use the Reporting Services web service. ...
SQL Reporting services - Out of Memory Exception
I am having some 10 lac records in my single SQL Table. I need to load this much record in my record. I need to know whether this will load. when i tried loading to report its showing out of memory exception. ...
permission in studio 2008 reports.
Hi, I have succesfully added a custom assembly, added it to the report using AddTrustedCodeModuleInCurrentAppDomain. I am executing the report in the current appdomin. When I try to access SQL I get reporting services System.Data.SqlClient.SqlClientPermission failed. I have tried adding System.Data to the trusted assemblies as above bu...
.NET Architectural issue: 2 Web Services, how do I change which one is used at run time?
I am working with Reporting Services and Sharepoint, I have an application that leverages reporting services however a client would like our application integrated into sharepoint. Currently we are tightly coupled to the ReportService.asmx webservice which exposes various methods for performing operations. Reporting Services has somethin...
Calling Reporting services rdl in Java application
I have developed my reports in SQL REporting services and deployed in my server. I need to display the reports in my java application page. I want to know is there any control (like .net report viewer control) to display this Thanks balaweblog ...
Wrap a SQL Reporting Matrix
I have a matrix in SQL reporting and I would like it to print on an A4 page. If the matrix has less than 4 columns then it fits but for more than 4 columns I would like the matrix to wrap and show only 4 columns per page. Is this possible? I am using SQL Reporting 2005 in localmode. ...
Should I stick with the ReportViewer control or buy a third party tool?
Hi, we need reports in our web application and there is the free ReportViewer Control from microsoft (normally used, to display reports from the reporting services). I like the fact, that the Report Format (.RDL-Format) from the ReportViewer is a documented XML-Format. But the functionality is somewhat limited, when the ReportViewer is ...
Where are all the places Sql Reporting Server Logs Errors?
It seems like Sql Reporting Services Server logs information in several places including web server logs and logging tables in the database. Where are all the locations SSRS logs to, and what type of errors are logged in each place? ...
Pentaho vs Microsoft BI Stack
Hello people! My company is heavily invested in the MS BI Stack (SQL Server Reporting Services, -Analysis Services and -Integration Services), but I want to have a look at what the seemingly most talked about open-source alternative Pentaho is like. I've installed a version, and I got it up and running quite painlessly. So that's good....
Recommended Charting/Reporting/Dashboard Tool
What charting/dashboarding/reporting tool would you recommend with the following requirements: Windows platform (cross platform optional) Work with an SQL Server 2005 database (hard requirement) Pagination of multiple charts based on selected (multiple) dimensions Chart configuration/options similar to that of Excel 2007 ...
Date Conversion with SQL Server/Reporting Services
I have 2 fields in the database month (numeric) and year (numeric) and I want to combine them in a report that combines those 2 fields and format them with MMM-YYYY. e.g 7-2008 becomes Jul-2008. How do I do that? ...