I am hosting a SSRS report through the SSRS Report Viewer Control inside a ASP.NET web form. For the action property on a text box I am setting the following expression. =Parameters!URL.Value & "?customerid=" & Fields!CustomerID.Value The desired result is something like this. URL = “http://www.google.com/somesamplepage.aspx?custome...
Hello, I've just started working with SSRS 2008 and SQL Server 2008. I am trying to create a report that involves querying about certain sectors and their sub sectors (for example a sector would be something like 'financial sector' and its sub sectors would 'bank', 'transfer'...etc ). However, the sectors and sub sectors are changing s...
Hey guys, I have an SSRS report that looks something like this: Column1 Column2 Row1 2 A Row2 2 B Row3 2 C Row4 6 A Row5 11 E how can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color,...
I've tried everything I can think of to change the rendering parameters for a report that I need to render as a 300ppi TIFF. Here's one of several attempts using the URL approach. As we went from 96ppi to 300ppi the size of the 8.5 x 11 image increases dramatically, but the resolution remainded at 96ppi. //s0550284/ReportServer?/ERecor...
I have a bar chart with horizontal bars. I used this article to setup the dynamic height property: http://blogs.msdn.com/b/robertbruckner/archive/2008/10/27/charts-with-dynamic-size-based-on-categories-or-data.aspx Everything looks fine in the viewer, but as soon as you go to print layout, pdf, et.al there is about 50% more blank space...
I am writing a report in SSRS 2008 that has the following advanced layout: Static Static Static Static Group1 Details Static Static The settings for the top 4 static rows (which are my headers) are set to RepeatOnNewPage = true, FixedData = true, and KeepWithGroup = After. When viewing the report through SSRS or through V...
I use SQL 2008 I have report with few groups on the left, then some numbers and another numbers (further on the right) which has to be groupped as well. Field1 Filed2 Filed3 Num1 Num2 Num3 Num4 fff sss aaa 1000 2000 3000 4000 bbb 2000 3000 ccc 4000 5000 i.e. Num3 and Num4 are the same for eac...
The database which I report from most often is not properly typed. Almost every field, with the exception of some integers and datetimes, are CHAR fields. This can cause problems with SSRS layouts because some fields have tons of trailing spaces. This causes layouts to be messy and such. I often rtrim these fields in my scripts to prev...
SQL Server Reporting Services (SSRS) 2008 R2 I've set up a shared dataset that takes a few minutes to execute. It is shared between three reports, and is the core data for these reports. (Some other datasets exist in the reports for parameter population.) I've enabled caching on the dataset, and would like to add the dataset execution ...
SSRS report calls sproc from SQL 2008 and it takes 30 sec to render it. If I call the same sproc with the same params it takes 3 sec to finish. SQL server and SSRS are on the same box. What can I do about it? ...
I've designed my report and then when I click on the Preview tab, nothing appears and I get System.Runtime.InteropServices.COMException (0x80004005): Command "View.Output" is not available. at EnvDTE._DTE.ExecuteCommand(String CommandName, String CommandArgs) at Microsoft.ReportDesigner.Utils.ShowOutputWindow(IServiceProvider sp) ...
Our SharePoint 2007 system currently does not have any SSRS Web parts available. The problem is that when using a Web Viewer Part, reports are being cached by the page. I cannot remember if the SSRS Web Parts have a no-caching setting and which web parts should be installed to veiw reports on a SharePoint page. I found several possibili...
In SSRS 2008 Report parameters are taking time to Load(Is this a common issue) I am using an evaluation version..is it because of that.Calendar control used in Report parameter is throwing javascript error while generating report..Any solutions??/ ...
I'm attempting to create data source views on a terribly designed database which lacks primary and foreign keys. I want to be able to use Data Source Views to work with SSRS Report Models. I cannot create them with the wizard because "Add Related Tables" doesn't work and BIDS cannot determine the link. When I re-open the DSV and attemp...
I'm trying to help my power users have more access to our data so I don't have to interrupt my work (playing Pac-Man) 25 times a day writing Ad Hoc Queries and such. I'm trying to use Data Source Views, Data Models, and Report Builder 2 and 3 to allow them to have access to cleansed data in which they can safely do their own basic anal...
I have SQL 2008 (not R2). I would like to have a matrix report where user can select one of the SQL resultset columns to be the matrix column group.. For example A B Value a1 b1 10 a2 b2 20 a3 b2 30 So the possible matrices could be (user selects from dropdown with A, B). By A a1 a2 a3 Value 10 20 30 By B ...
I'm looking for a clean approach to using SSRS 2008 to provide our customers with common reporting functions: Standard Visual presentation for the report, with strong aesthetics, drill downs, graphs etc. Only one visual format will be provided for all customers. Customers will also want to access the raw data to the report in a variety...
I'm trying to export reports using the URL In 2005, I could use rs:Format=HTML3.2 and life was good Now, with 2008, it appears all I have is HTML4.0 but I need it in HTML3.2 for a variety of reasons, the main one being, it is basic html and works in all our viewing devices. Is there a way to get this renderingExtension enabled in 2008...
Is it possible to have multiple series of stacked bars in SQL Server Reporting Services. So in effect, a group within a group? ...
I'm creating an analytical US state map using SSRS. I've matched the STATE_ABBR field to my db's state abbreviation field that is of data type VARCHAR(50). I changed the data type to VARCHAR(2) and CHAR(2) but still get the following error: The expression that specifies the binding field 'STATE_ABBR' for layer 'PlygonLayer2' in the m...