a few Qs:

What is the commented part in your SQL? If uncommented then both the variables have the same date value.

Can you make this a dynamic SQL to try and...

If I understood right, I have done similar thing in the past where I was showing different image in the column depending upon another column value in the same row.

To...

You may create a separate dataset for the productIds and define the parameter as Multi-value and associate this dataset to the parameter.

Agreed with the Syntax error that is shown in the Edit Exression window however have you still tried to run the report and see the output?

If not, can you...

You can add a separate CASE for checking if the parameter is NULL and use the BETWEEN clause only when it is not null.so the WHERE condition wont be...

have you already tried:

WHERE REG_DATE BETWEEN isnull(@REG_START_DATE,REG_DATE) AND isnull(@REG_END_DATE,REG_DATE)

I have copy-pasted the text in your messege and tested with 20000 as well as 615.00 hard-coded values, I do not get error in the out put but I get...

FormatNumber(yourfield, 2, , ,TriState.True)

and You can always prefix $

If I am getting your requirement correctly then You can use CTE for this...

First create a CTE with sum(orders) field say alias as 'yourField' for over $300.

while using that CTE...

Use abs(firstvalue-secondvalue) in your query to get the absolute value instead of with - sign.

As for passing the column names and retriving data accordingly, you can use the dynamic SQL.

Alternavively, design reports with all columns and toggle their visibility according to the parameter values.

In the properties of your textbox, go to the Visibility > Hidden property and add the expression:

=iif(Fields!YourField.Value=0,True,False)

You can change the expression as your requirement, currently it is checking for zero...

Whats the problem in using the two columns in the where clause?

can u paste your SQL Query or Stored proc text you are using, to get some more idea?

As an alternative, one can add an entry textbox that has default value ‘%’.The user can enter their value in the text box and accordingly, the dropdown immediately gets filtered...