I read with interest the January 2005 Inside Sesame article ""Creating Custom Menus" and specifically setting up a command button to list and print reports.

So, I created a Report command button and it works for the most part with a couple of exceptions.

The programming is as follows:

var vReport as String      
var VReport1 as string
var vNav

//offer user choice of reports to print

vReport = @PopupMenu("407ETR Transponders (Preview);Absenteeism - YTD (Preview);Avis Preferred Wizard Numbers (Preview);Bonus Payments (Preview);
Car Drivers Licenses & Plates (Preview);Car Fleet (Preview);Car Insurance Deduction (Preview);Car Monthly Lease Costs & Tax Bfts (Preview);
Car Non Deductible Lease Costs (Preview);Car Year End GST Calcs (Preview);Consultants Home Locations (Preview);Employee Listing - Addresses (Preview);
Employee Listing - Alpha (Preview);Employee Listing - Dept (Preview);Employee Listing - Dept/Ext (Preview);Employee Listing - Golf Teams (Preview);
Employee Listing - Golf Teams Alpha (Preview);Employee Listing - Seniority (Preview);Employee Listing - Spouses (Preview);Employee Listing - Titles (Preview);
Feedback Ratings - YTD (Preview);Incent Comp - Vac/Holpay Projection (Preview);Life Insurance Taxable Benefit (Preview);Payroll Hol/Vacpay Owing - YTD (Preview);
Payroll Hol/Vacpay Paid - YTD (Preview);Payroll LOA/Brvmt/Sick - YTD (Preview);Payroll Salaries/Bonus/Quotas - YR (Preview);Qtrly Paystub Summary - MKT - QTR 1 (Preview);
Qtrly Paystub Summary - MKT - QTR 2 (Preview);Qtrly Paystub Summary - MKT - QTR 3 (Preview);Qtrly Paystub Summary - MKT - QTR 4 (Preview);
Qtrly Paystub Summary - TC/CC - QTR 1 (Preview);Qtrly Paystub Summary - TC/CC - QTR 2 (Preview);Qtrly Paystub Summary - TC/CC - QTR 3 (Preview);
Qtrly Paystub Summary - TC/CC - QTR 4 (Preview);Quota Performance - MKT - QTR 1 (Preview);Quota Performance - MKT - QTR 2 (Preview);
Quota Performance - MKT - QTR 3 (Preview);Quota Performance - MKT - QTR 4 (Preview);Quota Performance - MKT - YTD (Preview);
Quota Performance - TC/CC - QTR 1 (Preview);Quota Performance - TC/CC - QTR 2 (Preview);Quota Performance - TC/CC - QTR 3 (Preview);
Quota Performance - TC/CC - QTR 4 (Preview);Quota Performance - TC/CC - YTD (Preview);Security Keys - By Emp (Preview);Security Keys - By Key (Preview);
T4 Totals - 12 Mths Inc Comp Empl (Preview);T4 Totals - All Empl (Preview);Taxable Bfts & T4 Adjust (Preview);Telephone - Bell Call Cards (Preview);
Telephone - Cell & Bell Cards (Preview);Telephone - Home & Cell (Preview);Vacation Schedule - By Days Earn (Preview);Vacation Schedule - By Dept (Preview);
Vacation Schedule - LOA Days (Preview)", "SELECT A REPORT")

//Create the SelectTreeItem Statement

vReport1 = "Search Update Menu!Results Commands!Reports!EMPLOYEE!" + vReport

//Run the SelectTreeItem Command

vNav = @SelectTreeItem(vReport1)

vNav=""
vReport1=""
vReport=""


Two problems: First, reports at the begiining of the next line of programming do not work.  i.e: Car Drivers Licenses & Plates, Car non deductible Lease Costs, etc. They appear on the pop up menu but do not run. This is consistent throughout.  Does the programming have to be all on one line ? I would hit enter to start a new line so that I could see all the info on screen.

Second, it appears that where the report name is very lengthy, an arrow appears showing the balance of the name.  In some cases they do not work which could be related to problem 1 above.  Also, is there a way to enlarge the pop up menu so that it fits the entire name of the report ?

Thanks,

Louis

Quote:


It's not the length, it the slash character (/). The slash tells the popup menu to create a submenu. To have a slash character appear on the menu as a slash, you have to double it (//).

BTW, you may not be aware of this,  but it is an internet convention that typing all in caps means you are yelling at someone. If you are not intended to scream your subject lines at us, you might consider turning off your caps lock key. 

Quote:


Yes, but you do this by passing a single semicolon separated string of report names to @PopupMenu.

To break the assembly of this string onto multiple lines of code so it is easier to read, you use + to tack them together instead of pressing Enter in the middle and breaking your string. In your case, you would do:

var vReports as String

vReports = "ReportName1;ReportName2;ReportName3;"
vReports = vReports + "ReportName4;ReportName5;ReportName6;"
vReports = vReports + "ReportName7;ReportName8;ReportName9"

vReport = @PopupMenu(vReports, "SELECT A REPORT")

Quote:


@LoadRetrieveSpec()