Skip to Content
0
Former Member
Dec 09, 2008 at 12:10 AM

Multivalue DB

54 Views

Hi there.

I have a multivalue DB (http://en.wikipedia.org/wiki/MultiValue) Pick system. I want to make my reports on CR. But I have a big problem, Pick DB uses multivalue fields.

With a MultiValue database schema, also known as an account, a dictionary for a file named Person might have an attribute named Addresses with values that can be represented as the list (joeabc132, jdbbmail123, joebacdethisorthat123).

Well, when I tried to call the data It shows me all the multivalue just like the upper example. I really don't call directly the DB ('cause I don't know how, if somebody knows and can help me It will be highly appreciated) I export the data to an Excel worksheet sending a delimiter character "ý" then I use CR to call the worksheet. Ok the questions are:

Is there a way to tell CR that "ý" is a delimiter and put the following characters in another field?

Is there somebody that uses pick D3 DB and can help me? Any help will be highly appreciated.