drew.allen (12/9/2011)

---

JonFox (12/8/2011)

---

I think you may be trying to do something like this:

WHERE (H.SALESSTTUS = 1 AND

H.SALESORIGINID IN ('DSM','DSM-Trf') AND

...

where

CASE WHEN @PrmDateDim= 'CreationDate' THEN (Case WHEN L.SALESSTATUS = 1

...

Just overlap is fine. I got nothing so far. I have been thinking but couldn't get any thing. Thanks for the reply.

Thanks..

Daniel Bowlin (6/10/2011)

---

If you can't restrict the original query, then add a filter to the dataset that restricts the result. This is way easier than trying to do something...

Yes this is Oracle.

I just made this table for testing purposes.No indexes and keys required.

Thanks for the replies guyz..

CREATE TABLE DSI_SUBS_STOP_START_DRW

(

ACCOUNT NUMBER(12),

TRANS_DATE ...

This is the answer

Basically, the idea you put in the TypeRankValue column the priority of this address, so that might be something like

With cte As

(Select c.customerId,c.CustomerName,c.CustomerNumber, c.address, c.addressTypeId,

Case...

It's possible, may be not in visual basic but

=IIf(JOIN(Parameters!salesPersonID.Label , ", ") = JOIN(Parameters!All_ADUserList.Label , ", "), "ALL", JOIN(Parameters!salesPersonID.Label , ", "))

I created another dataset All_ADUserList same SQL as salesPersonID...

This is helpful.Thank you.

Thank you so much. This helps. But i see SQL is too big as compared with Oracle. Could you also please help display the dates as Monday,Tuesday,....sunday or atleast Mon,Tue,...Sun.

I opened the dataset and clicked on run and it went through. When i run this in Toad it gives me the result.:-D

select 2/3 tru from dual

Its not T-sql its oracle. Thanks.

In the parameters i did allow multiple values. If unselect that report works fine. Can we write the expression in such a way that it accepts multiple values.