Notifications
Clear all
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
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
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
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
