Project

General

Profile

Bug #2906

DBA: reports could be improved

Added by Michael Lee over 11 years ago. Updated almost 10 years ago.

Status:
New
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
08/17/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2906

Description

Would be nice to allow printing of full plots for plots that have some issue (a check box somewhere on the DBA form, perhaps) which would then change criteria to plotID in (select plotID from [somewhere] WHERE (the criteria));

ordering by plotID in the reports is problematic: this is order they were entered, not logical order. Should be switched to PTP.

duplText is not highlighted any colour on the report, which is odd. Should be yellowish and errors pink to draw attention to these locations when there are errors or duplicate messages.

History

#1 Updated by Michael Lee about 11 years ago

to print the full plot, if errors or duplicates are there, use this code:

dba_linkToCoverStemData (new case):
Case "full plot if plot has errs/dups"
strMessage = "Full plot if plot has any errors or duplicates on it."

strCrit = "plotID in (Select PlotsWithErrs.plotID from [entry_" & strCovStem & "] as PlotsWithErrs where nz(PlotsWithErrs.[duplicate],0)<>0 OR len(PlotsWithErrs.[errors])>0)" 
If strCovStem = "stems" Then 'omit modules:
strCrit = "((module<>""R"") and plotID in (Select PlotsWithErrs.plotID from [entry_" & strCovStem & "] as PlotsWithErrs where PlotsWithErrs.module <> ""R"" AND (nz(PlotsWithErrs.[duplicate],0)<>0 OR len(PlotsWithErrs.[errors])>0)))"
End If

in dba_linkToCoverStemData()

#2 Updated by Michael Lee about 11 years ago

Report Header needs to stretched down so that info still appears about cover module/corner. DuplText just needs to have colored background.

#3 Updated by Michael Lee about 11 years ago

Might be nice to suppress notes unless there is error/duplicate.

#4 Updated by Michael Lee about 11 years ago

Most of this is resolved as of version:
CVS_EEP_DataEntryTool_v221p5_post

Stuff not resolved:
  • ordering by plotID in the reports is problematic: this is order they were
    entered, not logical order. Should be switched to PTP.
  • Report Header needs to stretched down so that info still appears about cover
    module/corner. (workaround in place, extra space there)
  • Might be nice to suppress notes unless there is error/duplicate.

#5 Updated by Redmine Admin over 5 years ago

Original Bugzilla ID was 2906

Also available in: Atom PDF