Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Access DOCDATA table in oracle

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

5 Users

0 Reactions

91 Views

RSS

bgeib

(@bgeib)

Posts: 14

Eminent Member

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

StephenAdamsMD

(@stephenadamsmd)

Posts: 23

Eminent Member

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

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

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

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0