I asked a similar question a few days ago, but there's no harm in posing a more challenging one. To make a long story short, I'm getting back a data set from SQL Server and I don't know how to group it correctly on the report. Here's some sample data: SELECT companyID = 106, userID = 71152, productID = 11,taxID = 216, quantity = 78, to...
hello guys recently i joined a company. They assigned me a task is to improve the performance of existing SSRS Reports . i looked at the Stored Procedure's which are running fine .But when it comes to Report execution it's taking time . Please let me know how to start on this thing? Thanks in Advance ...
I have tried everything that most forums have said and still cannot get other people in the network to see this report. Here's the things I have tried: in servername/reports under properties tab i have added my user "domain/username" and given him all 5 roles (Browser, Content Manager, My Reports, Publisher, Report Builder) in the sit...
Is there a "for Dummies" guide to subreports? I am having a hell of a time trying to figure out how to get this working. All of the guides I have found seem to summarize how to set it up, but I can never get it quite working properly. What I want to do is print a master record and all included child records. I have a view setup for both...
I came across this question in related questions which basically asks the same thing. Is there a way of exporting and importing subscriptions to SharePoint-hosted reports that were created in SQL Server Reporting Services? Scenario: During report re-deployments, reports are deleted and re-created, and the associated subscriptions are de...
I have a number of SSRS 2008 reports that need to be exported to word in landscape mode. The reports look great when exported but when you attempt to print (or even preview) the page Word appears to be trying to print the reports in portrait mode thus cutting off all content to that is more then 8.5" from the leftmost side of the page. ...
Hi, is it possible to make a series in a chart optional (i.e. only rendered when the user clicks a checkbox, in case the corresponding query takes a while and may not be required)? Or are there any alternative solutions where users can incrementally select the data series/charts they would like to see? ...
I am trying to setup SSRS 2008 on Windows Server 2008. It seems to work as expected when I access the web interface through HTTP, but when using HTTPS the following error is what I get: "The underlying connection was closed: An unexpected error occurred on a send." From a look at the log files, it is revealed that the inner exception is...
We have an opportunity to purchase 3rd-party chart controls for SQL Server Reporting Services. We are currently using SQL Server 2005 database engine and reporting services, but are contemplating going to 2008 within the next 6 months to a year. What 3rd-party charting controls do you use? What do you see as the good and bad points ...
I have a reporting services dataset returned from a stored proc. I'd like to further filter the data based on a parameter. I've added that filter to the dataset but it's still giving me all of the data. Does filtering work with a proc based dataset or just with a cmd text based select statement? Before I get bombarded with 'just add the...
Hi, Last night I installed sp3 and cu1 on a 64 bit SQL 2005 failover cluster. Everything went well. Reporting services is installed on the primary node. It now cannot connect to Oracle. The initial errors seemed to be related to this: http://support.microsoft.com/default.aspx?scid=KB;en-us;870668 I granted network service access, b...
I am making some changes and need to change the DataSource for my report. How can I do that without losing all of the work I have done? Assume the field names are the same. Update: The reports are still in Visual Studio and I need to change from a TableAdapter to a DataTable which I will fill through a class. Update 2: Currently it is ...
Hello, I have sever nested subreports that by default are hidden and are only made visible when toggled via an element in the parent report. I want SSRS to not execute the query statements for these subreports untill they are toggled and made visible. The subreports recieve their parameters from their parents, and not from any user inpu...
In the SQL queries for my reporting services datasets, I'd like to be able to use the following pattern: -- Used to enable/disable diagnostic statements declare @DEBUG bit set @DEBUG = 0 -- Get current date/time. declare @now datetime; set @now = getdate() if @DEBUG = 1 select @now as now -- Create a table to contain the chart values ...
I created a report in reporting services 2005 with a report page size of 14in x 8.5in. The report looks fine in the reports manager and also in the report viewer. The issue is when I export the report to PDF, the page size in Adobe states 14 x 8.5 in but when you hit the print button, it selects Letter size (8.5 x 11) instead of choosing...
Using SQL Server 2005 and Reporting Services, I have a stored proc that returns several columns, one of which is of the XML data type. Can I manipulate/format/style that XML column in my Reporting Services report? If so, how? ...
Hi, I have a report to build that has many different fields showing various results. As these numbers are not intuitive, I need some sort of mechanism to display a balloon tooltip when the user hovers over or clicks on a number. I am open to either Crystal reports or SSRS. I will just be limited to the free editions that come with visua...
I already searched for this and I did not find the answer I was looking for. I am writing a windows forms program with C# .NET and Visual Studio 2008. I am using Reporting Services and rendering the reports using the .net provided report viewer. The data source for the reports is SQL Server. I am rendering the reports locally. I am ...
Hi, I am working on SSRS Line chart report. I have plotted data for Fuel consumption for every month using data values (Fuel consumption) and category grouping (Jan-Dec). Data can be inconsistent i.e. for one or more month. I am facing problem in plotting lower limit and upper limit series for the data, which has to be consistent i.e ...