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

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

grouping problems
Posted by newbie00100 at 7/17/2006 10:34:01 PM
how to i make a report like this? group 1 start group 2 start group 2 end group 3 start group 3 end group 1 end i keep trying, but can only make a report like this: group 1 start group 2 start group 3 start group 3 end group 2 end group 1 end i am using sql server 2000 reporting ...more >>


Truncating Spaces
Posted by vinodsh_82 NO[at]SPAM hotmail.com at 7/17/2006 9:13:26 PM
Hi i had written custom code to separate date and time parts with 5 spaces. But when i preview the report, it is truncating the spaces that are more than one. It is allowing only one space between date and time (4/19/06 12:05 PM). When we export the report as pdf, it is showing correctly (4...more >>

show 0 for blank data
Posted by bevarg at 7/17/2006 3:13:32 PM
Hi, I've created a report that contains all fields from table1, table2, and table 3 in a table format. what's happening with my report is: when a customer has info about him/her in table1 but not in table 2 or table 3 the report won't the customer record at all. but when a customer has ...more >>

Problem " IN(@Parameter) "
Posted by Steve Dearman at 7/17/2006 2:30:42 PM
Hi I have a query and am filtering one of the fields. This fields is a uniqueIdentifier which i am casting to a nVarChar(36) the filter of this field is then IN(@Parameter) this parameter then has this as the default value ="N'058D0A1B-7DB2-DA11-84EC-00065B3B13A4',N'222B3BE4-7CB2-DA11-84EC-000...more >>

problem opening data connection
Posted by Dan D. at 7/17/2006 12:36:02 PM
Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that someone else created. I'm not very familiar with either RS or VS. When I go into VS and load the solution (someone told me how to find the correct one) and then in the solution explorer, I double click on the report ...more >>

SQL 2005 with Windopws XP
Posted by Feches at 7/17/2006 10:42:01 AM
Hi, I have a company with 3 computers and the 3 computers have Windows XP and I can’t buy a new computer. Can I install SQL 2005 with Analysis Services and Reporting Services? I want to create cubes and reports to analyze the transactional information. Does it works? THX. ...more >>

How do I reference a field within a subreport
Posted by shane.eckel NO[at]SPAM seattlesoftware.com at 7/17/2006 8:49:56 AM
Does anyone know how to reference a subreport to find out if a field within it has data, such as a ParentID field? Thanks! Shane ...more >>

Get rid of the weekends
Posted by Benw at 7/17/2006 8:33:02 AM
SELECT MSP_PROJECTS.PROJ_ID, MSP_PROJECTS.PROJ_NAME, MSP_TASKS.TASK_ID, MSP_TASKS.TASK_NAME, MSP_TASKS.TASK_FINISH_DATE, MSP_TASKS.TASK_START_DATE FROM MSP_PROJECTS LEFT OUTER JOIN MSP_TASKS ON MSP_PROJECTS.PROJ_ID = MSP_TASKS.PROJ_ID ...more >>



Unable to Start Report Server Windows Service
Posted by Amedeo Feroce at 7/17/2006 8:07:43 AM
For some reason I am unable to start RS Windows service. Here are the details of Exception that I get - **************************** System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceControoler.WaitForStatus...more >>

Security & Enabling My Reports that support user-owned folders
Posted by clutch at 7/17/2006 6:40:02 AM
Hi, We are looking to enable the My Reports that support user-owned folders functionality but we don't want everyone in the company to have this functionality. For example, we would want management and above to have this functionality but no one below. Is this possible? Thanks a bunch!...more >>

Failture to start Report Builder from Report manager
Posted by Marc at 7/17/2006 5:56:02 AM
Dear all I want to start report builder from report manager. I configured IIS with integrated security. Everything seems well configured - users with access rights can access Reporing Services, users without accessrights cannot. But with reportbuilder I have a Authentication problem. A us...more >>

How to add Combo box or dropdown List for picking month,Day and Year,Seperately as a Report Parameter in SSRS2000?
Posted by ajmera.puneet NO[at]SPAM gmail.com at 7/17/2006 4:47:45 AM
If Anyone konws that : How to add Combo box or dorpdown list for date picking option as three different boxes are to be used for Month, Day & Year OR Any other way of picking date in Sql Server 2000 Reporting Services as a Report Parameter? ...more >>


DevelopmentNow Blog