SOMGT055 Cogs by Cat

[2can2]

Hi, 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

[Scott.Pearce]

This is not possible.

[2can2]

Ok pity. Thanks