How to use split function in SQL Statement with MS Access DB

[FaciWare]

Hi,

I'm using Stimulsoft Reports.NET and want create a report where I've to split a string.
The database is a MS Access-DB. So, Access normally don't support the function 'split' in a statement/query, but you can write your own split-function(vba) to use it in a statement/query.
I write my own function and it works how I want it. My problem is now in the report, stimulsoft search for this function and don't find it.

So, how can I use the SQL-Split function (in the statement) in Stimulsoft and/or how can I use the function within the Access database.

thanks in advance!!

[HighAley]

Hello.

As a way you could write your split function in the report on the Code tab in the Designer.

Func.png (25.1 KiB) Viewed 4170 times

Thank you.

[FaciWare]

Hi Aleksey,

thank you for your answer!

That's good, but how can I use this function in my statement/query in stimulsoft (please see the statement of "Query" in the Access-DB)?
I always get the error "undefined function 'Split' in expression"

[HighAley]

Hello.

Your function is running by Access.Application object which is not created when report engine is connecting to the Base using ADO.
So it's impossible to use your function in the query.

Thank you.