I have an .rptproj that works with VS 2008, but I can't convert it to VS 2010 This link seems to confirm the issue but provides no options: https://connect.microsoft.com/VisualStudio/feedback/details/532664/cannot-open-a-sql-reporting-services-rptproj-file?wa=wsignin1.0 Any suggestions or new info on this? ...
Folks, I have a really odd behavior here: I have a SQL Server 2008 Reporting Services report which gets grouped and sorted dynamically. One of the column in my data set which I display is called LanguageId and I was trying to get a grouping going by this LanguageId field. I checked, double-checked and triple-checked the data being retur...
Hi everyone, I'm trying to generate a report directly from the code (to send it by mail after). I make this in a windows service. So here is what I'm doing: Dim rview As New ReportViewer() Dim reportServerAddress As String = "http://server/Reports_client" rview.ServerReport.ReportServerUrl = New Uri(reportServerAddress) Dim paramLis...
DataTable reportData = this.GetReportData(startId, endId, empId, minAmount, reportType); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.LocalReport.ReportEmbeddedResource = "PDCL.ERP.Modules.Marketing.Reports.rptDoctorDeta...
I need some help with authentication when using the web reportviewer to view SSRS reports. In IIS I've set "Windows Authentication" only and unchecked "Anonymous Access" and the other checks in the Directory Security tab. The result in my website is that WindowsIdentity.GetCurrent() returns the ASPNET user and Request.LogonUserIdentity...
Question: I have created a series of reports that allows you to drill down and/or jump to another report. They work perfectly until... I am now setting up these same reports for specific colleges. The original report had a parameter where you could select what college you wanted to see. I am changing that parameter to have a default ...
I am new to web services, How do i use web services as a source in reporting services. Thank you for help Kumar ...
Hi there In report design, I have 2 tables (Current and Proposed) the structure like this: Current Parameter | Value | Rate | Total Value ... Proposed Parameter | Value | Rate | Total Value ... Each bottom of the table (Table Footer), I have something called: "Total: " which is a sum of Total field. I called these textboxes ar...
Hi, I have a fairly basic SQL Server Reporting Services report that is using nested row groups. Each sub-group depends on expanding its parent to be visible which is all pretty standard. The layout is something like this: { Company { { Car SUM(Price) { { { Part Price My desired result when expanded is something li...
I am developing a java application and I want to use: Reporting Analysis Data Mining Data Integration tools to be shipped with my commercial application that I am NOT going to sell as an open source application. So I want to know which tools I can use in my app. Actually I am evaluating PENTAHO and JASPER but I don't understand lic...
I would like to make a lookup within a SSRS expression, is that possible ? The idea behind that: for a check report I have to decide if a value on the report is ok, if not it should be shown with a red background color. However instead of keeping the values that are ok in the expression I would like to use lookup in a sql table where th...
I know how to alternate the background color of individual rows in a Report Builder 2.0 table, but what I want is to have all rows within a row group to have the same background color, and I want that color to alternate with row groups. --------------------------------------------------------- group 1 | row 1 in group 1 - white backgrou...
How to create a sql query to return the number of occurrences of sick days. Where one occurrence is defined as consecutive days out sick. It would also be considered one occurrence if the a weekend fell within that time period or a holiday fell in that time period. Examples of what is consider one occurrence: A person is out sick Mon...
I have a class which uses a list for passing to ssrs and for each report I had to define a list of that type. like this List<ReportClass1> ReportClass1prods; public List<ReportClass1> GetReportClass1 { get { return ReportClass1prods; } } List<ReportClass2> ReportClass2prods; public List<ReportClass2> GetReportClass2 ...
We're looking to hire a business intelligence developer - knowledgeable in SSAS, SSRS, data warehousing, etc. My job in the interview process will be specifically to vet the candidate on SQL Reporting Services. Assuming a 60 minute interview, what sort of questions or challenges might be effective in determining a developer's level of k...
I am trying to filter a query by two (multi select) parameters. It works fine when doing this for the first one, but complains when I add the the second one. Is my syntax wrong is there a better way to achieve what I want? ...
Working with rdlc report for oracle procedures, the table adapter wizard will not work.How can populate a typed dataset with the result of Objectdatasource so that the fields from dataset can be droped into the rdlc report ...
I have created a SQL Server Reporting Services Report Builder 3 report that contains a list of several items from a SharePoint list. I would like the list on the report to be a numbered list, so that when exported to Word, if a user adds another item to the document, the numbering is updated automatically. I can simulate a numbered lis...
Crystal reports isn't working on different servers because they use different connection strings and crystal reports can't use the connection string stored on the web.config to access the database. Is there an alternative to crystal reports that can use the connection string on the web.config file? or does someone know how to fix the p...
I am new to ssrs. I have a report that gets data from two databases. I can create two datasets that connect to two different databases. The databases are third party and I cannot create stored procedures on the databases. My issue is that I have to combine the data from the two queries. Please help me with this issue or point me to loca...