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 > february 2006 > threads for monday february 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

Excel Sheet name and Sorting Problem...
Posted by aravindsabapathy NO[at]SPAM gmail.com at 2/6/2006 8:14:14 PM
Hai, Is it possible to give another name that "Sheet1" when I export my report to Excel ? Also When i make report header it is not allowing me to sort? Any solutions/Samples ? Thanks in advance Aravind.S ...more >>


Problem deploying data processing extension
Posted by Raoul James at 2/6/2006 3:46:08 PM
I have developed a data processing extension that extends an ADO.NET provider so that it works with reporting services. That is, it works in the designer, but when I try to deploy the application, I run into a little problem. It loads my wrapper (the actual extension) just fine, but then t...more >>

VS 2005 Ate My Report!
Posted by CGW at 2/6/2006 3:45:27 PM
Excited over VS 2005, I used it to create a new report project, shared data source, and report. However, when I tried to deploy to a machine with SQL 2000 and Report server, the report emptied... as in all the structure. Now I have nothing. Am I right in assuming that only report projects c...more >>

Query Help
Posted by Shan at 2/6/2006 2:08:32 PM
I have query with following column names: cust_no, Firm_no, Name, homeaddress, homecity, homestate, homezip, officeaddress, officecity, officestate, officezip I want to be able to pull it this way that whenever there is a certain unique Firm_no it should populate the homeaddress, homecity, h...more >>

using calulated number in report
Posted by Bill at 2/6/2006 1:48:52 PM
I need to count the number of row returned on the query @@rowcount would seem to work But I need to be able to use this number in the report How do I turn this is to a useable Field??? sorry Im no delevoper, Im sure it's easy but Ive hacked a round a bit and still NG thanks bill...more >>

having trouble getting reporting services installed properly
Posted by Chris at 2/6/2006 1:31:16 PM
Hi, I am running Windows 2000 and VS 2003. I installed Reporting Services with service pack 2. When I type: in http://reportserver/reports I get an access denied 403 error. When I go into IIS Manager and look for the Report folder properties I can't find the Reports virtual directory. ...more >>

Reporting Services 200 & Subscriptions
Posted by Brian Smith at 2/6/2006 1:31:08 PM
I currently have about 500 reports with subscriptions going out to around 1500 email address's. Is there any way of managing these subscriptions so that I don't have to go to every individual report to add or remove an email address?...more >>

Customizing NoRows Rpt Svs 2003
Posted by robert.hinojosa NO[at]SPAM gmail.com at 2/6/2006 11:09:10 AM
How can I customize the NoRows String message in a subreport? The text it displays is black and in Times New Roman. I need to change the font and color. Thanks in advance, Robert ...more >>



Performance problem - Conditional Formatting on Table
Posted by Woodgnome at 2/6/2006 3:41:27 AM
I am having a preformance problem which I seam to have narrowed down to the conditional formatting I have placed on a table in my report : I have some custom code which declares variables for all the formatting fields. The values are taken from a database and are populated by a call to a f...more >>

How building a report referenced by a map?
Posted by Pasquale at 2/6/2006 1:00:27 AM
I need to create a report with a map that allows me to selece a particular set of data when I click on a map element. For example, I have an employee table containing the data related the country. I want to build a map respect this data. This it is easy. Then when I click on a particular value ...more >>

reporting service performance issue
Posted by David Zhu at 2/6/2006 12:32:26 AM
Hi, I construct a sql statement as a dataset. But when I click Run or Refresh, the VS.NET runs so slow and no response sometimes. Do you know why, and how to deal with this issue? below is the sql statement I used for: DECLARE @sql NVARCHAR(4000) select @resp=ltrim(rtrim(@resp)...more >>

Some questions
Posted by Adry at 2/6/2006 12:00:00 AM
Hi, my customer has SQL Server 2000 Standard Edition, and now he asks me to develop some report based on it. So, these are my questions: 1. to install SQL Server 2000 Reporting Service, he need an additional license ? 2. can I use (install) SQL Server 2005 Reporting Services instead of S...more >>


DevelopmentNow Blog