Microvellum Community

Trouble with Filter on a Report

Hi,

I'm having an issue with a filter I cant seem to solve.  What is happening is I have it looping per specification group to fix the header information.  However its giving all subassemblies from products in both spec groups.  I want a filter to get rid of the ones that don't match.



I set up 2 Variables to equal the Run Thru spec Group and the subassembly.product.specificationgroups.name


      (Here you can see strSpecificationGroup = Framed
                                    strTempSpecificationGroup = Framed


However when I filter so expression strSpecificationGroup = strTempSpecificationGroup nothing appears.  I've ignored Drawer Fronts so something renders and I can see the splits.







Lastly, without the filter (and showing exact values)



you can see Cabinet 1 is Framed, Cabinet 4 is Framed
Cabinet 2 is Framed (2) (strTempSpecificationGroup)


Any help on this would be great, the events to get the two variables are:
      Before Print: strSpecificationGroup=SpecificationGroups.Name (From a SpecificationGroup Databand)
      Before Print: strTempSpecificationGroup=Subassemblies.Products.SpecificationGroups.Name (From a Subassembly Databand)

Thanks,

-James

    Toolbox BSB Survey



    Have you been using Toolbox BSB? We'd love to hear what you think!

    Take the Survey

      MVU eLearning



      Grow Your Knowledge
      Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


        Follow us on:

                 

          ERP for Millwork Shops


          Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.