Report Builder error when opening report

Our user created a report in Report Builder and saved it to Report Server. The report executes just fine from Report Server. But when we try to open the report in Report Builder to change it, we receive this error: "Cannot open this item. This report cannot be opened in Report Builder. Detail's value expression comes from a different query grouping." This is running on SQL Server 2005.

conditional color formatting for line chart background color

Does anyone know how to or even if it's possible in RS2008 to change the background color of a chart based on the data point values being charted....for ex If the data point value is > 80, then the background color for the that y axis range should be "RED", if data point is between 61 & 79, the backgrouund color for that data range should be "YELLOW" & if the data point is <60, the background color of that data range should be "GREEN".. THis would essentially create a "RED-YELLOW-GREEN" banding appreance for the background of the line chart.... Please let me know if this i

date format

Hi all, I am getting the results from reporting services using Excel as datasource. The date format is dd/mm/yyyy hh:mm:ss. I want out put from reporting services should be dd/mm/yyyy only. I am using the query as: select date from Excel$ where datepart("m",date) = datepart("m",@rundate). please help to modify the query.

Page Break Separator Row

I have a page/section/detail layout with tables that may or may not repeating and continue across pages. I've followed Chris Hay's hack to get the "continued..." at the top of the next page but the report design requires a blank row immediately after the last detail row before it continues to the following page. The blank row will then close the table with a border. Is this possible? I have made countleess attempts. Thanks in advance

help on composing an aging report for transactions

hello all, I am new to SSRS. I need some help on how to create an aging report in ssrs. This is what my report should look like: Month identify $ $closed $Recovered $Open 0-30day 31-60day Jan 2009 $$$ $$ $$$ $$$ $$$ $$$ I am having trouble on the days column. My user want these fields to contains the total $$ amt that was recovered in 0 - 30days and 31 - 60 days. how to do that? Please help.... Sherry From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-

How to find a record in a dataset

Hello, Is it possible to find a particular record in a data set using RDL functions? //Misha

Sometimes charts are not rendered in a good way

I have some reports (SSRS 2k8 enterprise SP1) with a set of charts and a data table On Page one i have 4 charts, 2 of them are on the same dataset than the detailled table on page 2 Usually the reports works fine but sometimes when i run the report i have no details in my charts =>My pie chart have only one label instead of many and don't have any label =>My bar chart have only one bar But all ma data are good in the table in page 2 so it seems it is not a data issue And if i just click the "view report" button without touching anything the chart comes back to normal I'm

Conditional colours for drill-down

Hi guys, I have one q about my issue. In matrix I have column drill-down : Date->Status 2010 Approved Submitted Cell with data have TextColour condition :=Switch(Fields!EffortStatus.Value="Approved","Red",Fields!EffortStatus.Value="Submitted","Yellow") When I cklick Drill-down(+) on Date column , values in columns have right colourfor each status. When I click Drill-up (-) on Date column, Staus columns is hidden, but text color for summarized values is Red or Yellow anyway. Ho

inverse log scale on 2008 guages

Hi guys, We have recently upgraded to SQL2008/64 and are starting to make use of the new gauges installed. Many of our KPIs revolve around very high compliance targets, normally 95/98/99 %. I would like to be able to create scales that show 0-100% but with the 90-100% taking up roughly half the dial. I can do it the other way round (0-10 taking up half the dial) using a log scale, but the software will not let you use a -ve or fractional log value, the minimum is 2. Does anyone have a trick to resolve this. Obiron -- Message posted via SQLMonster.com http://www.sqlmonst

"FOUND ORPHANED REQUEST" error

This error occurs several times a week, preceeded by this error: runningjobs!WindowsService_1!f9c!05/17/2010-06:52:24:: e ERROR: Error in timer Database Cleanup (NT Service) : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. We are running SQL 2008 64

vbTab or Chr(9) not working

Im trying to use the vbTab or Chr(9) in order to get a tabulator character. The result is always a single space instead of a tab. Any ideas why? ="test1" &vbCrLf & "test2" results in "test1 test2" is the tab character not supported??? Thanks for any help

Question on SSRS

