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 > october 2006 > threads for thursday october 5

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

Excel File Size after upgrade to SRS 2005
Posted by dachrist28 NO[at]SPAM gmail.com at 10/5/2006 7:20:57 PM
We have upgraded our RS 2000 instance to SRS 2005. We have seen that reports exported to excel have gotten huge since the upgrade. For example, we had a report that when run in RS 2000, would export to an excel file that was 900KB. The same report exported to excel in SRS 2005 is now 12 meg! ...more >>

Problem with SSRS2005 Report Builder via the internet
Posted by Mike at 10/5/2006 4:24:52 PM
Hi, I have trawled the internet and the groups looking for the answer to this query but to no avail in that everything I have tried has not worked. I have SQL2005 configured with Reporting Services and Report Builder on my local network and web facing web server using Windows Authenticatio...more >>

How to change the report's "document map" root label?
Posted by Rick at 10/5/2006 3:37:11 PM
Hi, When my report is rendered in the viewer, the document map displays the report file name as the the root node of the document map. I need to hide this name from the users and display a more user-friendly description. How can the document map's root be changed? Thank you in advance,...more >>

how to specify paper/printer at design time for printing labels?
Posted by Rich at 10/5/2006 3:13:02 PM
Hello, Is it possible to specify a printer at design time for printing labels? I am using a tractor feed printer for printing on wide paper. What I am doing is migrating a report that I was running in MS Access to Reporting Services. But in MS Access - in the page setup - I can speci...more >>

Installing SQL RS 2005 only - can it be done?
Posted by John A at 10/5/2006 2:45:01 PM
Is it possible to install only the Reporting Services part of SQL Server without the database engine? We did this with Reporting Services 2000. The reason we need to do this is because are company policy will not let us put a database and a Web Server on the same machine. -- Thank you, ...more >>

Is it a bug?
Posted by Mark Goldin at 10/5/2006 2:05:32 PM
I have a calendar control in my report I am clicking on it in a few times and selecting same date. After two or three times I am getting a run-time error: Object does not support this property or method. ...more >>

SQL Execution Error when trying to run report dataset
Posted by Tony at 10/5/2006 1:57:01 PM
I'm very new to reporting services and running into a problem. I am trying to create a new dataset for a report. I have built the query with the diagram pane interface. When I try to execute it, I'm getting a SQL Execution Error. The query runs within Management Studio but takes close to ...more >>

Why print empty page?
Posted by Hong Wang at 10/5/2006 12:05:02 PM
Hi, I have a very small report, which only contains 3 columns and 4 rows, I have set up the report property to Potrait with a margin of 1 in for each side. when I view the report, everything is fine, but I print the report, it always print out an empty page after the report. No matter how ...more >>



Please help!
Posted by theguyinohio NO[at]SPAM hotail.com at 10/5/2006 10:22:45 AM
Does anyone have code (complete??) to just automatically pass parms to a report and export it (not on a schedule) to a pdf? It cant be hard, but I am not a vb.net programmer. I need it for a quick show and tell to the boss. I have 2005 standard. Mike ...more >>

Default date using datepicker
Posted by Martin GC at 10/5/2006 4:32:01 AM
Hi I'm working on a report in RS2005 and are using a start and enddate parameter. They are of the datatype DateTime. By using this type it is possible to use the datepicker on the report. However, I would like the report to have a default date range say 01/01/2006 as startdate and 12/31/2...more >>

Source Control for reporting services
Posted by p-cresswell NO[at]SPAM iname.com at 10/5/2006 3:20:18 AM
Hi, What source control software can people recommend to me for use with Reporting Services in Visual Studio. Our requirements are a central store for source files, Visual Studio integration and versioning. I've just installed MS Team Foundation server trial and it seems like complete ov...more >>

My report doesn't appear WYSWYG
Posted by sammy at 10/5/2006 2:38:02 AM
I have a data field(text) which doesn't appear as what I see in preview. How can I display the text with paragraphs? I see squares between words from data I retrieved. I guess that is the something indicates new line or new paragraph. In preview, the text is properly displayed in different l...more >>

Charts don't update when using dropdown parameters
Posted by CAP at 10/5/2006 1:14:02 AM
I have recently upgraded from RS2000 to RS2005. The reports seem to have converted without any errors. In the report designer, everything works fine. When deploying to the server the reports don't update properly. Details: The reports have two components (a table and a chart) - both are ...more >>

Dynamic SQL queries
Posted by Pavan Edara at 10/5/2006 12:00:00 AM
Hi, I am trying to use dynamic queries in RDL from the data tab in the report designer. The columns to be selected and the name of the table from which to select are supplied as report parameters. Can someone give me an example of how to do this without using stored procedures or UDFs? Is i...more >>


DevelopmentNow Blog