Reports for EEP based on project/alternate selection of plots
Need to allow EEP reports based on whatever plots the user wants. Best to include a button for that in customizable reports, then call the getSimpleEEPReportS() function but indicate that it shouldn't default to ALL plots. The one from the main menu would.
#1 Updated by Michael Lee over 13 years ago
The following code is a quickFix in the VisualBasic code for the following function:
Public Function getSimpleReportsEEP()
''intWhereToSendAccessExcelWord is 1 for Word, 2 for Excel, 0 for Access (not yet implemented, only goes to Excel)
''first calculate simple report", but don't open it:
On Error GoTo errThis
'get all plots:
'hacked to allow only some projects, etc, as set in customizable queries:
Dim intHackMsg As Integer
intHackMsg = MsgBox("Do you want to include all plots? You can also create a report based only on plots selected in the ""Customizable Statistics"" form." _
& Chr(13) & "Press YES for all plots, NO for ones previously selected and CANCEL to stop this (and perhaps select different plots).", _
vbYesNoCancel, "Which plots?")
If intHackMsg = vbYes Then
ElseIf intHackMsg = vbCancel Then
#2 Updated by Michael Lee over 13 years ago
You can now access the simple report functionality inside the customizable statistics form, meaning that you can get a report based on whatever plots you want, including just from one project.
Some of the code here requires that bug 2708 be fixed, so I'm adding that that bug blocks this one, even though this one is fixed if that one is ok.
#3 Updated by Michael Lee over 13 years ago
Here's what I can tell people when I email them the update:
Here is your updated database. Please use this new database for your future work and NOT your old one. When databases get copied, changes can be made to each copy separately, causing problems in having ONE BEST COPY. I'd like to avoid that situation, obviously. You can keep the old one zipped up or clearly marked as not the current copy if you like.
The fix I applied is a bit of a work around, so here's how you can get a report for each of your projects. Sorry in advanced that it's a bit quirky.
*Open the database.
*Go to the Reports Tab.
*Click the "Customizable Statistics" button.
*In that form, the first box allows you to select what plots to base your report on. Click the circle for "Only plots from selected project(s): "
*Then select (click) the project you want the report based on in the larger white box to the right of that text. You should see "Plots currently selected:" to the far right change in number to match the number of plots in the selected project.
*CLOSE THIS FORM.
*Now select "Simple Reports" on the Main Menu's Reports Tab, it will ask a new question:
Do you want to include all plots? You can also create a report based only on plots selected in the "Customizable Statistics" form. Press YES for all plots, NO for ones previously selected and CANCEL to stop this (and perhaps select different plots).
*YOU WANT TO PRESS NO. Not all plots, just the ones from the project that was selected before.
*Your report will be generated in Excel, but only with plots from that project. The first datasheet in Excel will identify which project the plots are from. Note that this Excel document is unsaved initially.