Yes I did open it in the SSMS and selected edit top #### rows. Thanks for your help.

Thanks for you help. Yes I notice that when I select return records in the objst explorer the grid to the right has true or false in the bit field....

Thanks Sir.

Thanks for your Help. But what if I have a value in the parent Table Primary Key column. And I am trying to enter that Same value in the child...

Thanks for your Help. I was wondering since I already have my parent and child table. Could I just use this part of the SQL you posted? Also why is...

What do you mean by Upper?

I was just going to tell you I figure it out. You have Been very very helpful. Thank you so much. What do I do to vote for you or...

select 'ALL'

union all

SELECT distinct Department FROM dbo.tblReportData

Thanks it worked great however I lost my column name. Can you tell me how to rename it from No column name to depatment.

So it sounds like i would need to create a new table just to hold the value ALL?

Select * from States. Then I want to add the value ALL to the resultset.

Thanks a Bunch. I appreciate your help.

Yes like i said I have a stored procedure that I execute to return a resultset. This resultset is simply to provide a list of states to the user.However there...

SSRS Project . So you mean I cant use a calendar in my report?

The All Windows Forms Controls, The Common Controls. Does that give you enough information?