I Installed SSRS on my Win 7 Machine but I don't see it in my IIS website, and when i try to go to http://localhost/reportserver it asks for credentials which i put my admin account credentials and it doesn't work. Thanks, Marios ...
I am getting this error in the expression editor for a chart control. Category - Fields Item - 'Fields selection frame' is where I see the error The chart IS linked to a dataset though and it works too; how else would the chart be populated with meangingful data when I run it? :) Does anyone know why this occurs? [pic not supplied...
I have a pie chart in SSRS 2008 which when it reaches a certain size is underlapping objects which appear below, but still inside the same rectangle; the height of the pie chart is calculated using the DynamicHeight property of the chart Apparantly: Using Rectangles to Control Item Growth and Displacement Items within a rectang...
Hi, I have SQL reporting services configured to use a secure certificate and when I visit both Reports and ReportManager I get a 404 not found error. The reporting services logs do not contain any error information. I am a bit at a loss to know where to start to diagnose this problem, especially as SSRS is not using IIS. I created th...
In reporting services 2008. I have a report where I have not speciified keep together and my report page breaks when the next group is to large to fit on the page. Also In another report I have a group that expands over 5 pages, and I can't seem to get a group headding to print on multiple pages of the report. In am ...
I was able to get this working is SSRS 2008, but do to the fact that my company only has 2005 servers I need to downgrade the report to 2005. The idea is for a given person name there are two key fields EntityType and EntityId So I have a parameter from a dataset where the Label is the Name and the value is EntityType_EntityId I use t...
I'm using VS 2008 reporting services to building page that will print barcode labels with some data fetched from the database. The labels are on a standard 8.5x11 sheet with 3 across and 10 down. The rdlc file only has the first row of 3 labels and depending on the data, many sheets can be printed. Everything works fine except one thin...
I'm implementing a continuous integration environment with SVN and reporting services. The reports are stored in the SVN repository. when a change occurs, they are automatically downloaded from the repository, and any file changed should be uploaded to the reporting services server. How could you automate the upload/update process for ...
I am trying to generate a report using SSRS 2008. During report processing i am facing an error which states.."An error has occured during report processing .Query execution failed for dataset (datasetno).A severe error occured opn the current command.The results if any,should be discarded.Operation cancelled by user ". The datasetname ...
Hi, i have a graph to plot, with dates in each axis, in x axis i have a date that represent the date pictures of taks was taken, and in the y-axis i would like to put the finish dates of that task, my query returns something like this Task PictureDate FinishDate A 01-03-2010 20-05-2010 A 08-03-2010 ...
I'm receiving this error when trying to see a report. ...
Hi. I recently moved Reports that I created in Studio 2005 for SQL Server 2005 to SQL Server 2008 Reporting Services. In one of my reports cells that should be blank because they have no value display the same value. So instead on blank cells I get cells with the value 119. I don't know where the 119 value is coming from. Has anyone e...
I'm creating a new template to create reports from at a later date. I know how to create one, and I know where to save it. However, the problem is this. Everything that is created on the report uses the default font of Arial with a size of 10pt. I need to set mine to default to Tahoma 11pt. I can create a mock title, mock tables, e...
Where can I find more detail about my subscription errors. I have a data driven subscription, showing status: Done: 24 processed of 24 total; 24 errors. but my trace file ReportServerService__xxxxx.log does not show any errors. It does show the subscription ran, but just no errors. My server DefaultTraceSwitch set to 3 and also trie...
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...
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'm trying to create a stepped line chart in reporting services 2008. By default the transitions between data points move horizontal then vertical. I'd like to be able to tell the chart to move horizontal then vertical when the series value goes up and move vertical then horizontal when the series value goes down. Possible? ...
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 have a report with a table containing hierarchical data of organizations and employees. Under an organization there can be employees and/or other organizations. When I try to do a recursive sum on expenses incurred by an employee the report fails to return a total ONLY when the groups do not have their visibility set to hidden. If I...