CDR Tickets

Issue Number 4987
Summary [DIS] Drug Type report - highlight drugs with multiple types
Created 2021-06-09 16:34:31
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2022-01-04 11:05:02
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.291953
Description

Idea from Christina:

 

For the Drug Type report, I wonder if it is possible at some point to either color code or bold the drugs with more than one type. It’s hard to get a sense of which drugs those are in a long list.

Comment entered 2021-06-09 17:00:02 by Kline, Bob (NIH/NCI) [C]

As with all of the reports, the modifications to support rich text — particularly in the case of reports which are available as HTML reports and Excel workbooks — require quite a bit of custom coding, often dwarfing the LOE for the original report. Adding  as a watcher so she can weigh in on the request. In this particular case I wonder if the business need might be met if we used cell spanning, as illustrated in the attached example.

Comment entered 2021-06-09 17:07:45 by Kline, Bob (NIH/NCI) [C]

I think I'm going to take back most of what I just wrote. This isn't a case of rich text, because what you're asking for is bolding of complete cells. Rich text is needed when portions of a cell need different font settings than the rest. Sorry for the false alarm. 😛

Comment entered 2021-06-10 13:36:33 by Kline, Bob (NIH/NCI) [C]

Needs further discussion for exactly how we want to implement this.

Comment entered 2021-12-03 08:29:34 by Kline, Bob (NIH/NCI) [C]

Two approaches were demonstrated in yesterday's status meeting. Please review and decide which you would prefer.

https://cdr-dev.cancer.gov/cgi-bin/cdr/DISByDrugType.py

https://cdr-dev.cancer.gov/cgi-bin/cdr/DISByDrugType2.py

Comment entered 2021-12-16 13:27:23 by Shields, Victoria (NIH/NCI) [E]

Christina and Mary prefer the first report (without the 2) where the duplicate drug types are in separate rows and they are bold.

Comment entered 2022-01-04 11:05:02 by Kline, Bob (NIH/NCI) [C]

Marking the ticket "Resolved" and removing DISByDrugType2.py.

Comment entered 2022-06-15 16:02:42 by Osei-Poku, William (NIH/NCI) [C]

Verified on DEV. Thanks!

Comment entered 2022-07-07 15:38:22 by Osei-Poku, William (NIH/NCI) [C]

Verified on QA. Thanks!

Attachments
File Name Posted User
CDR_Administration-20210609165350.xlsx 2021-06-09 16:58:57 Kline, Bob (NIH/NCI) [C]

Elapsed: 0:00:00.001956