Viewing 15 posts - 361 through 375 (of 3,544 total)
To get this to work edit your procedure and change
SET @SQLString = @SQLString + '"SELECT DateTime = convert(nvarchar, DateTime, 21), ['+@Para+'.ENERGY] , ['+@Para+'.FLOW], ['+@Para+'.POWER] '
to
SET @SQLString =...
Far away is close at hand in the images of elsewhere.
Anon.
June 9, 2017 at 2:34 am
I get the same on 2008 and 2012. 3 seeks with RID lookups...
Far away is close at hand in the images of elsewhere.
Anon.
June 8, 2017 at 9:38 am
Use
=RunningValue(Fields!calculatedfield,Sum,Nothing)
Far away is close at hand in the images of elsewhere.
Anon.
June 8, 2017 at 7:12 am
Fields shows what columns are returned from the query
Parameters is used to map report parameters to stored procedure parameters
Far away is close at hand in the images of elsewhere.
Anon.
June 8, 2017 at 6:55 am
Far away is close at hand in the images of elsewhere.
Anon.
June 8, 2017 at 3:15 am
Here are the results on my 2008 laptop. Results are similar on my 2012...
Far away is close at hand in the images of elsewhere.
Anon.
June 8, 2017 at 1:57 am
CONVERT(int Far away is close at hand in the images of elsewhere.
Anon.
June 7, 2017 at 9:53 am
Far away is close at hand in the images of elsewhere.
Anon.
May 30, 2017 at 6:21 am
Set the sort expression on the row group to
=Sum(IIf(Year=2017,1,0))
Far away is close at hand in the images of elsewhere.
Anon.
May 26, 2017 at 6:24 am
I inserted a matrix into the report with no problem. The rows are the diagnoses...
Far away is close at hand in the images of elsewhere.
Anon.
May 26, 2017 at 6:18 am
I did something similar before
Extract RowId where InSequence=0 (ie 210)
Include min and max IDs (ie 0 and 999)
Sequence with rownumber
SeqNo ID
1 0
2 210
3...
Far away is close at hand in the images of elsewhere.
Anon.
May 17, 2017 at 6:04 am
Far away is close at hand in the images of elsewhere.
Anon.
May 15, 2017 at 8:24 am
Far away is close at hand in the images of elsewhere.
Anon.
May 11, 2017 at 2:25 am
Far away is close at hand in the images of elsewhere.
Anon.
May 4, 2017 at 7:06 am
Far away is close at hand in the images of elsewhere.
Anon.
May 4, 2017 at 2:12 am
Viewing 15 posts - 361 through 375 (of 3,544 total)