i creating a list dataset within ssrs 2005. where is shows the a few columns from my table dataset... but i would like to show a count of records at the top of the list... is this possible? ="calls made within this period was"+????? thanks

Hallo SQL_1980, it is quite easy: 1. Create a table object 2. Than add a parent group with Header to the details 3. In the Header use a cell with =COUNT([YourFieldName]) HTH ;-) Uwe Ricken MCIT Database Administrator 2005 MCIT Database Administrator 2008 MCTS SQL Server 2005 MCTS SQL Server 2008, Implementation and Maintenance db Berater GmbH http://www-db-berater.de

cant get it working right... keep on getting repeated rows...

got it working... but i get an error message because i believe ive added an expression ="calls made within this period was"+COUNT([YourFieldName])

got it working... but i get an error message because i believe ive added an expression ="calls made within this period was"+COUNT([YourFieldName]) You have to take care of the notation for RS: ="calls made within the period was " + COUNT(MyField.Value) OR ="calls made within the period was " + COUNTROWS() You get more details concerning both solutions at: http://technet.microsoft.com/en-us/library/ms156330.aspxUwe Ricken MCIT Database Administrator 2005 MCIT Database Administrator 2008 MCTS SQL Server 2005 MCTS SQL Server 2008, Implementation and Maintenance db Berater GmbH http://www-db-berater.de

Hi, Use '&' instead of +, it should work.MSBI Developer