Last post Jul 20, 2020 12:37 PM by PatriceSc
Feb 10, 2020 06:47 PM|Devylknyght|LINK
Hello, I built a report that uses a query with numerous RegExp function calls to dig the first 5 occurrences of a particular substring. This is causing way too much strain on our Oracle servers and I am working on figuring out how to just search the whole
CLOB objects for the desired strings on the SSRS end, but am not having much luck. The best I have been able to do is use Mid() and InStr() to grab the first occurrence and only a fixed number of characters after.
What I would like it to do is:
1. Find the first 5 occurrences and concat them on new lines all within my text box.
2. Find the substrings using a search string start point and endpoint.
3. Have wildcards or choices in the search strings to identify certain variations and discard others.
4. Replace() some of the returned strings with "" (basically just to cut off unwanted parts).
In anything like this even possible on the SSRS side?
Here is the farthest I have gotten so far:
=Mid(Fields!Policy_XML.Value, InStr(Fields!Policy_XML.Value, "text="), 500)
Jul 20, 2020 12:37 PM|PatriceSc|LINK
This is an XML column? Rather than trying to process the CLOB column on the SSRS side I would rather try to use https://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb04cre.htm#ADXDB0400 to
expose ready to use data to SSRS (I don't know those functions, I used Oracle a long time ago).
Edit: this to avoid to get the full CLOB data on the SSRS side which is perhaps rather the problem?