Does currently selected menu have a stored variable, setting or field?
Something along the line of [:ScreenMenuName] or {:ScreenMenu} or something similar?
Does currently selected menu have a stored variable, setting or field?
Something along the line of [:ScreenMenuName] or {:ScreenMenu} or something similar?
In case you cant figure it just like me, use SQL query from the [:MenuItemName]
or Id {REPORT MENU ITEM DETAILS:M.Id:M.Name == "[:MenuItemName]"}
Code:
{REPORT SQL DETAILS:SELECT TOP 1
ScreenMenus.Name AS ScrenMenu,
ScreenMenus.Id AS MenuId,
ScreenMenuCategories.Name AS CategoryName,
ScreenMenuCategories.Id AS CategoryId,
ScreenMenuCategories.ScreenMenuId AS SMenuId,
ScreenMenuItems.Name As ScreenItemName,
ScreenMenuItems.MenuItemId AS ScreenItemId,
ScreenMenuItems.ScreenMenuCategoryId AS ScreenItemCat
FROM ScreenMenus
INNER JOIN ScreenMenuCategories ON ScreenMenuCategories.ScreenMenuId = ScreenMenus.Id
INNER JOIN ScreenMenuItems ON ScreenMenuItems.ScreenMenuCategoryId = ScreenMenuCategories.Id
WHERE ScreenMenuItems.Name = '[:MenuItemName]'}
One liner:
{REPORT SQL DETAILS:SELECT TOP 1 ScreenMenus.Name AS Name,ScreenMenus.Id AS MenuId,ScreenMenuCategories.Name AS CategoryName,ScreenMenuCategories.Id AS CategoryId,ScreenMenuCategories.ScreenMenuId AS SMenuId,ScreenMenuItems.Name As ScreenItemName,ScreenMenuItems.MenuItemId AS ScreenItemId,ScreenMenuItems.ScreenMenuCategoryId AS ScreenItemCat FROM ScreenMenus INNER JOIN ScreenMenuCategories ON ScreenMenuCategories.ScreenMenuId = ScreenMenus.Id INNER JOIN ScreenMenuItems ON ScreenMenuItems.ScreenMenuCategoryId = ScreenMenuCategories.Id WHERE ScreenMenuItems.Name = '[:MenuItemName]':F.Name::,}
{:CURRENTMENU} should work for you.
Haha, now you tell me!