Is this Query right? (urgent)

Hi

I have a report which has a table and that table has 4 columns

I want to represent the Data like this.

Company Match or Profit Sharing or Safe Harbor Company Match or ProfitSharing or Safeharbor

Years of Service Vesting Years of service Vesting

1 40 1 50

I have 3 text boxes saying Company Match, Safe harbor and Profit Sharing, and the User normally can click 2 checkboxes

Suppose if the user clicks only company Match, i want the company Match to display on the left hand side if the users clicks on 2 things say company match and safe harbor.

I want the Company match to come on the left and safe harbor to be on the right. and my Expression is as follows:

for the Left hand side its :

IIf(Fields!CompanyMatch.Value = true,"Company Match",IIf(Fields!SafeHarbor.Value = true,"Safe Harbor","Profit Sharing"))

and the right hand side its:

IIf(Fields!ProfitSharing.Value = true," Profit Sharing","")

so how can i display the details in the above fashion.

any help is appreciated.

Regards,

Karen

Does your data need to be aggregated or is it a straight read? If so, are you looking to sum the data based on the selected criteria?

|||

My data is straight read from the db, and I am not looking to sum the data.

Hope this helps,

Regards,

Karen

|||

Replace your text values with field values (if this is what you are trying to do)

IIf(Fields!CompanyMatch.Value = true,CompanyMatchField.value,IIf(Fields!SafeHarbor.Value = true,SafeHarborField.value,ProfitSharingField.value))

and the right hand side its:

IIf(Fields!ProfitSharing.Value = true,ProfitSharingField.value,"")

Simone

sql