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 monday march 6

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

Changes on the design of the templates not showing
Posted by Lucrecia at 3/6/2006 9:49:27 PM
I made some changes on the design of the report's templates. I do that locally, and then deploy and upload to the server. I haven't been able to see those changes on the working website. I have the following: Windows 2003 SP1 IIS 6.0 ..Net Framework 1.1 SP2 SQL 2000 Enterprise Edition SQL...more >>


ReportBuilder.exe parameters
Posted by Chris Taylor at 3/6/2006 9:36:24 PM
Hi, Is there any way to specify to ReportBuilder.exe which server you would like it to go to? Or at least what web service you want it to talk to via the ..application file or the .manifest file? Thanks! Chris ...more >>

Label Positioning
Posted by anthonysjo at 3/6/2006 7:50:26 PM
Hello All, I have a bar chart with vertical bars. Under each bar is a label that describes that particular bar. At some point I found a property where I could change the positoning of the test to display either vertically or horizontally but now I can't find that property again. Any ...more >>

Parent child dimension from OLAP (AS) in Maxtrix control for SRS 2
Posted by Henrik Juel at 3/6/2006 5:38:36 PM
Having a Parent-Child dimension in a AS cube. For a matrixreport I am using the buildin property UniqueName and ParentUniqueName for grouping and drill functionality. The report is shown fine in the VS Preview and everythings is working. When the report is rendered in the reportmanager it ...more >>

Parameter selection that depends upon other parameter values
Posted by Ed Allison at 3/6/2006 4:37:22 PM
Hi everyone, I am writing a report to display information for sales branches. The report has two parameters, BranchID and StaffID. Both queries have available values supplied by stored procedures. BranchID is easy enough. It's query is a stored procedure with the SQL: SELECT BranchID...more >>

Report requesting 8.5 x 14 paper
Posted by WebPhenom at 3/6/2006 2:52:44 PM
Hello, I have created a report in Reporting Services 2.0 using Visual Studio 2005 Report Designer. The report is defined as 8.5w x 11h. For some reason when I preview the report using the Report Viewer and choose to print the report, the printer is requesting 8.5w x 14h paper. I don't se...more >>

Error 1603 trying to install SRS on client machines
Posted by dbcricket NO[at]SPAM hotmail.com at 3/6/2006 2:44:37 PM
Hello all. I'm hoping I can get some insight as to what's going wrong here. We have CRM 3.0 and want to give developers SRS Report Designer on their workstations to design some reports. I'm trying to install SRS 2000 on the first developer's machine, and after running setup it gives me three war...more >>

Cannot create a connection to data source 'myservername'.
Posted by dba123 at 3/6/2006 2:13:19 PM
No matter how many times I redeploy my report and data sources from my project to Report Manager, I keep getting this error when trying to run the report from Reprt manager. It runs fine in VS 2005 though. I don't know what else to do. I see no way to delete the report from Report Manager in ...more >>



Fields disappear at List
Posted by Shaw at 3/6/2006 1:13:27 PM
I just try a List data region with SQL query. It repeats few times and has multiple pages. The first page is fine. But from second page, the first List area (at top of page) misses all fields (only shows labels), and the rest of page is just fine. The second page looks like that: Label1: L...more >>

Parameter prompt value
Posted by bosstan1 NO[at]SPAM gmail.com at 3/6/2006 12:14:44 PM
is there a way to get parameter prompt value inside the report? If i have parameter 1 with a prompt value "Customer ID", how can i get "Customer ID" string value? ...more >>

Can we implement Pivot Tables using MSRS?
Posted by Yogi at 3/6/2006 10:38:35 AM
Can we implement Pivot Tables using Reporting Services 2005? I need to allow user to select the pivot column at runtime. I mean dynamically changing the criteria for pivot tables after report is rendered. Thanks, Yogesh ...more >>

Easy way to copy over calculated fields to another dataset
Posted by dba123 at 3/6/2006 7:47:22 AM
I have a dataset in which I created about 10 calculated fields. I often use this dataset for other reports. How can I copy over those fields to the dataset I create in my other reports quickly? ...more >>

string to date
Posted by rosco at 3/6/2006 3:29:28 AM
Hi All, I have an employee table with a safe pass column. This is 18 characters long e.g. SP1/84/056351/0406 The last four numbers represent the expiry date of the safe pass (in this case April 2006). Has anyone any ideas on how to convert this? ...more >>

grouping data to a field
Posted by Jimbo at 3/6/2006 2:59:45 AM
Hey Im doing a report wich is causing me some trouble: Im doing a dataset selecting all values regarding the company, and then im mapping the fields to textboxes in my VS designer. This should result in a list with all my customers and their data. Now below each customer i would like to p...more >>

Label field on table header
Posted by Pasquale at 3/6/2006 2:59:35 AM
I need to put on table header a label formed by a string concatenated with a field value. I try to do it unsuccessfully! Is there a method to solve this issue? Many thanks for your suggests....more >>

VS 2005 & RS 2000
Posted by Steven Cark at 3/6/2006 2:21:04 AM
Hi All Hope someone can help me out here. My company has forced us to start developing in Visual Studio 2005 however they have not allowed us to update to SQL 2005 yet due to "evaluation issues". We currently have Reporting Services for SQL 2000 installed on the production environment, ...more >>

Matrix Sub Total
Posted by Ganesh Ramamurthy at 3/6/2006 12:00:00 AM
Hi Experts... I am using a matrix report. I am showing the subtotals of one of the columns and it is comming correctly on the Right hand side of the column. My problem is that I want the sub total to appear on the Left hand side of the selected column insted of the Right side. Is there a...more >>

Report deployment with RS2k, SP1
Posted by Laurent at 3/6/2006 12:00:00 AM
Hello, I have a problem with report's deployment (SQL 2k, RS SP1). All my reports have only hidden parameters (parameters with a prompt blank). When I deploy from VS. NET 2003 to an empty folder on my RS server, the prompts reappear and the checkbox "prompt user" is unchecked. That means ...more >>


DevelopmentNow Blog