Viewing 15 posts - 136 through 150 (of 173 total)
PIVOT(COUNT(AppDetails.AppID) FOR [Status] IN (A, I, D)) pvt
mebbe need to put the text in quotes: FOR [Status] IN ('A','I','D')
December 8, 2011 at 6:34 pm
pdf format is really picky about the margins. for letter size, you must set up the paper size letter - 8.5 x 11, set the report margins to .25...
December 8, 2011 at 3:41 pm
As with most everyone else, just wanted to say thanks for all the wonderfulness. Also, you are my hero and when [if] I grow up I want to be...
December 8, 2011 at 3:31 pm
If you are looking just to find the max effective date for each person and type of job, just use the max and group by the rest:
SELECT DISTINCT
E.Name
,...
December 7, 2011 at 6:39 pm
I am trying to calculate the number of business days between 2 dates. I don't want to include Saturday or Sunday in the calculation, or any dates that exist...
December 7, 2011 at 6:03 pm
FYI - SSRS questions should probably be posted in the Reporting Services forums.
If you mean that you want to split the report results onto separate worksheets within one...
December 7, 2011 at 4:33 pm
lrosini (5/21/2009)
November 30, 2011 at 6:25 pm
Create one dataset for your report details, join the Population table. (can't see what exactly to join to on the screen shot). This dataset should be filtered by...
November 30, 2011 at 6:20 pm
We can't see a whole lot of detail on your screenshot, but it looks like you have the year in one big merged cell, and the text is set to...
November 30, 2011 at 5:53 pm
2008 has the NTile function, sounds like it might be a solution.
http://msdn.microsoft.com/en-us/library/ms175126.aspx
November 30, 2011 at 5:36 pm
Without more info this is just a stab in the dark, but as you are trying to find matches for the rows in the brinks table, perhaps you should try...
November 30, 2011 at 4:54 pm
After following the steps for adding the row group with header, delete the far left row group column that ssrs adds for you. Just delete column, not group. ...
November 29, 2011 at 6:53 pm
Maybe set a default value on the 2nd date parameter so that it gets an appropriate date. =DateAdd("d",10,Parameters!StartDate.Value)
November 25, 2011 at 5:27 pm
You'll need to update the query/data set to handle null values for each of the three parameters
Where
SomeField = isNull(@SomeField, SomeField)
and NextField = isNull(@NextField, NextField)
and...
November 25, 2011 at 5:19 pm
Why don't you use fields from both databases by using the fully qualified names in your query/dataset.
select
c.Prog
,c.Selection
,c.SelID
,r.Program
,r.Sel1
,r.WashType
from
configDB.dbo.tblSelection1 c
inner join...
November 25, 2011 at 5:08 pm
Viewing 15 posts - 136 through 150 (of 173 total)