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 |
|
dmills99
Starting Member
7 Posts |
 Posted - 2014-10-03 : 13:13:26
|
I have this code:='Total' + count(fields!id.value)in reporter 3.0 it gives error... i probably should know this by now but how do i concatenate text and functions on the same line like this? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-03 : 13:20:07
|
| try wrapping the number in Cstr() like CStr(count()). you can get fancier with the format function |
 |
|
|
dmills99
Starting Member
7 Posts |
Posted - 2014-10-03 : 13:33:52
|
I tried several different methods using the Cstr() but it still errors out...tried=Cstr('Total') + count(fields!id.value)=Cstr('Total') + Cstr(count(fields!id.value))=Cstr('Total' + count(fields!id.value))=Cstr('Total' & count(fields!id.value))-----------------------------------------------------------------------quote:
Originally posted by gbritton
try wrapping the number in Cstr() like CStr(count()). you can get fancier with the format function
|
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-10-03 : 13:52:11
|
| try Cstr(count(fields!id.value)) on its own. also, I think strings should use double-quotes, like "total". See http://msdn.microsoft.com/en-ca/library/ms157328.aspx |
|
|
|
dmills99
Starting Member
7 Posts |
Posted - 2014-10-03 : 14:36:38
|
Worked Awesome... tanks... --------------------------------------------------------quote:
Originally posted by gbritton
try Cstr(count(fields!id.value)) on its own. also, I think strings should use double-quotes, like "total". See http://msdn.microsoft.com/en-ca/library/ms157328.aspx
|
|
|
|
|
|
|
simple reporting question