We store all our dates SQL Server 2008 database in UTC time in DateTime columns. I'm using SSRS to create reports and I need to convert all the times on the reports to the Time Zone of the computer where they're running the report from. I know could always just pass in the current timezone offset as a parameter to the report and add o...
Hello, I created a report and now I want to use it an my ASP.NET application...I wasnt able to get it to work. How do I add the created report to my web app? Whats the difference between Business Intelligence Development Studio and Visual Studio? Thanks ...
Hi everyone, Right now I have an application which uses Reporting Services to render reports. This is working nicely, I call each report with a given value (e.g. a ClientId), and the report gets rendered correctly. However, what I'd like to do now is being able to send multiple ClientIDs to the report, and would like to get 1 pdf file ...
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...
Greetings! I am using SSRS with MS SQL Server 2008 R2, which has the new feature of supporting shared datasets. First, I created my shared dataset, and made sure that it worked correctly and had a good connection. That worked great. Second, I created a new report (Let's call it "ReportSub"), and I had it use my shared dataset. The rep...
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...
SSRS 2008. Working with 3d Area Chart. In Excel you can label the X, Y, and the Z Axes, but in SSRS I seem to only be able to label the x and y axes and the Z axis labels seem to be only go in the Legend. I don't want a legend though, I need to have the text describing each color area right next to it. Thank you very much! ...
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? ...
I have a report that has a Map with spatial data. Clicking an object on that map sends you to other pages on the site. I have tried a few different ways of displaying the report: If I put a ReportViewer on the actual page, the page sometimes takes 10+ seconds to load, but the report viewer creates a fully operable image map. If I crea...
I'm building a report of case results with a parent-child grouping on the row group and single column grouping: Parent Row Group: Location Child Row Group: Result Column Group: Month Running across the report are months in the year, and running down the report are the location and the different result breakdowns for the location in...
I am trying to use an existing dataset as the datasource for a rdlc report inside of an ASP.NET web application in Visual Studio 2010. However, when I go to choose the dataset in for the report, the existing dataset is not available unless it exists in the root directory of the application. This was not the case in the 2008 version o...
I'm trying to create a CI process for SQL Server Reporting Services. I am fairly new to TFS but quite experienced with MSBuild. In the past I've used a combination of MSBuild with Team City so the whole build process is more or less custom. Here lies the start of my problems, as the solution I am deploying only contains Report Server p...
Hello I was here trying to figure out why my Reports manager is empty, there's no tabs at all. I installed SQL Server 2008 complete, but didn't not configure Reporting Services. When installing SQL Server 2008, this Windows 7 version didn't have yet IIS installed, I installed it later. I don't see where is this localhost/Reports phy...
I have an application that retrieves a report from SSRS 2008 and prints it automatically. This works except it always prints the report in Letter/Portrait. This particular report is Letter/Landscape. I have tracked the problem down to when calling the Report.GetDefaultPageSettings() function for this report, it returns PaperSize.Heigh...
I'm having a problem with my SSRS 2008 configuration at the moment. This is how we are currently set up. 1 server hosting SQL Server and SSRS, no integration with sharepoint etc. Users access the SSRS web application, and then from there they access the "Report Builder 1.0" too, which they can use to create and run reports based off a...
Can anyone tell me the site for getting SSAS 2008 and SSRS 2008 tutorial ? In PDF file if possible ? ...
Hi, Can someone tell me whether this is possible. I have an existing SSRS project which contains a SSRS report (Call it report1). I have created another SSRS Project and in this i added the Report 1 SSRS report to it. The problem is that when i add the reference it is creating a copy of the SSRS report in the new projects folder. What i...
I have a filed in a table in Oracle that contains and XML formatted string. In this string is a node value that I need. How can I parse an XML string contained in a database column/field? ...
I have SharePoint 2010 and SQL server 2008 setup on two machines. I have SharePoint using SQL server for all SP databases. I am trying to get reporting services integration to work, but there seems to be some permissions issue with the SSRS service. From what I understand, it should be possible to navigate to http://server-name/ReportS...
Is it possible embed Silverlight content within SSRS ? (Like an image I would like to use a Silverlight viewer to show the content in the SSRS report). ...