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

Crystal Designer - adding a field

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

4 Posts

2 Users

0 Reactions

65 Views

RSS

dgoldsmith

(@dgoldsmith)

Posts: 38

Trusted Member

Topic starter

Hoping someone can point me in the right direction. I want to add a field that isn't already specified in one of the pre-existing reports within the 'Reports' section of CPS. I have been able to export and import the rpt to make other adjustments without issue within CR designer. I've tried to add the field within the actual sql of the report (add to select statement), but it does not make its way to the 'data' table which shows up as the report source. The field is within a table that's already joined, but not selected. Any assistance is appreciated!
Thanks,
Diane

Posted : February 5, 2016 11:01 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

When you say that you added it to the Select statement, do you mean that you clicked on your "Red box" report in the Reports Module (Red Box indicates that you can modify it), then switched to "Design Mode" in the second row of icons underneath the menus at the top, and then modified the SQL Select statement in the "Report Query" section? Then that should work if this is where you modified it, but be careful to make sure that you added it to the correct Select statement some reports have multiple ones as they are building temporary tables to use with the report.

After you have added it to the proper Select statement in the "Report Query" section, you will need to update your report. You will need to switch back to "Report Mode", which is the icon next to "Design Mode" and fill out any of the required parameters and then right click on your report and select "Design Layout". You can then modify the report layout and add the field you need, but make sure when you are finished that you do not just simply close the window, but actually click on the "OK" button in the bottom right corner of the window or your changes will not be saved to the report layout.

Posted : February 5, 2016 11:22 am

dgoldsmith

(@dgoldsmith)

Posts: 38

Trusted Member

Topic starter

Thanks so much! That worked perfectly.

One more question. I made a copy of a report, but now it is not showing up. I tried to copy the report again (using the same 'copy to' name) and got a message that the report already exists, but is hidden. I haven't found a way to display hidden reports. Don't know if you've ever come across this, but I thought it quite odd!
Thanks again!

Posted : February 8, 2016 6:51 am

gpincomb

(@gpincomb)

Posts: 278

Reputable Member

I have never seen a report that was copied to a folder not display, sure it drops down to the bottom of the list of the reports in the folder, until after you completely leave the Reports Module and come back, but I have never seen it become hidden.

Have you tried logging all the way out of Centricity including your Citrix connection, if you use one, and back in, just to see if it shows up in the list? I know it seems like an obvious question, but I had to ask. If you have and it still isn't showing up, but states that it already exists when you try to copy it into that folder, then I think you should contact GE support, cause it sounds like something is not working correctly. You may have to touch it in the database table to fix this issue and GE Support should be able to provide you with a script, unless someone on here already has one you can use.

Posted : February 8, 2016 7:33 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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