MetaData Database reporting!

[victorthomas]

I'm reporting of a metadata database, this is a very unique database design (see US Patent - 5,267,155 this is the foundation of this database design). This is a user definable database. It's a 13year old design.

The databases initial design function was to serve as a computer based documentation system which processes document templates in conjunction with pre-defined character strings to generate user defined reports or documents.

To make a long story short ALL user data that are NOT pre-defined canned text strings are stored in (get this -->) ONE 7800 character text field.

My challenge is to generate reports from this database, the problem I run into is that ALL data, groups, dates, numbers are all stored in this one text field.

My question is how on earth can you create 2 groups of the same datafield and then at the same time report of data that exists in that same field???

 

[IdoMillet]

It would be easier to suggest a solution approach if you provide example of the data and the output you desire.

Also, what Crystal version? Versions below Crystal 9 have problems in processing memo fields.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[victorthomas]

Thanks for the reply!!

I'm running crystal version 9.0

The data I want to group on is medical data and is stored in a 7800 text field {answers.answerstext}

Data formatting and integrity is performed by an applicaion called DocuMed 2000.

In this case the data woulde look like:
Allan, Boyum, M.D.

 

[IdoMillet]

Still not clear what the output should look like.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[victorthomas]

Thanks for your help!

I solved the problem this morning by generating a view in SQl 2000 that bypassed the problem of having to report multiple times from the same field!

I then used crystal to group of the view!

Whew! huge headache solved did not have to rebuild entire report!

Thanks again Ido really appreciate your effort in trying to help me out!

Victor Thomas