Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-10-09 : 23:40:20
|
| i want to delete one of the column but error states that "cannot change part of merge cell" how can i delete it? please help! thanks! |
|
|
shm
Yak Posting Veteran
86 Posts |
Posted - 2008-10-10 : 03:29:56
|
| change that megre cell into the split cells right click on the merge cell there u wil get the split cell select that and then delete the column u want.. |
 |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-10-15 : 01:15:58
|
| Thanks.. i have a follow up message my report dont return a count value in my total column.This is my code , ( SELECT COUNT(DISTINCT Name) FROM #Memo WHERE Tow <>'Non-Tow' AND NameType = 'O' ) TotalByTOWOppi want to display in my report the count that this code produce. i know it was expression but it will not retun anything i used this a a expression =(Fields!TotalByTOWOpp.Value) + 0 but it will not get any value on the report it displays 0 but in SQL Mgt studio the value is 48. how can i do it? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-19 : 05:30:52
|
| are you sure the code used returns you count correctly in sql query analyser? |
|
|
|
|
|
|
Report Designer