Wednesday, March 28, 2012

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"))

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

any help is appreciated.

Regards,

Karen

Is that you are passign values from an asp page to report, in that case pass two paramaters to reports 1) companymatching 2) safeharbour as boolean values

In the report desgin mode put all the 4 columns and based on the input parameters you can toggle the view to visible or hide.

|||

actually just showing the data from the Database

can u give me a example please.

Regards,

Karen

No comments:

Post a Comment