I have a SQL Server 2008 report with a bit field - IsUS I'd like to display embedded images depending on IsUS bit value. How can I reference embedded images within a column expression? Below is the result after applying Fillet's answer -------------------- Result -------------------- ...
I have a report that i'm trying to display in a matrix. The Row is grouped by a column called Category. The column name is vcName. The detail is vcTaskName. The part that i can't seem to figure out is that only one row will show up even if there are multipal tasknames with that row value. Try to give an example. Category vcTa...
Hi, I have a SQL Server 2008 reporting services report which runs fine in preview mode using Visual studio 2008, but when I deploy it to the report server and run it there, it throws the following error. what does this error mean and how can I fix it? Thanks in advance. "There is an error in XML document (1, 170604). '.', hexadecimal val...
Hi All, I'm creating an SSRS client side report (RDLC) and am using custom objects to populate the report. The report is an invoice report which has line items. The report datasource is a List<Invoice>. Each Invoice object has a List<LineItem> property that should map to the invoice line items on the report. This seems like it shoul...
When attempting to deploy a SSRS 2008 R2 Report to my localhost/ReportServer, or trying to login to localhost/reportserver (via web browser), I am not able to get any further than a security error message. When trying to access the report server via a web browser, I'm prompted to enter my login credentials. Even though I am the admin o...
I am stumped. I have a select statement that returns the data fine in the data pane, but in the resulting report, one row is our of sort order and falls about 25 rows down in the data where it shouldn't be. How do I trouble shoot something like that? Thanks!i ...
How can I get a list of available webservices from a server/directory? For example from: http://localhost/ReportServer_SQL2008/ Which should at least give me ReportService2005.asmx I was wondering if there wasn't a ReportService2008.asmx ...
My question is similar to this one but I'm having some problems with the actual implementation. I've got a report (.rdlc) in the business layer of a 3-tier app. I've got an object in the BL (EmployeeManager) which has a GetEmployees(Expression as Expression(Of Func(Of Employee, Boolean))) As IQueryable(Of Employee) method. As I didn'...
As the title says, i'm trying to figure out how much RAM is needed to generate and export to excel a large report using SQL Server Reporting Services on Windows Server 2003. It is not an option to upgrade it to SS2008 and also not an option to export to CSV. Strictly from a hardware point of view what is a good configuration for a high...
I have 2 parameter lists. 1 is Owner and 1 is unit which is dependent on owner. These are multiselect parameters. By default select all is chosen for both so right when you enter the report select all is selected for both Owner and Units. Now when I uncheck select all and check 3 owners it again selects checks all units in the unit lis...
I have a report in SSRS 2005, with an embedded SQL query (no stored procedure). This report is running slower in SSRS than the query will run in SSMS. I'm wondering how to troubleshoot this, and if there are any differences in the way query optimization works for a report with embedded SQL code vs. a stored procedure. Thanks! ...
Help me please. This thing drive me crazy. It really should be a simple solution but I can't find it, even with Googling. I have a subreport that display deposit transaction banking statement from account (customer). This subreport will be accessed through main report that loop all accounts in one branch, so it's like a batch report pr...
What is the best way to re-use reports on different tables / datasets? I have a number of reports built in BIRT, which get their data from a flat (un-normalized) MySQL table, the data which in turn has been imported from an excel sheet. In BIRT, I've constructed my query like this, such that I can change the field names and re-use the ...
I have one web server & one DB server (running SQL SERVER 2008). Both the servers are in different domains. The web server is allowed to communicate(the communication takes place internally without the intervention of firewall) directly with the DB server, it is given Admin privileges & the DB access through SQL is going on without any p...
Hi, I'm new to reporting so need some good information/resources to help me get some reports set up in our 3-tier app. We currently have: UI (ASP.Net MVC 2 at present but also winforms in future), Business Logic and DAL (Entity Framework - Code-Only ie no edmx) The BL has "manager" objects for selecting and manipulating entities. Now...
Are there any other ReportViewer designer beside the Visual Studio (with GUI of course I know that any XML/TEXT editor can change definition of .rdlc file) ? One day when I finish my rich (fat) client application at all, Ill love to try embed in report designer, so end users can do cosmetics modification of theirs report files without ha...
this is the desired result i needed. i had populated State(RowGroup), Male(ColGroup), Year(ColGroup) and the data inside the matrix. to calculate the data count total(100), i used the feature AddTotal by right clicking it. But in this report i have used expression to calculated individual Percentage. Expr1: to calculate the percentag...
my environment is SQL 2005, SSRS 2005 , .net 2.0 Client is experiencing following issue on two different printers. ( Canon and Lanier LD140). We have a report which is designed as landscape report. When report is send to print, First page is rendered in portrait mode(cutting of the information on the right side. ) rest of the pages ...
hi, I have to apply group on several columns in a report. I have to keep some of the columns in a rectangle. and I have to apply gruop on rectangle on regular columns too. Please tell me in what way I can do this. Please respond. Its urgent!!!! ...
I need to install SSRS. Have alreay installed SQL Server. Dosn't seem possible in Add/Remove programs and when I run the installation wizard again it seems to think its a fresh install. Whats the best appraoch for installation of SSRS after you have SQL Server installed ...