Notifications
Clear all
Topic starter
I am searching for a string in the text of a chart using Crystal reports.
Having difficulty accessing this table as it is variable depending on how many characters there are and when pulling in a record to Crystal Report I get an error. Have to use an awkward method of using Oracle SQL Developer, Getting a patient records one at a time, create using the built in SQL script creator a SQL script then running that against a SQL DB to be used in a Crystal report.
Process can take 6 hours or so.
Has anyone else had this kind of issue ?
Has anyone succesfully been able to load DOCDATA.Data into Crystal reports ?
Thanks
Posted : June 12, 2017 4:04 am
I have written reports in the past using docdata and haven't seen errors. Can you give more specifics about what you're trying to do?
Posted : June 12, 2017 4:31 am
I too have a Crystal Report, I used to use probably close to 18 months since I used it, but it pulled up the data from the DOCDATA table to create a PDF version of documents associated with specific Billing Tickets for an Audit. I never had any issues with the report running, the only reason why we stopped using it is that we switched to a different Auditing firm for this Audit and they wanted an electronic copy of the information instead of PDF documents, so I switched to using SQL instead.
Posted : June 13, 2017 3:45 am
I have written Crystal Reports to access and read through related DocData entries. No errors encountered. One important thing to consider is that there is a lot of computer instructions inside the data element in addition to the text. There will be some identification of forms, fonts, etc..., that can make reading and processing difficult.
What command gave you an error?
Posted : June 14, 2017 1:24 am
As long as you are not trying to view the contents of docdata within the crystal report you should not have an issue. If you could provide us with the SQL queries you are running that might be helpful.
Also, you can write the queries in SQL Developer and then either create a view in Oracle and use that as your data source, or use the Crystal reports "command" to run the sql query directly. Again, specifics for your situation would be helpful. Feel free to reach out to me directly if needed.
Posted : June 14, 2017 12:40 pm