I am trying to create a space usage report and the challenge I have is the date is stored as a varchar in the column in the table. I can convert this easily in sql (so that when you group and order the data it does so correctly when there is data from the prior year) however I cannot get the data to group in the report properly. Here is the query: select db, sum(tot) as TotalAvailSpace, sum(used) as TotalUsedSpace, sum(tot)- sum(used) as TotalFreeSpace, cast(entrydt as datetime) from dbaspace where entrydt>=(getdate()-361) group by cast(entrydt as datetime), db order by cast(en

Financial software firm needs SQL Server DBA - Metro Atlanta.

Looking for Computer Science graduates knowledgable in SQL Server with 1-3 years experience. Marietta location, excellent office environment, superior benefits. To apply please visit http://ejob.bz/ATS/jb.do?reqGK=63062 www.evestment.com.

Connecting to a shared SSRS data source from BIDS

I'm just starting out using BIDS and creating reports in general. I've been using Report Builder and have no trouble accessing a shared SSRS data source by specifying the Report Server (http://<Server>/ReportServer) in the Options...Settings, from there I can view and use any predefined data source in a report. How do I specify in BIDS that I wish to use a preconfigured shared data source from SSRS, I can't see any obvious option. Any advice gratefully received. Thanks David

How to embed reports in Web Forms and Windows Forms?

Is there anywhere I can get the details about how to embed reports in Web Forms and Windows Forms? Seems like it require good skill and not that easy Thank you Regards Raj

ReportPath and Report Server URL

My reports are in http://localhost/kra/Report Services/tutorial/sales order.rdl It is published/deployed and I am able to access it by this url: http://localhost:8081/ReportServer/Sales Orders http://localhost:8081/Reports I am trying to integrate with asp.net page, which is in, http://localhost/kra/aspdotnet At design design time i have set ReporServerURL as "http://localhost:8081/ReportServer" and ReportParth as "/Report Services/Tutorial/Sales Orders" Nothin is displayed. What is correct ReportPath? and ReportServerURL?? Thank you Regards Raj

Decimals in Excel

Hi , I am using P0 and N0 to get rid of decimals and they are still appearing in excel ? Any suggestions ? Regards Malcolm

SSRS 2008 64bit Oracle Datasource

I am currently getting ready to start using SSRS 2008 64bit with Oracle 64bit datasource's. Has anybody run into any issues creating a Shared Oracle Datasource to version 10.2 64bit? Thanks

How to reference 2 datasets within a table in a Reporting services report

How can i calculate within my report the movements of two columns coming from 2 different datasets within a table in a Reporting services report. The 2 different datasets are MDX queries with exactly the same number of rows but running over 2 different periods. I just want to calculate within the report the different between the two columns data i.e col A - Col B. I am only able to reference one dataset within the table and for the second dataset, I can only reference the Sum of this column measure or the First/Last record of this column measure, but not each data rows of this column

Word Render destination array error

Have have built a report that is a form of 8 pages that I wish to render as a word document. It has a number of boxes and tables. I am getting an error message stating. Destination array was not long enough. Check destindex and length. From what I have read (which is fragmented to say the least) it is to do with too many tables or long field values. I have elimnated the fields values but cannot elimnate the cells and tables problem as it uses them to do even the smallest formatting. It renders fine in pdf, but that is not an option. Any tips other than 3rd party?

Changing rows by Columns

Hi, I have a query. I need to show the result of this query changing rows by columns in the table of my report. How I can to make it in SSRS 2005? Best regards and thanks!! Julio

Firewall configuration to administrate Reporting Services

Hello! Into a Windows domain, I have 2 windows 2008 servers. All of them have their firewall activated. The 1st one is the host for SqlServer DB engine, and the 2nd one hosts Reporting Services. As you gest Reporting Services use the SQL Server DB Engine on the 1st server. Today, the firewall is configurated to allow access to SQLServer DB Engine on the 1st host. I can create queries and administer the db throw Management Studio, from any computer in the domain. And the firewall on the 2nd host is configurated to allow me to access the Reporting Services web site from an

SSRS 2008 - Tablix formatting

I've creating a tablix based report using a dataset source that resembles an order, order item model. We have a tablix setup with the order item line as the detail group, and have a lot of information in the 'order header' that we are trying to display in the group header in the tablix. The report is splitting across pages in strange places and we think that this is because the header information is going over more than one page. It is trying to ensure that it fits a detail row on, but rather than spliting the table at the end (ie, when it runs out of page) it is doing it

Renting a cottage for the family for a week or more allows you the luxury of a private vacation

FAMILY COTTAGE VACATIONS Renting a cottage for the family for a week or more allows you the luxury of a private vacation residence that feels more like "home" than a hotel. Kindle Cottage can be a perfect location for a personal retreat - provided you are not substituting one set of distractions for another. Have a great family getaway to the prime lake of the Kawarthas. Only 1 hour from Toronto and 20 minutes from Oshawa. Large level lot for kids, excellent fishing, 5 bedroom cottage 2.5 piece bathroom, large deck. Swimming pool, Jacuzzi, 60=94 Flat Screen TV, DVD and Lake View.

Using reportingservice2005 and reportingservice2006 soap interfaces in the same application

I am just finishing off my application- Reporting Services for DOS, currently I have a work around using the following URL: http://blogs.msdn.com/bimusings/archive/2008/05/15/problems-making-web-reference-to-reportservice2006-unable-to-import-operation-setreporthistoryoptions.aspx this works but not all the functions are available now in the reportingservice2006 soap interface This is how to reproduce the issue: 1. create new project in vs2008 (winforms or console appliction) 2. Add web reference for reportingservice2005 call the reference rs2005 3. Add another web referenc