ok will do thanks, for the info.

Yes I put right at the end of the topic that its against oracle, sorry I should have made that clear from the beginning.

The report is created in SSRS but...

Thanks.

I have tried as you have suggested but I still get the error

(ORA-00904: "TESTDB"."DBO"."RFUNCTION": invalid identifier)

I entered it without the quotes.

Thank you for your help, I found the issue.

I changed my conenction type to Oracle rather than ODBC and now your first suggestions works.

Thanks

Im writing it against Oracle 11g

Is the "dbo.DelimitedSplit8K" part of the query you have written what I should type or should i replacing it with something else? At the...

Thanks for the reply. Unfortunately still no data. Work if I select one value but more than one gives no data.

One with a list of users.

I have found the issue, it seems to be because of having several IN Clause's.

There are 5 parameter that use IN clauses. When...

Issue was with the source control that is intergrated with BIDS.

Issue resolved

Perfect. THank you 🙂

I found the resolution you have to add CAST(@HOURS as INT)

I found the answer, for anyone that has had the same issue.

I used an expression for the field

=IIF((Previous(Fields!Division.Value)=Fields!Division.Value) ,"", Fields!Division.Value)

Ah yes thank you, I was using INT.

rkaria (8/2/2011)

---

Hi ya

Sorry im not sure where you mean. Which properties box? Ive looked on the textbox properties with the field that is being supressed, but there is "Report" selection...

Hi ya

Sorry im not sure where you mean. Which properties box? Ive looked on the textbox properties with the field that is being supressed, but there is "Report" selection and...

Thanks, I have tried it in the data set as well as on the report to no avail.