Is it possible to hide or exclude certain data from a report if it's being rendered in a particular format (csv, xml, excel, pdf, html). The problem is that I want hyperlinks to other reports to not be rendered when the report is generated in Excel format - but they should be there when the report is rendered in HTML format. ...
When I subscribe for a report, I may chose to have a subject like: @ReportName was executed at: @ExecutionTime I would like a name like this: Your "@ReportName" report covering Sep 10 2008 - Sep 16 2008 Sep 10 2008 - Sep 16 2008 are values of the two report parameters: @DateFrom and @DateTo, respectively. Can I specify something like ...
I would like to be able to loop through all of the defined parameters on my reports and build a display string of the parameter name and value. I'd then display the results on the report so the user knows which parameters were used for that specific execution. The only problem is that I cannot loop through the Parameters collection. T...
The DBAs here maintain all SQL Server and SQL Reporting servers. I have a custom developed SQL Reporting 2005 project in Visual Studio that runs fine on my local SQL Database and Reporting instances. I need to deploy to a production server, so I had a folder created on a SQL Reporting 2005 server with permissions to upload files. Norm...
Is it possible to get notifications using SQL Server Reporting Services? Say for example I have a report that I want by mail if has for example suddenly shows more than 10 rows or if a specific value drop below 100 000. Do I need to tie Notification Services into it and how do I do that? Please provide as much technical details as possi...
I need to create a repeatable process for deploying SQL Server Reporting Services reports. I am not in favor of using Visual Studio and or Business Development Studio to do this. The rs.exe method of scripting deployments also seems rather clunky. Does anyone have a very elegant way that they have been able to deploy reports. The key ...
where can i find the best tutorial about MS SQL server reporting services.. ...
Can anyone recommend a good resource -- book, website, article, etc -- to help me learn SQL Server Analysis services. I have no knowledge of this technology right now but I do constantly work with SQL server in the traditional sense. I want to learn about Cubes and Using Reporting Services with it. I want to start from the bottom but ...
In my ReportViewer control, when I click on Print Layout, the background turns black on the report. This must be a bug. Is there a workaround? ...
How can you programmatically set the parameters for a subreport? For the top-level report, you can do the following: reportViewer.LocalReport.SetParameters ( new Microsoft.Reporting.WebForms.ReportParameter[] { new Microsoft.Reporting.WebForms.ReportParameter("ParameterA", "Test"), new Microsoft.Reporting.WebFo...
Can anyone recommend a good 3rd party control(s) for MS SQL 2005 Reporting Services. If you know some open library or implementation of such controls that could be very useful too. ...
I have a report that I built for a client where i need to plot x 0-100, y 0-100. Lets imagine I have these points: 0,0 2,24 50,70 100,100 I need to represent these as a smoothed line chart, as the application of it is a dot gain graph for printing presses. Heres the problem. The line draws fine from 100,100 (top right) down to 2,24. B...
Currently I am working on a web page that has six ReportViewer controls that are using remote processing and that allow for drill-down. When a user clicks on one control the entire page refreshes and the other five reports all refresh as well. Users are currently requesting that the refreshing of the other controls be removed in favor of...
I have created an end user model and deployed it. Any report that I create and run gives me an error: Report execution error The report might not be valid or the server could not process the data. Semantic query execution failed. Invalid column name 'rowguid'. Query execution failed for data set 'dataSet'. An error has occurred duri...
I'm trying to profile SQL reporting services, used from ASP.NET application. In SQL profiler all the SQL run by ASP.NET shows up. It looks like the reporting SQL (from the RDL) doesn't show. Is there some setting or filter I'm missing? ...
I have IIS6 configured such that browsing to http://localhost:8082/Reports gets me the reporting services default home page, which is all as expected. However, when I try to publish a report via Microsoft Business Intelligence Visual Studio 2005 I get the following error: A connection could not be made to the report server http://localh...
I find SSRS produces typically ugly reports and the .rdl usually ends up being a pretty complex beast, hard to tweak and maintain. Do you know a better toolkit? It doesn't necessarily have to do it all by itself. It could be split in parts: Chart generating library Listing generating library Form generating library Plus some custom ...
In order to create the proper queries I need to be able to run a query against the same datasource that the report is using. How do I get that information programatically? Preferably the connection string or pieces of data used to build the connection string. ...
In this MSDN article, MS explains how to specify other delimiters besides commas for csv-type exports from SSRS 2005: http://msdn.microsoft.com/en-us/library/ms155365%28SQL.90%29.aspx ...however, literal tab characters are stripped by the config file parser, and it doesn't appear that MS has provided a workaround. This entry on Micros...
This question was very helpful, however I have a list control in my report, and when the report grows over 1 page - data in the header only shows up on the last page of the report. Apparently, hidden textboxes have to be on every page of the report for header to function properly, how do i do that? The only control i have in the list is...