Thanks for replying again.

I tried

"=iif(Parameters!PUBLICATION.Value = 304,"red","orange")" with PUBLICATION as integer but still it gives me the same error.

and also "=switch(Parameters!PUBLICATION.Value = 304,"red")"

I got error for both.

Data type is set to integer, but i still get the error. Please help me with this.

THanks

http://imageupload.org/?di=1312995099649

Please see the image above i want the output like this. I hope i made myself clear. I just need an idea to print all the codes even...

Someone help. Thank you.

= Reportitems!txtTotalCS.Value + Reportitems!txtTotalDM.Value

TotalCs.value and TotalDm.value are from different datasets and they won't let me sum up. I need syntax for including datasets also.

I am not actually creating a table. I am creating a report. I need sql to generate Week Ending and week # in a SSRS report not a table. They...

Steve Jones - SSC Editor (2/1/2011)

---

You have distinct, but that applies to the entire row, not just the display name. The account differences are resulting in the extra rows. If...

NOW I UNDERSTAND. Thank you all so much.

mister.magoo (1/7/2011)

---

select DESCRIPTION from CIRC.TAG

Where Rownum <= 10

AND @ReportParameter1='apple'

UNION ALL

select DESCRIPTION from CIRC.TAG

WHERE @ReportParameter1='bat'

UNION ALL

SELECT NULL

WHERE @ReportParameter1 NOT IN...

select (STREET_ADDRESS_LINE || ' '|| CITY_NAME || ' '|| ZIP_PLUS4) ADDRESS, distinct DISPLAY_NAME

from DSIPROC.TRB_VW_SUBS_INFO a

where (STREET_ADDRESS_LINE || '...

I want distinct DISPLAY_NAME(as i mentioned in the question) not ADDRESS. Thank you.:-)

That didn't work.

Sean Lange (1/5/2011)

---

Don't know what you mean by in the image...our network filter says it is a sex site.

for the query I don't quite understand why you need a subquery.

select...

bitbucket-25253 (1/4/2011)

---

Not so simple if you have addresses like

2 South Wood Street

2 S. Wood Street

2. South Wood St.

etc, etc.

Can you supply some sample data, table definition and desired results following...