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

Error when using SQL query to populate list control in custom report

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

4 Posts

4 Users

0 Reactions

123 Views

RSS

gsantin

(@gsantin)

Posts: 1

New Member

Topic starter

I have a custom report in which I need to add a List Control and populate the control with a simple SELECT statement that returns all of the case names.

SELECT DISTINCT Name FROM Cases

I enter this select statement in the property field, Query, of the list control.

When I try to run the report I get the error: Error populating listbox sql. Unknown error 0x800A0CC1.

How to create a query that returns the case list names?

Thanks.

Posted : August 16, 2017 7:54 am

rfisher

(@rfisher)

Posts: 126

Estimable Member

Did you ever figure this out?

Posted : January 10, 2018 6:29 am

dmontgomery

(@dmontgomery)

Posts: 59

Trusted Member

I've encountered this before, you need to return two values with your query.

Text - this will be what is displayed to the user when selecting criteria
ItemData - this is what you would use within your SQL query

So, in your situation a query like below would work.

SELECT DISTINCT Name as 'Text', CasesId as 'ItemData' FROM Cases

If you use this then a simple SQL query to just return the case info for the item they selected would look like this. Assuming the I named the List Control CASE.

Select * From Cases Where CasesId = ?CASE.ITEMDATA?

Posted : January 18, 2018 8:00 am

clawrence

(@clawrence)

Posts: 9

Active Member

You might encounter a problem if users enter special characters like " or % within the Name field.

Posted : January 24, 2018 7:09 am

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