Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > march 2006 > threads for thursday march 23

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Vs2005 Project->Import Reports, Where is it?
Posted by Rob Dob at 3/23/2006 9:29:28 PM
Hi, According to the vs2005 documentation provided, there is suppose to be a "Import Reports" option within the Project menu item. This option is required if you wish to import reports from access.mdb's in order to make use of them within the Microsoft reporting technology. The documenta...more >>


Export to CSV in SQL Server 2000 Reporting Services - change delim
Posted by Nick Zdunic at 3/23/2006 5:59:01 PM
Is it possible to specify the delimiter character - I need to to use a semi colon rather than a comma...more >>

How to pre-select a printer in RS print dialog box?
Posted by C17 at 3/23/2006 5:49:30 PM
My user has already selected a printer before he/she has gotten to the part of the program where RS 2000 SP2 reports are displayed. Now I would like that printer to be pre-selected in the dialog box that comes up when you click on the Print icon in the browser view. Currently, the default...more >>

Custom Bar Chart colors?
Posted by klar02 at 3/23/2006 4:15:13 PM
I am also looking for a way to specify my own list of colors for bars in a bar chart. Please let me know if anyone has a solution for this. Thanks Again, Andy ...more >>

RS 2005 Printing fails if client printed before from RS 2000
Posted by SteveIrwin at 3/23/2006 2:17:01 PM
It seems that the RSClientPrint activex control for printing in RS 2005 has the same version as the RS 2000 control. So if users already have the RS 2000 version of the control installed on their machine, then they try to print from a RS 2005 report, they get an error. Is there a fix for this?...more >>

Parameter Query - All Option - from Access db
Posted by IanP at 3/23/2006 2:00:01 PM
Reporting Services "All" Parameter Query design problem in Visual Studio 2003 I am trying to obtain data from an Access 2002 database, either a single specific item or "All" records using a parameter query The selection is working against an Autonumber Int field and does not return data f...more >>

RS2005- Pie Chart Percentages and Filter
Posted by GopherGold at 3/23/2006 11:56:41 AM
I have a pie chart with the following filter expression: =Parameters!Year.Value The point labels for the pie chart are determined from the following expression: =sum(Fields!Expr1.Value)/sum(Fields!Expr1.Value, "SalesDM") My problem is that the above calulation for percentage is incorrect fo...more >>

Problems with Subreports when no data is returned & page breaks ar
Posted by Jeff Rautzahn at 3/23/2006 10:49:31 AM
I've been fighting a problem in SQL Reporting Services 2005 and am about to go nuts! I have a main report that contains multiple subreports. Each subreport is contained within its own List (I've tried Tables too), tied to the DataSet specific to each subreport. Each subreport may or may not...more >>



Custom reporting services extension needs expert clarification
Posted by nickpup at 3/23/2006 9:40:32 AM
Two of the seminal concepts of IT security are authentication and authorization. They underly our ability to control access to our systems. In simple terms, authentication is the who, and authorization is the what. We build security to control who, can do what. I reiterate because it per...more >>

login page problem with reportviewer for winforms
Posted by Bart at 3/23/2006 9:26:43 AM
Hi, My reportserver has forms authentication (for web based users). When I now try to open a report in the winform report viewer I get an error on the viewer about the login page. How can I pass the login credentials via code to the reportserver?: System.Net.WebException: The request fail...more >>

Report Builder - Can't see Report Builder button
Posted by SYoung at 3/23/2006 9:07:39 AM
While logged in locally at the server running Reporting Services I can see the "Report Builder" option on the menu bar but when I access the server from another machine in the network the "Report Builder" option is not available. I gave myself rights to every single option under security but ...more >>

ExecutionLog Installation Problem
Posted by GaryC at 3/23/2006 7:56:32 AM
We are installing SQL2005 for the first time. We have selected all the options on the installation. I'm trying to find the ExecutionLog information and I can not. I'm following Microsoft instructions at: http://msdn2.microsoft.com/en-us/library/ms161561.aspx Instructions say to: C:\Progr...more >>

Manage parameter dropdown list
Posted by lu at 3/23/2006 7:08:33 AM
I have an input parameter which has multi-value property checked. It has dependence on the other input parameter and its value set is getting from database. So, the number of row change when the other parameter changes. The problem is the dropdown list sometime works fine, but the other time...more >>

Convert string value to Date
Posted by Manda Ho at 3/23/2006 12:00:00 AM
If I got a string in format 'yyyyMMddhhmmssf' (e.g. '2005032314221'), how can I convert it to date object in reporting services? Because I would like to show the date in format according to regional setting of client. After getting the date object, I can make use of FormatDateTime. Thanks! ...more >>

Display Reports in ASP.Net 2.0
Posted by DougS at 3/23/2006 12:00:00 AM
What is the best way to display a report in ASP.Net 2.0. Are there web parts like there are in SharePoint? Or is it that ReportViewer control? I am running SQL 2005 Reporting Services. Thanks, DougS ...more >>

Page Margin
Posted by Manda Ho at 3/23/2006 12:00:00 AM
Do anyone know how can I set the page margin of PDF for the export function by clicking the "export" button on the top of report viewer? Thanks! Regards, Manda ...more >>


DevelopmentNow Blog