mebbe need to put the text in quotes: FOR [Status] IN ('A','I','D')

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...

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...

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

,...

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...

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...

lrosini (5/21/2009)

---

I hope I'm understanding your problem correctly. Do you have all subreports within the same tablix? If so that is the problem. In SSRS 2008 each subreport needs to...

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...

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...

2008 has the NTile function, sounds like it might be a solution.

http://msdn.microsoft.com/en-us/library/ms175126.aspx

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...

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. ...

Maybe set a default value on the 2nd date parameter so that it gets an appropriate date. =DateAdd("d",10,Parameters!StartDate.Value)

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...

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...