SOMGT055 Cogs by Cat
Posted: Mon Jan 11, 2016 10:06 amHi, I wonder if it is possible to use the CASE or some other syntax to allow selection of ONE of several tables in our PASS_StartingXX formula.
In this report we can select which Category (1 to 5) to use. I have added the option of entering a Starting and Ending Category Description. Unfortunately I have had to hardcode the PASS_StartingCat table name (Select Description from IN_Category4) as I can't get it to selectively use the IN_Category(Category) selected where category is the Number selected?? Is there a way to pass this parameter??
If so this would be a very useful STANDARD report addition.
Cheers
In this report we can select which Category (1 to 5) to use. I have added the option of entering a Starting and Ending Category Description. Unfortunately I have had to hardcode the PASS_StartingCat table name (Select Description from IN_Category4) as I can't get it to selectively use the IN_Category(Category) selected where category is the Number selected?? Is there a way to pass this parameter??
If so this would be a very useful STANDARD report addition.
Cheers
