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 > may 2005 > threads for thursday may 26

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

Email Subscripions Question
Posted by Brian Ward at 5/26/2005 6:19:37 PM
I would like to do a email subscription but the Email option doesn;'t show up in the delivery methods. What needs to be enabled to allow this option? Cheers Brian...more >>

Make row in table shrink or collaps
Posted by moondaddy at 5/26/2005 5:16:38 PM
How can I make a row in a table shrink or collapse when there's no data for that row? I have a table with several detail rows in it. the bottom row has 2 cells. the first one if for a label and the second one is for the data. cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees",...more >>

Iif Functions
Posted by Nat Johnson at 5/26/2005 5:04:02 PM
In a table im populating I have to leave a data cell blank depending on the value retrieved. eg. if the breed type is deer leave the cell blank. Do i use an Iif function for this or not. And if so how do I write it. Total sqlnewbie here. I have this so far.....Iif(Fields!Breed.Value ...more >>

parameter limiting
Posted by scraejtp at 5/26/2005 3:05:22 PM
I have a few required parameters listed at the top of a report. I want to make it where when one parameter is chosen in the drop down menu, the other parameter(s) limit their choices accordingly. I can't seem to find a way to do this though. Any help would be great. Thanks. ...more >>

Migrating reports from one server to another
Posted by vRam at 5/26/2005 2:48:07 PM
What is the best way to move a folder in reporting services from one server to another. The folder contains reports, data sources, images, and subscriptions. I dont want to move the entire databse....more >>

Show data for CURRENT YEAR only
Posted by pmud at 5/26/2005 2:34:03 PM
Hi , I have a very simple question. I want to show data in my report only for the current year. How to do that? n my query , I did , WHERE Year(OrderDate)=Year(Now) . But it gave me a syntax error. What is the correct syntax for this? Thanks -- pmud...more >>

Subreport Headers and Footers not displaying
Posted by John Supplee at 5/26/2005 12:06:02 PM
Is there anyway to get the headers and footers to diplay? Also is there anyway to have the page count reset for every interation of a subreport being called. Thanks, John...more >>

Expression for Running Total
Posted by bak at 5/26/2005 11:41:32 AM
I want to write an expression where the running total should be calculated if the previous value for a column(invoice code) is not equal to the current value for the invoice code. The expression should be something like this: iif( current invoice code is not equal to the previous invoice co...more >>



ReportServer Service stopping
Posted by Kmistic at 5/26/2005 7:05:01 AM
I have the ReportServer service set to automatic, but on a daily basis it seems to stop. This causes my report subscriptions to not fire. My log file ends with the following: aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries,...more >>

[BC30469] Reference to a non-shared member requires an object reference.
Posted by Siew Fai at 5/26/2005 7:02:52 AM
Hi, I have a custom assembly which I would like to store state between calls. In RDL, the following was declared: <Classes> <Class> <ClassName>MyNamespace.MyClass</ClassName> <InstanceName>MyInstance</InstanceName> </Class> </Classes> <CodeModules> <CodeModul...more >>

hidden rows
Posted by pcalv at 5/26/2005 2:05:03 AM
Hi Hope someone can help. I'm trying to hide a row based on 2 criteria. If i use one this =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value, True, False) it works but as soon as i add another criteria e.g. =iif(Fields!RespTimeEq.Value > Fields!RespTime.Value and Fields!VisitType....more >>

ADO error (syntax error or access violation)
Posted by Marco van de Kraats at 5/26/2005 12:00:00 AM
I made a union all between two query's in I've built all of the queries in query analyzer without any problem but in reportingssvcs I get a ADO error (syntax error or access violation) Does any one know why? ...more >>

Conditional Statement in a Group
Posted by Warren Patterson at 5/26/2005 12:00:00 AM
Hi, This probably has a simple answer. This is what I am trying to do on a report , I am trying to get a count of a condition where IsUnderInvestigation = "yes" where the report is grouped by "TEAM" Dataset: ID Name Team IsUnderInvestigation 1 John X ...more >>

Sort order on Columns of a table
Posted by James Woo via SQLMonster.com at 5/26/2005 12:00:00 AM
Hi - I have a tabular - drill down report : Person Subject Period $ - Person1 Skill1 2005-04 2500 skill2 2005-05 300 skill3 2005-01 400 + Person2 + Person3 + Person4 ...more >>

Unable to communicate with report server - PAM
Posted by Pamela Mitter via SQLMonster.com at 5/26/2005 12:00:00 AM
I have installed Reporting Services and I get this message: Unable to communicate with report server. Please verify that the report server is operational. Any ideas how to fix this? I need to get this fix ASAP. Thanks. -- Message posted via http://www.sqlmonster.com...more >>

How to have Child list Data Set refer to Parent List Field or Textbox name?
Posted by Wayne Snyder at 5/26/2005 12:00:00 AM
I have a parent /child relationship... and 2 data sets - one for each... I have a Parent list, and a child list embedded within the parent list... I need to have the data set for the child return all of the rows associated with the particular parent item on each page, but get the error saying t...more >>

Hide empty detail sections
Posted by Franc v/d Westelaken at 5/26/2005 12:00:00 AM
Hi, I'm building a report that displays a tree structure with the content of some nodes of the tree (as detail). Some nodes don't contain any info, thus the detail section is empty. How can I hide the empty detail section in the report ? Now it displays always an empty row, but I want to shri...more >>


DevelopmentNow Blog